How to output summary statistics into a SAS table

[teg_76]

Hi,

I'm running some summary statistics in EG on a SAS dataset.  I'd like each of the groups within the dataset that are being analyzed to output to have their results output to their own SAS dataset.  Is this possible?  Any ideas on how to do this?

Thank you,

Tom

[Reeza]

I don't know if you can do that without code in EG, but can I ask why? Usually more efficient to leave in BY groups, especially if you're going to do further processing.

[teg_76]

Thanks Reeza.  I'd like to merge each of the groups back together based on an ID field, which I'm doing righ tnow in excel after exporting the results.  So I currently have summary stats outputing by multiple groups, and I'd like to bring them back together based on an id field.  I uploaded an example.  I'm basically trying to save myself time from doing all the vlookups in excel.

Tom

[Reeza]

Post what your input data set looks like and what you want the FINAL output to look like.

You don't have the ID field in SAS already?