Thank you for help. If I use my code where you mentioned to use. Does it work for values 'Un/jun/2012' . My code removes 'un' in jun. Please help.   ... View more

Thank you. I found why. I used Length(date) to find why. When the date is missing,  the length are 1 and 10 in these datasets. I fixed the lengths and it worked. ... View more

Thanks for the help. It worked. I am attaching the sample output. Why my column names are not alligning with column values. Also the underline beneath titration phase and stable phase should be 2 separate lines as per the code. why it is a continous line. Please help. Thank you.   code   proc report data=one3 center headskip nowd missing split='|' style(report)={outputwidth=90% cellpadding=3 frame=above} style(header)={font_weight=bold fontsize=9pt fontstyle=ROMAN} style(lines)={cellpadding=1 fontsize=3pt}; column grpm grps grpws aetext ("^R'\brdrb\brdrs\brdrw10 'Titration Phase" cnt_pct1 cnt_pct2 cnt_pct3 cnt_pct4) ("^R'\brdrb\brdrs\brdrw10 '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/ "System Organ Class|Preferred Term, n (%)" style(column)={asis=on cellspacing=.25pt just=left} ; define cnt_pct1/ "00 mg|N=19" style(column)={cellspacing=.25pt just=left} ; define cnt_pct2/ "000 mg|N=26" style(column)={cellspacing=.25pt just=left} ; define cnt_pct3/ "000 mg|N=35" style(column)={cellspacing=.25pt just=left} ; define cnt_pct4/"-000|N=80" style(column)={cellspacing=.25pt just=left}; define cnt_pct5 / "00 mg|N=12" style(column)={cellspacing=.25pt just=left} ; define cnt_pct6/ "000 mg|N=19" style(column)={cellspacing=.25pt just=left}; define cnt_pct7/ "000 mg|N=31" style(column)={cellspacing=.25pt just=left}; define cnt_pct8/"_110|N=62" style(column)={cellspacing=.25pt just=left} ; run; ... View more

Thanks for your reply. My data  set looks like this. The variables are (aetext v1 v2 v5 v6). Does youR code for this to get the output i need.   data   aetext                 v1                  v2                     v5                           v6 NS                     N=2               N=5                  N=5                        N=7 DISORDER        10 (50)        11(20)               20 (30)               21(30)   Output need;     _________________________________________________                                                    P1                                         P2                                          __________                            ___________                                                                                           v1         v2                              v5        v6        NS                                 n=2       n=5                           n=5       n=7 _________________________________________________________      DISORDER                  10 (50)      11(20)                     20 (30)    21(30) ____________________________________________________________     ... View more

Dear,   Thanks for the help. I almost very close to getting the output I need. But one more issue. I need to have the second  underline after first row of values . I am attaching a sample document showing my output and the output I need. Please help in my code. The code that I am using is the one posted in the forum   %macro fontSpecs(); FONT_FACE = "SAS Monospace" FONT_SIZE = 7pt FONT_WEIGHT = medium FONT_STYLE = roman FOREGROUND = black BACKGROUND = white %mend; proc template; define style mystyle; parent = Styles.rtf; STYLE Continued from Continued/ pretext="" font=("SAS Monospace", 0pt) width=0% FOREGROUND=white; STYLE parskip from parskip / font =("Arial", 1pt); STYLE SystemTitle / %fontSpecs(); STYLE Header / %fontSpecs() ; STYLE Data / %fontSpecs() ; STYLE SystemFooter / %fontSpecs(); STYLE Table / %fontSpecs() BORDERWIDTH = 1 CELLSPACING = 0pt CELLPADDING = 0pt FRAME = ABOVE RULES = GROUPS ; STYLE SysTitleAndFooterContainer / CELLSPACING=0; end; run; title1 justify=right 'page ^{pageof}'; title2 ""; ods listing close; ods escapechar="^"; ods tagsets.rtf file="C:\test.rtf" style=mystyle; data one; do aetext = 1 to 10; "cnt_pct1"= aetext ** 2; "cnt_pct2" = aetext ** 3; "cnt_pct3"= aetext ** 4; "cnt_pct4" = aetext ** 5 "cnt_pct5"= aetext ** 5; "cnt_pct6" = aetext ** 6; "cnt_pct7"= aetext ** 7; "cnt_pct8" = aetext ** 8;output; end; run; proc report data=all2 nowindows missing split='|' contents='' style(column)={foreground=black cellspacing=1 just=C VJUST=M } style(report)=[font_face='SAS Monospace'] ; column grpm grps grpws aetext ("^R'\brdrb\brdrs\brdrw15 'JZP-110 Titration Phase" cnt_pct1 cnt_pct2 cnt_pct3 cnt_pct4) ("^R'\brdrb\brdrs\brdrw15 'JZP-110 Stable Dose Phase" cnt_pct5 cnt_pct6 cnt_pct7 cnt_pct8); %macro heaColStyle(hjust, cjust, width); DISPLAY style(header)=[font_face='SAS Monospace' just=&hjust.] style(column)=[font_face='SAS Monospace' cellwidth=&width.cm just=&cjust.] %mend; 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/"Combined " 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/"Combined " style(column)={cellspacing=.25pt just=left} ; run; ods tagsets.rtf close; ods listing ; footnote1 "."; footnote2 "Source: "; footnote3 "Program Name: ";     ... View more

Thanks. That helped me. I need one more help. If possible can you help in my code to produce output I need(Similar to Vendor data). i am attaching two word documents with one my output and one vendor output. Please help   My code; OPTIONS nodate nonumber noquotelenmax; ods listing close; ods escapechar="^"; title1 justify=right 'page ^{pageof}'; title2 " Treatment-Emergent Adverse Events (TEAEs) Occurring in >=5% of Subjects in Any Treatment Group with Onset Pre-Randomization by System Organ Class and Preferred Term (Safety Population)"; footnote1 "Note: Adverse events are coded using the Medical Dictionary for Regulatory Activities (MedDRA), Version 18.0. Percentages are based on N, number of subjects within each treatment group in the analysis population who took study drug before randomization. Multiple entries for an individual under system organ class/preferred term are only counted once."; footnote2 "Source: Reference Listing 16.2.7.1"; footnote3 "Program Name: t-14-03-01-02-01a.sas Table Generation: 07JUL2016 13:12"; options orientation=landscape formchar="|----|+|---+=|-/\<>*"; ods rtf file="C:\Users\\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/"Combined JZP-110 " 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/"Combined JZP-110 " 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;   ... View more

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 ... View more