Hello,     I used the macro (http://pharma-sas.com/a-sas-macro-to-combine-portrait-and-landscape-rtf-files-into-one-single-file/) on one scenario and found the page number did not keep the original one. Instead pages is from 1 to N where N is the number of total pages of combined RTF file. The reason I suspect is that RTF code when opened in NotePad++ contains page information like this  \fldinst { PAGE }}}{ of }{\field{\*\fldinst { NUMPAGES }}} . And this is probably due to fact that RTF code "^{pageof}" in used in proc report in SAS program to create the RTF file.     Can someone help? ... View more

Hi, I have a Highlow plot for AEDECOD in term of study days for AE (AESTDY). I also want to add different treatment periods as a background using Block plot. After reading Sanjay's "The Block Plot" (https://blogs.sas.com/content/graphicallyspeaking/2014/04/14/the-block-plot/) I still did not know how to make it work. (1) I did not merge both datasets, instead I set them. (2) since EX did have periods without any treatment, I did not know how to reflect it. For example, dose 225ug starts day 1 and ends day 67. Next dose 75ug actually starts day 88. Ideally I would like day 68 to 87 to be blank in the graph. But current code did not do that.   Below is the code. Thanks a lot for help!   data ae; length USUBJID AEDECOD $200; USUBJID='subj1'; AEDECOD='Nasopharyngitis';aestdy=18;aeendy=26;output; AEDECOD='Sinusitis';aestdy=90;aeendy=105;output; AEDECOD='Headache';aestdy=176;aeendy=178;output; run; data ex; length USUBJID dose $200; USUBJID='subj1'; dose='225ug';exstdy=1;exendy=67;output; dose='75ug';exstdy=88;exendy=148;output; dose='225ug';exstdy=175;exendy=177;output; run; proc sort data=ae;by USUBJID aestdy;run; proc sort data=ex;by USUBJID exstdy;run; data ae_ex; set ae ex; run; proc sgplot data=ae_ex; block x=exstdy block=dose/name='EX' transparency=0.5 /* valueHalign=center valueValign=top */ /* FillType=alternate AltFillAttrs=(transparency=1)*/ ; highlow y=AEDECOD high=aeendy low=aestdy/type=bar barwidth=0.8 fillattrs=(color=yellow); yaxis grid display=(noticks nolabel) valueattrs=(color=gray size=10pt) ; xaxis grid label="Study Days" labelattrs=(color=black size=10pt) valueattrs=(color=gray size=10pt) offsetmax=0.02 values=(-10 to 190) ; run; ... View more

Hi,    I created a simple AE example to show my problems. In SGPlot for highlow, y=AEDECOD. When y axis option of display "novalues" is commented, it does show AEDECOD on the left. But some AEDECOD is long, I want to wrap it for example "Influenza" (wrap) "like illness". Is there any way to do it? Below is my code.    Thanks a lot for reading and help!   data AE; length AEDECOD $200; AEDECOD='Influenza like illness';AESTDY=1;AEENDY=10;output; AEDECOD='Haemarthrosis';AESTDY=3;AEENDY=14;output; run; proc sgplot data=AE; highlow y=AEDECOD low=AESTDY high=AEENDY / type=bar lineattrs=(color=black pattern=solid) barwidth=0.8; xaxis grid display=(nolabel) values=(0 to 15); yaxis grid display=(noticks /*novalues*/ nolabel); run;   ... View more

Hi, I think this question may be asked before. But I was unable to find it. Basically, I have group variable say Subject (Math, English etc),  and another column: Student.   Subject    Sudent Math        Student1 ... Math        Student100   In proc report, I want to list Math only in first row of all pages with all Students. Define Subject as group can only accomplish this in first page. In next page under same subject (here math), it shows blank.   I tried rowspans but it seemed working different from what I want here. Can you help?  ... View more