Help using Base SAS procedures

proc report amounts in line instaed of column

Reply
Frequent Contributor
Posts: 117

proc report amounts in line instaed of column

PROC REPORT DATA = work.T5 nowd ;
	column  GENERATION periode_month , (mnt_1 mnt_2)     ;
	define GENERATION / group  ; 
	define periode_month / across ''  ;
	define mnt_1  /  'indic1' f=12.2 ;
	define mnt_2/ 'indic2  f=12.2  ;
	title ;
  	RUN ;

Good Morning,

 

 

by launching this code, in the output result the 2 indicators are in columns like photo1

I would like indicators on two lines like photo2photo1.PNGphoto2.PNG

 

thanks a lot in advance for your help

regard,

Nasser

Super User
Super User
Posts: 9,599

Re: proc report amounts in line instaed of column

Posted in reply to Nasser_alfea

Do your calculation in a simple datastep before the proc report, then proc report your data.  Proc report, whilst having some functionality regarding sums isn't the best tool for the job.  As for exact code, no idea what the data originally looks like so cant really say.

Super User
Posts: 10,770

Re: proc report amounts in line instaed of column

Posted in reply to Nasser_alfea
Better post some data to test code. and Better post it at REPORT forum. @Cynthia is there.


Super User
Super User
Posts: 8,089

Re: proc report amounts in line instaed of column

Posted in reply to Nasser_alfea

Looks like you need to convert your data into multiple rows instead of multiple columns.

data have ;
  do generation=2008,2009;
    do month='201601','201602';
      do indication='indict1','indict2';
      input amount @@;
      output;
      end;
    end;
  end;
cards;
3687 345 3590 4058 4681 637 455 4118
;

proc report ;
  column generation indication amount,month ;
  define generation / group ;
  define indication / group ;
  define month / across ;
  define amount / sum ' ' ;
run;

image.png

Ask a Question
Discussion stats
  • 3 replies
  • 127 views
  • 0 likes
  • 4 in conversation