i want to display out put in the below format
output 1
year 97 year 98
jan
feb
mar
april
may
jun
july
aug
sep
oct
nov
dec
output 2
year jan feb mar april may jun july aug sep oct nov dec
97
98
output 3
in qtrs
output 4
actul-predit.
i am attaching sample sheet (from sashelp.prdsal3 library)
thanks in advance and plz do reply on early basis
Hi,
Have to goto meetings now, here is where I had got to, you can proc report the various dataset outputs:
proc sql; create table OUT as select YEAR, mdy(month(MONTH),1,2000) as MONTH format=monname3., sum(ACTUAL) as RES from SASHELP.PRDSAL3 group by YEAR,MONTH; quit; proc sort data=out; by month year; run; proc transpose data=out out=output1 prefix=year; by month; var res; id year; run; proc sort data=out; by year month; run; proc transpose data=out out=output2; by year; var res; id month; run;
thanks for ur speedy response.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.