BookmarkSubscribeRSS Feed
neha25
Calcite | Level 5

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
2 REPLIES 2
RW9
Diamond | Level 26 RW9
Diamond | Level 26

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
Calcite | Level 5

thanks for ur speedy response.

 

sas-innovate-2024.png

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.

 

Register now!

How to Concatenate Values

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 2 replies
  • 662 views
  • 1 like
  • 2 in conversation