Apologies if this is a duplicate -- there are several closely related posts on this forum, but I did not see one with exactly my issue...   I'm using ODS RTF with the BODYTITLE option, and I want some pages to be portrait and others landscape. Oddly, I can start the output file in portrait and then change to landscape, but if I start in landscape then I cannot change to portrait.   Here's a minimal reproducible example, creating a macro that prints a two-page RTF file. You can specify the orientation of each page using the macro parameters.   %macro rtf(orient1, orient2); options orientation=&orient1; ods rtf file="Orientation - &orient1 to &orient2..rtf" bodytitle; title "Page 1 Orientation: &orient1"; proc print data=sashelp.class(obs=1); run; options orientation=&orient2; ods rtf; title "Page 2 Orientation: &orient2"; proc print data=sashelp.class(obs=1); run; ods rtf close; %mend; %rtf(Portrait, Landscape) /* success: page 1 is portrait, page 2 is landscape */ %rtf(Landscape, Portrait) /* failure: both pages are landscape */   This odd behavior happens only when I use the BODYTITLE option. If I remove that option, then the page orientation always changes as expected. But I don't want my table/figure titles & footnotes in the document header & footer, so I prefer to use BODYTITLE.   I can also fix the problem by switching to ODS TAGSETS.RTF. That works, but I already have a large codebase creating tables & figures using ODS RTF, and if I switch one over to using TAGSETS.RTF then for formatting consistency I'd need to switch all of them. I'd prefer to avoid that extra work.   Any idea how to fix the above code? I tried playing around with the STARTPAGE option in the ODS RTF statements, but couldn't find anything that helped.   I'm using SAS 9.4M6 in SAS Studio. ... View more

I want my PDF output to have a footnote like "Page X of Y". I can use the following footnote statement, and it works fine in PC SAS 9.4M8, but it fails in SAS Studio 3.8 with SAS 9.4M6 as the backend: footnote 'Page (*ESC*){thispage} of (*ESC*){lastpage}'; Here's a full example: ods pdf file="page number test.pdf"; footnote1 '(1) Page (*ESC*){thispage} of (*ESC*){lastpage}'; * fails in SAS Studio; footnote2 '(2) Page (*ESC*){thispage}'; * works in SAS Studio; footnote3 '(3) Total pages: (*ESC*){lastpage}'; * fails in SAS Studio; proc print data=sashelp.class; run; ods pdf close;    Here's a screenshot of the footnotes in the resulting PDF, created with SAS Studio: Note that {thispage} works fine, but {lastpage} -- which should resolve to the total number of pages -- does not. I don't know if the problem is with SAS Studio or if it's a bug in SAS 9.4M6 that was fixed by 9.4M8.   A very similar question has been asked before (https://communities.sas.com/t5/SAS-Programming/Page-numbers/td-p/681221), though there's no mention of what SAS UI or backend they're using, and there's no real solution since the problem seemed to disappear for the OP.   Is there a way to get this working in SAS Studio with SAS 9.4M6? My company will be phasing out PC SAS very soon. ... View more

I want to print many tables, arranged in 3 columns. To control the layout, I'm using ODS LAYOUT GRIDDED. The data for the tables are in one dataset, so I'm  only calling PROC REPORT once with a BY statement. My issue is how to customize the title of each table. If I let SAS handle the titles for me, then everything's fine: * Example 1: Let SAS handle the by-group titles, and it works great; title; ods layout gridded columns=3 advance=bygroup; proc report data=sashelp.iris; by species; columns sepal:; define sepal: / mean; run; ods layout end; You see that each little table is correctly labeled with its by-group. The problem arises when I try to customize the titles using the #BYVAL syntax -- then only the first table (from the first by-group) is given a title:   * Example 2: Customize the by-group titles, and it fails; title; options nobyline; ods layout gridded columns=3 advance=bygroup; proc report data=sashelp.iris; title 'Species: #byval1'; by species; columns sepal:; define sepal: / mean; run; ods layout end; options byline; How can I title all the tables? If you comment out the ODS LAYOUT lines from my "Example 2" code above, you'd see that my custom titles work fine. So the problem is specifically in the interaction between using ODS LAYOUT and #BYVAL.   Note that a very similar question has already been asked (https://communities.sas.com/t5/ODS-and-Base-Reporting/How-to-automatically-specify-a-different-title-for-each-graph/td-p/533130), but in that case the solution was to change some settings in SAS Enterprise Guide. I'm using PC SAS 9.4 (TS1M8), so I think that solution is not relevant for me.   I also know there are workarounds, e.g., I could wrap PROC REPORT in a macro and then use CALL EXECUTE to call the macro for each by-group. Then I could customize the by-group titles without using #BYVAL:   * Example 3: Workaround using CALL EXECUTE -- gives me exactly what I want; %macro print(species); proc report data=sashelp.iris; title "Species: &species"; where species = "&species"; columns sepal:; define sepal: / mean; run; %mend; title; ods layout gridded columns=3 advance=table; data _null_; set sashelp.iris; by species; if first.species then call execute('%print(' || trim(species) || ')'); run; ods layout end; So the workaround works, and that's fine if necessary. But, is there a simpler way, i.e., a simple modification to my "Example 2" code? ... View more