topic Re: Proc Means/Summary/Tabulate/???? in Statistical Procedures

Proc Means/Summary/Tabulate/????

aj34321 — Wed, 13 Feb 2013 20:28:19 GMT

Dear All,

I'm pretty new to SAS and i'm having a confusion with one of my query. I have a data structure as mentioned below and need summarised output and i'm simply confused with which proc function this can be done and how.

I have below this table

Name - Prod

A1 - CC

A2 - CC

A3 - LN

A1 - CC

A3-ST

A1-CC

A2-LN

A3-CC

A1-LN

A1-CC

My output should be

Name CC LN ST

A1 4 1 0

A2 1 1 0

A3 1 1 1

Pls anyone can help me with code...

Thanks a lot...

Rgds, Anil

Re: Proc Means/Summary/Tabulate/????

ballardw — Wed, 13 Feb 2013 20:47:59 GMT

Either Proc freq or tabulate would do. The syntax for freq is probably simpler:

proc freq data=yourdatasetname;

tables name*prod/ norow nocol nocum nopercent;

run;

Re: Proc Means/Summary/Tabulate/????

aj34321 — Wed, 13 Feb 2013 20:59:05 GMT

Shaks.. that's it.. just a single line of code and its done.. and i was breaking my head last 3 hours trying so many variations... Thanks a lot Ballard.. Now just one more small query in addition to it..

I also have one more column for LN & ST which mentions amount and i want to sum them for each name....

Thanks once again...

Rgds, Anil

Re: Proc Means/Summary/Tabulate/????

Rick_SAS — Wed, 13 Feb 2013 21:42:17 GMT

Sounds like you want to include a WEIGHT statement:
proc freq ....;

WEIGHT amount;
tables ....;

run;