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.
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.