topic PROC FREQ syntax issue in SAS Programming

PROC FREQ syntax issue

brulard — Thu, 31 Aug 2017 16:13:13 GMT

hi,

Having some issue populating a summary table by date. Specifically, I would like each value under variable STATUS to appear horizontally. Is this possible with PROC FREQ?

Example data:

Data table1;

FORMAT DATE $12. STATUS $2.;

Input DATE STATUS ;

Datalines;

01MAR2017 DU

01MAR2017 FI

01MAR2017 TU

01MAR2017 Z1

02MAR2017 DU

02MAR2017 FI

02MAR2017 TU

02MAR2017 Z1

Run;

Would like output table to look like this:

DATE DU FI TU ZI

01MAR2017 3 2 2 2

02MAR2017 1 1 1 1

Proc Freq code

proc FREQ data=table1 NOPRINT;
TABLES Date * Status  /norow nocol NOPERCENT OUT=table2; 
RUN;

Thank you

Re: PROC FREQ syntax issue

Astounding — Thu, 31 Aug 2017 15:55:55 GMT

How is this basic table different from what you desire?

tables date * status;

Re: PROC FREQ syntax issue

Reeza — Thu, 31 Aug 2017 16:01:02 GMT

Yes it's possible.

Re: PROC FREQ syntax issue

brulard — Thu, 31 Aug 2017 16:08:15 GMT

thanks, tried that but the column is still listed "STATUS" with each value listed below, by date

Re: PROC FREQ syntax issue

Reeza — Thu, 31 Aug 2017 16:15:36 GMT

Post your code.

Re: PROC FREQ syntax issue

brulard — Thu, 31 Aug 2017 16:20:46 GMT

i have ...

proc FREQ data=table1 NOPRINT;
TABLES Date * Status  /norow nocol NOPERCENT OUT=table2; 
RUN;

Thanks

Re: PROC FREQ syntax issue

Astounding — Thu, 31 Aug 2017 16:25:11 GMT

OK, I think I get what you are asking for now. Continue, adding to your program after the PROC FREQ:

proc transpose data=table2 out=want;

var count;

id status;

by date;

run;

You might need to drop _NAME_ from the result, but the pieces should now align the way you are asking.

Re: PROC FREQ syntax issue

brulard — Thu, 31 Aug 2017 16:30:00 GMT

awesome, thanks!