SAS EG Multiple Output Query

[KMoran]

I have a dataset in EG that I would like to query by and Id variable.  I know that I can create separate query builders for each variable to get a dataset for each variable.  However, there are 20 different variables.  Is there are way to do this in one query with multiple dataset outputs by the id variable?  I do not want to have to select with prompts.  Thanks!

[Doc_Duke]

I think that you would have to write DATA step code to do that in one pass of the data.

[KMoran]

That's what I thought.  Thanks so much!