topic Re: proc tabulate, first table portrait orientation, second table landscape, last three tables portr in New SAS User

proc tabulate, first table portrait orientation, second table landscape, last three tables portrait

hein68 — Tue, 05 Nov 2019 19:53:11 GMT

I have the code below, which works to create the tables I want. However, I want the first table to be in portrait orientation on the page, then the second table in landscape orientation, and then the last three tables back to portrait orientation. This code isn't working to do that. What do I need to do?

Thanks,

*FIRST TABLE;

options orientation=portrait;

proc tabulate data=top25wvars ;
   class diag1ccs / order=freq;
   class age_3cat;
   table diag1ccs=' ',
         (all='All' age_3cat=' ') * n=' '
         /box='Top 25 CCS diagnoses'
   ;

run;

*SECOND TABLE;

ods RTF(ID=EGRTF) startpage=now;

options orientation=landscape;

*second part: gender, weekday vs weekend, discharge disposition;
*Now we want the adults only;
data adultstop25;
set top25wvars;
if age_3cat ^=2 then delete;
format female gender.;
format aweekend WEEKEND.;
run;

proc tabulate data=adultstop25;
   class diag1ccs / order=freq;
   class female aweekend dispuniform_4cat;
   table diag1ccs=' ',
         (all='Adults' female=' ' aweekend=' ' dispuniform_4cat=' ') * n=' '
         /box='Top 25 CCS diagnoses'
   ;


run;

*LAST THREE TABLES;

ods RTF(ID=EGRTF) startpage=now;

options orientation=portrait;

proc tabulate data=top25wvars;
   class diag1ccs / order=freq;
   class age_3cat timeofyear;
   table age_3cat, diag1ccs=' ',
         (timeofyear=' ') * n=' '
         /box='Top 25 CCS diagnoses'
   ;

run;

Re: proc tabulate, first table portrait orientation, second table landscape, last three tables portr

SASKiwi — Tue, 05 Nov 2019 20:12:55 GMT

The SAS OPTION orientation has no effect if you are using ODS. You need to add Orientation="Portrait" to your ODS statements:

ods RTF options(Orientation="Landscape");
ods RTF options(Orientation="Portrait");

Re: proc tabulate, first table portrait orientation, second table landscape, last three tables portr

hein68 — Tue, 05 Nov 2019 21:28:38 GMT

Sorry, I hit accept this solution too soon.

This is the code I am using, followed by the error message I am getting. Any idea why?

Thanks.

ods graphics on;
56         ods RTF options (ID=EGRTF Orientation="Portrait");
                   _______           ___________
                   22                79
                   202               202
ERROR 22-322: Syntax error, expecting one of the following: ;, (, ANCHOR,
              AUTHOR, BASE, BODY, BOOKMARK, BOX_SIZING, CHARSET, CLOSE,
              COLUMNS, CONTENTS, CSSSTYLE, DATAPANEL, DOM, DPI, ENCODING,
              EXCLUDE, FILE, FONTSCALE, GFOOTNOTE, GTITLE, HOST, IMAGE_DPI,
              KEEPN, LSTPIPE, NEWFILE, NOCONTENTS, NOGFOOTNOTE, NOGTITLE,
              NOKEEPN, NOLSTPIPE, NOOUTLINE, NOTRKEEP, OPERATOR, OUTLINE,
              PACKAGE, PATH, RECORD_SEPARATOR, SAS, SASDATE, SELECT, SGE, SHOW,
              STARTPAGE, STYLE, TEXT, TITLE, TRANTAB, TRKEEP.
ERROR 79-322: Expecting a ).
ERROR 202-322: The option or parameter is not recognized and will be ignored.