Proc report procedure output

knveraraju91 — Tue, 20 Sep 2016 19:59:30 GMT

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;

Re: Proc report procedure output

Reeza — Tue, 20 Sep 2016 20:07:33 GMT

Sample data?

Re: Proc report procedure output

knveraraju91 — Tue, 20 Sep 2016 20:17:12 GMT

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

topic Re: Proc report procedure output in ODS and Base Reporting

Proc report procedure output

Re: Proc report procedure output

Re: Proc report procedure output