Below is my code, my purpose is to print  data and text "aaaaaaaaaaaaaaaaa" in one page and "bbbbbbbbbbbbbbbbbbbbbbbbb' in another page.  How can I do it?  I do not know which option should I add between the two ods rtf text. Thanks.     ods rtf file="C:\XXXXXXX\Desktop\111.rtf"; ods escapechar="^"; proc report data=sashelp.cars (obs=10); run; ods rtf text="aaaaaaaaaaaaaaaa"; ods rtf text="bbbbbbbbbbbbbbbbbbbb"; ods rtf close; ... View more

  I want to get rtf output. The first page has orientation=landscape, and the second page has orientation=portrait; The below is my code. Why it does not work?     options orientation=landscape obs=5; ods rtf file="C:\XXXXX\Desktop\111.rtf"; proc print data=sashelp.class; run; options orientation=portrait; proc print data=sashelp.retail; run; ods rtf close;     Another question is if I only use orientation=portrait, which option can put these two proc output in one page, not like above the outputs are on different pages? Thanks.         ... View more

Below is my code, I want to get a excel files with multiple sheets. My question is how I can specify each sheet name. For example: sheet 1 is named Report, sheet2 is named RESULT, and sheet 3 is named FINDING.     data a; length PatientID $2; input PatientID $ Systolic Diastolic @@; datalines; CK 120 50 SS 96 60 FR 100 70 CP 120 75 BL 140 90 ES 120 70 ; data b; length PatientID $2; input PatientID $ Systolic Diastolic @@; datalines; CP 165 110 JI 110 40 MC 119 66 FC 125 76 RW 133 60 KD 108 54 DS 110 50 JW 130 80 BH 120 65 ; data c; length PatientID $2; input PatientID $ Systolic Diastolic @@; datalines; CP 120 75 BL 140 90 ES 120 70 CP 165 110 JI 110 40 MC 119 66 FC 125 76 RW 133 60 KD 108 54 DS 110 50 JW 130 80 BH 120 65 ; ods excel file="path\aaa.xlsx"; proc report data=a; column _all_; run; proc report data=b; column _all_; run; proc report data=c; column _all_; run; ods excel close; ... View more