Hello Chris.
I always do subqueries using the approach you describe above. But after installing SAS EG 7.1, I can't get it to work. When I try to use template in a Query Builder task, I get an error.
I still have SAS EG 5.1 on my machine, and it works fine there. I can also create a project using subquery in 5.1, open it in 7.1 and run it.
Do you know anything about it?

Error is as follows:

Exception Details:
----------------------------------------
Exception type: SAS.EG.SDS.SDSException
Message: Server-udførelse mislykkedes

Source: SAS.EG.SDS.Model
Target Site: SASWorkspace

Stack Trace:
at SAS.EG.SDS.Model.Server.SASWorkspace()
at SAS.EG.ProjectElements.Forms.FilterBasicPage.LaunchSubqueryUI(String templateName, String templateXML)
at SAS.EG.ProjectElements.Forms.FilterBasicPage.ShowValuePicker(Control ctrlToUse)
at SAS.EG.ProjectElements.Forms.FilterBasicPage.cmdAddToList_Click(Object sender, EventArgs e)

Best regards, Olga Kazarina.