DATA Step, Macro, Functions and more

PROC REPORT gap

Reply
Occasional Contributor
Posts: 18

PROC REPORT gap

[ Edited ]

 

Hi,

 

Anyone know if it's possible to seal the gap (highlighted below) in PROC REPORT (non ODS)? BC the first column is using "flow" option it is creating a space for all columns, thank you all.

 

proc report.PNG

 

data tr;
  merge adsl 
        adtr;
   by subjid;
   subject= trim(siteid)||'/'||trim(subjid)||'/~'||strip(age)||'/'||trim(sex)||'/'||trim(race)||'/~'||trim(TRT01a);
run;


proc report data=tr missing headskip headline  split='~' nowindows missing spacing=1; 
    column  subject  trtsdt visit adt ady  _base  _aval  _chg pchg;

   define subject     / width=31 "Site/Subject ID/~Age/Sex/Race/~Study Treatment"  order order=data flow left;
   define visit       / width=20 "Visit"             	    	                    center;
   define adt         / width=11 "Study Date"             			    center;
   define trtsdt      / width=10 "First~Dose~Date"                 order order=data center;
   define trtedt      / width=9  "Date of Last Treatment Exposure"                  center;
   define tr01sdt     / width=9  "Date of First Exposure in Period 01"              center;
   define tr01edt     / width=9  "Date of Last Exposure in Period 01"               center;
   define _base       / width=11 "Baseline~Lesion~Measurement"     order order=data center;
   define basecount   / width=4  "Base~Count"             		            center;
   define _aval       / width=12 "On Treatment~Lesion~Measurement"                  center;
   define lesnumber   / width=8  "Lesion #"              			    center;
   define ady         / width=5  "Study Day"           				    center;
   define ablfl       / width=5  "ablfl"              				    center;
   define _chg        / width=8  "Change"              				    center;
   define pchg        / width=8  "% Change"             			    center;

   break after subject/ skip;
 run;



 

PROC Star
Posts: 2,230

Re: PROC REPORT gap

Posted in reply to HitmonTran

 

What you are requesting several rows in the right-hand columns go across one single row in the first column.
Proc tabulate is more suited to this exercise.

Ask a Question
Discussion stats
  • 1 reply
  • 89 views
  • 0 likes
  • 2 in conversation