4 weeks ago
RooRoo
Obsidian | Level 7
Member since
03-11-2025
- 13 Posts
- 12 Likes Given
- 0 Solutions
- 0 Likes Received
-
Latest posts by RooRoo
Subject Views Posted 546 03-18-2025 10:23 AM 674 03-17-2025 05:18 AM 823 03-14-2025 03:09 AM 826 03-14-2025 03:03 AM 876 03-13-2025 06:21 AM 1461 03-13-2025 05:01 AM 1472 03-13-2025 04:38 AM 1549 03-12-2025 10:05 AM 1596 03-12-2025 04:18 AM 2209 03-12-2025 02:24 AM -
Activity Feed for RooRoo
- Posted Re: First page is blank when using page break, define option PAGE, and LINE command in compute block on SAS Programming. 03-18-2025 10:23 AM
- Liked Re: First page is blank when using page break, define option PAGE, and LINE command in compute block for Ksharp. 03-17-2025 05:19 AM
- Liked Re: First page is blank when using page break, define option PAGE, and LINE command in compute block for Ksharp. 03-17-2025 05:19 AM
- Liked Re: First page is blank when using page break, define option PAGE, and LINE command in compute block for Ksharp. 03-17-2025 05:19 AM
- Liked Re: First page is blank when using page break, define option PAGE, and LINE command in compute block for Ksharp. 03-17-2025 05:19 AM
- Liked Re: First page is blank when using page break, define option PAGE, and LINE command in compute block for Ksharp. 03-17-2025 05:19 AM
- Liked Re: First page is blank when using page break, define option PAGE, and LINE command in compute block for ballardw. 03-17-2025 05:19 AM
- Liked Re: First page is blank when using page break, define option PAGE, and LINE command in compute block for Ksharp. 03-17-2025 05:19 AM
- Liked Re: First page is blank when using page break, define option PAGE, and LINE command in compute block for Ksharp. 03-17-2025 05:19 AM
- Liked Re: First page is blank when using page break, define option PAGE, and LINE command in compute block for Ksharp. 03-17-2025 05:19 AM
- Posted Re: First page is blank when using page break, define option PAGE, and LINE command in compute block on SAS Programming. 03-17-2025 05:18 AM
- Liked Re: First page is blank when using page break, define option PAGE, and LINE command in compute block for Ksharp. 03-17-2025 05:18 AM
- Liked Re: First page is blank when using page break, define option PAGE, and LINE command in compute block for Ksharp. 03-17-2025 05:18 AM
- Liked Re: First page is blank when using page break, define option PAGE, and LINE command in compute block for Cynthia_sas. 03-17-2025 05:18 AM
- Posted Re: First page is blank when using page break, define option PAGE, and LINE command in compute block on SAS Programming. 03-14-2025 03:09 AM
- Posted Re: First page is blank when using page break, define option PAGE, and LINE command in compute block on SAS Programming. 03-14-2025 03:03 AM
- Posted Re: First page is blank when using page break, define option PAGE, and LINE command in compute block on SAS Programming. 03-13-2025 06:21 AM
- Posted Re: First page is blank when using page break, define option PAGE, and LINE command in compute block on SAS Programming. 03-13-2025 05:01 AM
- Posted Re: First page is blank when using page break, define option PAGE, and LINE command in compute block on SAS Programming. 03-13-2025 04:38 AM
- Posted Re: First page is blank when using page break, define option PAGE, and LINE command in compute block on SAS Programming. 03-12-2025 10:05 AM
-
Posts I Liked
Subject Likes Author Latest Post 1 1 1 1 1
03-18-2025
10:23 AM
Yes, I tried with STARTPAGE=NO too, but looks like it doesn't work well with DEFINE PAGE option. And thank you! I will check your other solution as well.
... View more
03-17-2025
05:18 AM
That's a very good one! Yeah, there's a disadvantage that for a group with few entries there is more empty space on the page, but in all other aspects it's just great!
... View more
03-14-2025
03:09 AM
Thanks for your reply! Could you please tell how to force repagination? I couldn't find anything about it.
... View more
03-14-2025
03:03 AM
Unfortunately, it didn't held - Table1 is still there.
... View more
03-13-2025
06:21 AM
The problem remained, now I got "Page 1" on the first two pages. But it's interesting, that you don't have this issue.
... View more
03-13-2025
05:01 AM
That works fine, thank you! But I just discovered something strange. I noticed there's two "first" pages. All further pages are numerated correctly. Besides, in TOC there's unwanted Table1 which appears when using break after page_no / page contents=""; instead of break before page_no / page contents=""; Do you have any ideas?
... View more
03-13-2025
04:38 AM
Yes, you are totally right, I should have provided the desired appearence as describing such things only with words can be quite confusing 🙂
... View more
03-12-2025
10:05 AM
Thanks for your effort! But there's still some issues. First, the line 'End of Table' is seen on the two last pages instead of only the last one. Besides, for groups with few entries thewe will be pages with too much empty space, whereas groups with too many entries would cause other problems. This why controlled page breaks are important here.
... View more
03-12-2025
04:18 AM
Thanks for the idea! But looks like it doesn't work as desired. First, it produces the line "End of Table" on every page instead of the actual end of the table. Second, on some pages data appear even after the footnotes.
... View more
03-12-2025
02:24 AM
The problem is solved, thanks!
... View more
03-12-2025
02:19 AM
Thanks for your reply! Unfortunately, it wouldn't be enough to change the orientation because, as mentioned in the post, sometimes we have many columns, so that even the landscape orientation is not enough. And as all the columns don't fit in one page, removing ID and PAGE options is not a good option, without them the output is pretty chaotic. As is, ID and PAGE options work just fine, but only adding extra lines with "COMPUTE AFTER Make" block creates the issue, and only on the first page.
... View more
03-11-2025
08:45 AM
Hello! Unfortunately, my post was marked as spam today and deleted although to my opinion it didn't content anything inappropriate. Could you please publish it again?
... View more
03-11-2025
07:27 AM
Hello eveyone! I use SAS Enterprise Guide 8.5 with and have been struggling with the following issue for a few days. I run the code below: DATA AAA;
SET SASHELP.CARS;
PAGE_NO = FLOOR((_n_-1)/15)+1;
RUN;
ODS RTF(ID=INDA) FILE= "\\app01.icrc.local\Share\Projects\ROX_795_SC-332A\Biostatistics\Prog\A.rtf" CONTENTS=YES STARTPAGE=YES TOC_DATA;
PROC REPORT DATA=AAA(obs=100);
COLUMNS PAGE_NO Make Model Type Origin DriveTrain MSRP Invoice EngineSize Cylinders Horsepower MPG_City MPG_Highway;
DEFINE PAGE_NO / ORDER NOPRINT contents="";
DEFINE Make / ORDER NOPRINT;
DEFINE Model / DISPLAY ID STYLE(COLUMN)={CELLWIDTH=1IN};
DEFINE Type / DISPLAY STYLE(COLUMN)={CELLWIDTH=1IN};
DEFINE Origin / DISPLAY STYLE(COLUMN)={CELLWIDTH=1IN};
DEFINE DriveTrain / DISPLAY STYLE(COLUMN)={CELLWIDTH=1IN};
DEFINE MSRP / DISPLAY STYLE(COLUMN)={CELLWIDTH=1IN};
DEFINE Invoice / DISPLAY STYLE(COLUMN)={CELLWIDTH=1IN} contents="" PAGE;
DEFINE EngineSize / DISPLAY STYLE(COLUMN)={CELLWIDTH=1IN};
DEFINE Cylinders / DISPLAY STYLE(COLUMN)={CELLWIDTH=1IN};
DEFINE Horsepower / DISPLAY STYLE(COLUMN)={CELLWIDTH=1IN};
DEFINE MPG_City / DISPLAY STYLE(COLUMN)={CELLWIDTH=1IN};
DEFINE MPG_Highway /DISPLAY STYLE(COLUMN)={CELLWIDTH=1IN};
COMPUTE BEFORE Make;
LINE @1 " ";
LINE @1 Make $16.;
LINE @1 " ";
ENDCOMP;
break before page_no / page contents="";
compute after _page_;
line "Some text";
line "Some other text";
endcomp;
compute after;
line "End of Table";
endcomp;
RUN;
ODS RTF(ID=INDA) CLOSE; My purpose is to produce a report: 1) With page breaks (hence the line break before page_no / page); 2) With footnotes in every page and a messege in the end of table; 3) With page breakes before the column Invoice (hence DEFINE Invoice / ... PAGE); 4) With a line before every new group (hence the COMPUTE BEFORE Make block); The problem is that the generated report has the first page empty: Everything else works fine. I tried some approaches. So, replacing break before page_no / page with break after page_no / page solves this problem, but creates other ones (for example empty pages in the end). Also, deleting the COMPUTE BEFORE Make block make thing better. But unfortunately, the line before every group is required. Of course reducing column width (so that all columns fit in one page) helps too, but in real projects we often have reports with many columns. I hope someone could help me with good advice. Thanks in advance!
... View more