topic Output format in SAS Programming

Output format

anonymous_user — Fri, 05 Sep 2014 11:24:38 GMT

Currently my output will display like this

Count Age

Jan 14 12 20-25

Jan 14 66 30-50

Jan 14 67 50+
Feb 14 2 20-25

Feb 14 105 30-50

Feb 14 61 50+

I want it to display

Age Jan 14 Feb 14

20-25 12 2

30-50 66 105

50+ 67 61

Any idea how to do this within my code?

Re: Output format

Jagadishkatam — Fri, 05 Sep 2014 11:49:41 GMT

Please try

proc sort data=have;

by age;

run;

proc transpose data = have out=want;

by age;

id date;

var count;

run;

Thanks,

Jag

Re: Output format

stat_sas — Fri, 05 Sep 2014 11:51:49 GMT

proc tabulate data=have;

class month age;

var count;

table age,month=' '*count=' '*sum=' '*f=8.0;

run;

Re: Output format

Ksharp — Fri, 05 Sep 2014 13:45:17 GMT

data have;
input date & monyy10. Count       Age $;
format date monyy.;
cards;
Jan 14          12         20-25
Jan 14          66         30-50
Jan 14          67         50+
Feb 14          2          20-25
Feb 14         105        30-50
Feb 14          61         50+
;
run;
proc sort data=have(keep=date) out=temp nodupkey;by date;run;
data _null_;
 set temp end=last;
 if _n_ eq 1 then call execute('data want(drop=date); merge ');
 call execute(cats('have(where=(date=',date,') rename=(count=',put(date,monyy.),'))'));
 if last then call execute(';by age;run;');
run;

Xia Keshan