topic Re: How to output summary statistics into a SAS table in SAS Enterprise Guide

How to output summary statistics into a SAS table

teg_76 — Fri, 17 Oct 2014 19:06:44 GMT

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

Re: How to output summary statistics into a SAS table

Reeza — Fri, 17 Oct 2014 19:17:32 GMT

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.

Re: How to output summary statistics into a SAS table

teg_76 — Fri, 17 Oct 2014 19:43:27 GMT

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

Re: How to output summary statistics into a SAS table

Reeza — Fri, 17 Oct 2014 20:23:27 GMT

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?