how to display monthly,yearly,qtr format

[neha25]

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

[RW9]

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;

[neha25]

thanks for ur speedy response.