BookmarkSubscribeRSS Feed
knveraraju91
Barite | Level 11

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;

2 REPLIES 2
Reeza
Super User

Sample data?

knveraraju91
Barite | Level 11

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

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
  • 951 views
  • 0 likes
  • 2 in conversation