topic Re: how to display monthly,yearly,qtr format in SAS Programming

how to display monthly,yearly,qtr format

neha25 — Tue, 18 Apr 2017 08:15:01 GMT

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

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

Re: how to display monthly,yearly,qtr format

RW9 — Tue, 18 Apr 2017 08:52:08 GMT

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;

Re: how to display monthly,yearly,qtr format

neha25 — Tue, 18 Apr 2017 10:38:07 GMT

thanks for ur speedy response.