Hi   I've done some searching on this and can't find a solution I am not already trying. I have a standard proc report that is split using by variables. All has been good the bookmarks have been fine, but something has changed somewhere and I appear to be getting extra rows of data in the bookmark. In the PROC LABEL I put the table titles and then the BY splits. But for some reason now I am getting the variables that contribute to the table too.   The code that produces this is all macro driven, so I've extracted the actual report statement from the log - hopefully this makes sense, the ordering of the statements might be a little off.   ODS PDF FILE=outpdf style = styles.vx_pdf10 ; ODS proclabel = "Table 28 Number (%) of subjects with adverse events during the 43-day (Days 0-42) post-vaccination period Total vaccinated cohort"; ** Create the REPORT; PROC REPORT DATA = _rep_list NOWD spanrows missing contents = "" split='|' style(report)={cellpadding=3px} ; BY sexn racen; COLUMN ODSDUMMY sexn racen asocnum sumvar GRP1_LAB, ( GRP1_NUM GRP1_PERC ) GRP_GAP GRP2_LAB, ( GRP2_NUM GRP2_PERC ) GRP_GAP GRPTOT_LAB, ( GRPTOT_NUM GRPTOT_PERC ) ; ; DEFINE odsdummy / ORDER ORDER=DATA NOPRINT; DEFINE asocnum / order order = DATA NOPRINT; DEFINE sumvar / display order = DATA " " style(header)=[just=left ] style(column)=[cellwidth=48% ASIS=ON just=left ] spacing = 1 ; DEFINE grp1_NUM / DISPLAY order = DATA "n or value" style(header)=[just=CENTER ] style(column)=[cellwidth=7.5% just=CENTER ] spacing = 1 ; DEFINE grp1_PERC / DISPLAY order = DATA "%" style(header)=[just=CENTER ] style(column)=[cellwidth=7.5% just=CENTER ] spacing = 1 ; DEFINE grp2_NUM / DISPLAY order = DATA "n or value" style(header)=[just=CENTER ] style(column)=[cellwidth=7.5% just=CENTER ] spacing = 1 ; DEFINE grp2_PERC / DISPLAY order = DATA "%" style(header)=[just=CENTER ] style(column)=[cellwidth=7.5% just=CENTER ] spacing = 1 ; DEFINE grpTOT_NUM / DISPLAY order = DATA "n or value" style(header)=[just=CENTER ] style(column)=[cellwidth=7.5% just=CENTER ] spacing = 1 ; DEFINE grpTOT_PERC / DISPLAY order = DATA "%" style(header)=[just=CENTER ] style(column)=[cellwidth=7.5% just=CENTER ] spacing = 1 ; DEFINE grp1_lab / ACROSS "" ORDER=INTERNAL; DEFINE grp2_lab / ACROSS "" ORDER=INTERNAL; DEFINE grpTOT_lab / ACROSS "" ORDER=INTERNAL; DEFINE GRP_GAP / DISPLAY " " ORDER=INTERNAL style(column)=[cellwidth=1% ASIS=ON just=L ]; COMPUTE AFTER asocnum ; LINE ''; ENDCOMP; define sexn / NOPRINT GROUP CONTENTS="" PAGE FORMAT = sex. ; define racen / NOPRINT GROUP CONTENTS="" PAGE FORMAT = race. ; compute before _page_ / style={borderbottomstyle=solid borderbottomcolor=black fontweight=bold} ; byvars = catx( ' ' , " Gender: " , PUT(sexn , sex.) ,' ' , " Nationality: " , PUT(racen , race.) ,' ' ); line @1 byvars $varying100.; endcomp; BREAK BEFORE odsdummy / CONTENTS="" PAGE; RUN; ODS PDF CLOSE;     As you can see I have use the BREAK and CONTENTS='' on "odsdummy" which is just a variable with the value of 1 to help with the Bookmarks.    Here is the output - its the yellow bookmark I want rid off.     I'm just curious where the variable names come from to be put into the bookmark   It's got to be something really simple I am missing.   Thanks for anyones help   🙂   ... View more

Hi   I produce a PDF document using the following: ODSTEXT for table titles and footnote (this is because the client wishes the footnotes to appear at the bottom of the report rather than the bottom of each page), and we use one TITLE statement to produce a page heading to appear on every page. Producing a report works just fine and we have a nicely formatted report, we then place this report into a SAS7BITM file (Container) to be replayed at a later date.   This is where the problems occur. We then replay (using PROC DOCUMENT) using the exact same style and the same size fonts for the table titles and footnote, but the first page shows the page heading and table title, but the actual data of the table doesn't appear until the second page for some reason.   I've taken a screen shot of 3 pages (with some sensitive information taken out) and added them to a word document which is attached   Page1 shows the report when it was originally run so the titles and the body of the table appear on the first page Page2 shows the first page of the replayed output (see no body of the table included) Page3 shows the body of the tabel on page 2 of the replayed output (note as well that there are 2 more lines of data on this first page comapred to the Individual-1 [assume that is due to no titles])   So SAS / PDF appears to render the tables slightly different.   One other thing to note is that ODS TEXT does not work when a container is replayed, so we have to use OBBNOTE and OBANOTE for the titles and footnotes we display (Other than TITLE for the very top page heading).   The reason for the replay is we combine all our tables into one document, and it appears that most of the tables come out perfectly fine but occassionally we have an issue like this. There seems to be no logical reason that I can see, and I am not even sure if this is a SAS problem but the way Adobe renders a document? (p.s. I know nothing about this)   This is being run on SAS Drug Development V4.3.4 which I believe has SAS 9.3 installed.   It has been noted this only exists when there are multiple pages to the report, when there is just one page of data the report appears to be fine when replayed.   Any help greatly appreciated. ... View more