topic Re: need help with summarizing data in SAS Procedures

need help with summarizing data

sasbasls — Thu, 30 Aug 2012 06:09:12 GMT

Hi,

I need help on how to summarize data by no of observations. For ex: I have data by customer segment and I want to see how many customers are there in each of segment (count), how can I do using proc summary.

thanks,

sasbase

Re: need help with summarizing data

Ksharp — Thu, 30 Aug 2012 07:04:51 GMT

It is easy for proc summary.

proc summary data=have nway;

class segment;

output out=want n=how_many;

run;

Re: need help with summarizing data

sasbasls — Thu, 30 Aug 2012 11:45:16 GMT

What does n = how_many represent ? How can I get "how_many" ?

I used something like this :

PROC SUMMARY DATA=have missing NWAY;

CLASS var1 var 2 var 3 ;

ways 3 ;

OUTPUT OUT=want (DROP= _TYPE_)

;

RUN;

and then used _freq_ variable from above proc step to see as no of observations.

thanks,

sasbase

Re: need help with summarizing data

PaigeMiller — Thu, 30 Aug 2012 12:05:45 GMT

What does n = how_many represent ? How can I get "how_many" ?

N=HOW_MANY creates a data set variable named HOW_MANY in SAS data set WANT that contains N (the count of the number of observations in each group).

You access HOW_MANY the same way you access any data step variable.

Re: need help with summarizing data

Astounding — Thu, 30 Aug 2012 13:55:56 GMT

Is there some reason you have to use PROC SUMMARY to accomplish this? PROC FREQ is built for this task:

proc freq data=have;

tables segment / missing;

run;

Good luck.

Re: need help with summarizing data

PaigeMiller — Thu, 30 Aug 2012 14:05:41 GMT

Astounding wrote:

Is there some reason you have to use PROC SUMMARY to accomplish this? PROC FREQ is built for this task:

I would claim that PROC SUMMARY is also built for this task (as well as other tasks)