topic SAS EG Multiple Output Query in SAS Enterprise Guide https://communities.sas.com/t5/SAS-Enterprise-Guide/SAS-EG-Multiple-Output-Query/m-p/78260#M7718 <HTML><HEAD></HEAD><BODY><P>I have a dataset in EG that I would like to query by and Id variable.&nbsp; I know that I can create separate query builders for each variable to get a dataset for each variable.&nbsp; However, there are 20 different variables.&nbsp; Is there are way to do this in one query with multiple dataset outputs by the id variable?&nbsp; I do not want to have to select with prompts.&nbsp; Thanks!</P></BODY></HTML> Wed, 26 Sep 2012 18:52:57 GMT KMoran 2012-09-26T18:52:57Z SAS EG Multiple Output Query https://communities.sas.com/t5/SAS-Enterprise-Guide/SAS-EG-Multiple-Output-Query/m-p/78260#M7718 <HTML><HEAD></HEAD><BODY><P>I have a dataset in EG that I would like to query by and Id variable.&nbsp; I know that I can create separate query builders for each variable to get a dataset for each variable.&nbsp; However, there are 20 different variables.&nbsp; Is there are way to do this in one query with multiple dataset outputs by the id variable?&nbsp; I do not want to have to select with prompts.&nbsp; Thanks!</P></BODY></HTML> Wed, 26 Sep 2012 18:52:57 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/SAS-EG-Multiple-Output-Query/m-p/78260#M7718 KMoran 2012-09-26T18:52:57Z Re: SAS EG Multiple Output Query https://communities.sas.com/t5/SAS-Enterprise-Guide/SAS-EG-Multiple-Output-Query/m-p/78261#M7719 <HTML><HEAD></HEAD><BODY><P>I think that you would have to write DATA step code to do that in one pass of the data.</P></BODY></HTML> Thu, 27 Sep 2012 14:17:38 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/SAS-EG-Multiple-Output-Query/m-p/78261#M7719 Doc_Duke 2012-09-27T14:17:38Z Re: SAS EG Multiple Output Query https://communities.sas.com/t5/SAS-Enterprise-Guide/SAS-EG-Multiple-Output-Query/m-p/78262#M7720 <HTML><HEAD></HEAD><BODY><P>That's what I thought.&nbsp; Thanks so much!</P></BODY></HTML> Thu, 04 Oct 2012 15:26:26 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/SAS-EG-Multiple-Output-Query/m-p/78262#M7720 KMoran 2012-10-04T15:26:26Z