Desktop productivity for business analysts and programmers

How to output summary statistics into a SAS table

Reply
Contributor
Posts: 41

How to output summary statistics into a SAS table

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

Super User
Posts: 19,167

Re: How to output summary statistics into a SAS table

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.

Contributor
Posts: 41

Re: How to output summary statistics into a SAS table

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

Super User
Posts: 19,167

Re: How to output summary statistics into a SAS table

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?

Ask a Question
Discussion stats
  • 3 replies
  • 303 views
  • 0 likes
  • 2 in conversation