DATA Step, Macro, Functions and more

how to display monthly,yearly,qtr format

Reply
New Contributor
Posts: 2

how to display monthly,yearly,qtr format

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

 


data_type.PNG
Super User
Super User
Posts: 7,401

Re: how to display monthly,yearly,qtr format

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;
New Contributor
Posts: 2

Re: how to display monthly,yearly,qtr format

thanks for ur speedy response.

 

Ask a Question
Discussion stats
  • 2 replies
  • 113 views
  • 1 like
  • 2 in conversation