The SAS Output Delivery System and reporting techniques

Proc report procedure output

Reply
Super Contributor
Posts: 263

Proc report procedure output

Dear,

 

I need help in reproducing a table. I am attaching a document containg header part of Base(vendor data) and my output. Please help in my code to produce the exactly like one in base, especially underline that separate parts of the table. Thank you.

 

My code:

OPTIONS nodate nonumber;
ods listing close;
ods escapechar="^";
title1 justify=right 'page ^{pageof}';
title2 "Table 14.3.1.1 Treatment-Emergent Adverse Event Frequency by Treatment -";

title3 "Number of Subjects Reporting the Event (% of Subjects Dosed) (Safety Population)";
footnote1 "Note: Adverse events (AEs) were coded with MedDRA Version 18.0.";
footnote2 "Program: /CA17139/sas_prg/stsas/tab/adam_tblae1a_auto.sas 16DEC2015 12:16";
footnote2 " %sysget(sas_execfilepath) &sysdate. &systime.";
options orientation=landscape formchar="|----|+|---+=|-/\<>*";

ods rtf file="C:\Users\vvemireddy\Desktop\ae_1.rtf" style=journal;
proc report data=all2 nowd headline headskip style(report)=[frame=void];
column grpm grps grpws aetext ("JZP-110 Titration Phase" "_______________" cnt_pct1 cnt_pct2 cnt_pct3 cnt_pct4) ("JZP-110 Stable Dose Phase" "_______________" cnt_pct5 cnt_pct6 cnt_pct7 cnt_pct8);
define grpm/order noprint;
define grps/order noprint;
define grpws/order noprint;
define aetext/ display '' style(column)={asis=on cellspacing=.25pt just=left};
define cnt_pct1/ "75 mg" style(column)={cellspacing=.25pt just=left};
define cnt_pct2/ "150 mg" style(column)={cellspacing=.25pt just=left} ;
define cnt_pct3/ "300 mg" style(column)={cellspacing=.25pt just=left};
define cnt_pct4/"TOTAL" style(column)={cellspacing=.25pt just=left} ;
define cnt_pct5 / "75 mg" style(column)={cellspacing=.25pt just=left};
define cnt_pct6/ "150 mg" style(column)={cellspacing=.25pt just=left} ;
define cnt_pct7/ "300 mg" style(column)={cellspacing=.25pt just=left};
define cnt_pct8/"TOTAL" style(column)={cellspacing=.25pt just=left} ;
compute after grpm/style={protectspecialchars=off};
n+1;
len=ifn(n=1,20,0);
dummy='\brdrt\brdrs';
line dummy $varying20. len;
endcomp;
run;
ods rtf close;

Grand Advisor
Posts: 16,265

Re: Proc report procedure output

Sample data?

Super Contributor
Posts: 263

Re: Proc report procedure output

Dear,

 

I am attaching a part of my output. If this is not sufficient I may have to send a part of my vendor data. Thank you

Post a Question
Discussion Stats
  • 2 replies
  • 338 views
  • 0 likes
  • 2 in conversation