topic Re: page break using proc report in SAS Procedures

page break using proc report

keen_sas — Tue, 17 Mar 2009 14:32:55 GMT

I have 100 observations in data set and i want to prepare a listing for this data set using proc report .I want a page break for 10 or 20 observations for each page .How can i break the page for 10 or 20 observations using proc report ( in pdf output using ods )?

Thanks in advance for your replies

Re: page break using proc report

sbb — Tue, 17 Mar 2009 15:32:39 GMT

The SAS support website http://support.sas.com/ has SAS hosted documentation and supplemental technical conference (SGF and SUGI) papers. I used the website SEARCH facility and found this conference paper which reference on using BREAK with the PAGE option.

Scott Barry
SBBWorks, Inc.

Beyond the Basics: Advanced PROC REPORT Tips and Tricks
Allison McMahill, SAS Institute Inc., Cary, NC

http://support.sas.com/rnd/papers/sgf07/sgf2007-report.pdf

PROC REPORT:
Compute Block Basics – Part I Tutorial
Arthur L. Carpenter
California Occidental Consultants

http://www2.sas.com/proceedings/forum2008/031-2008.pdf

Re: page break using proc report

Cynthia_sas — Tue, 17 Mar 2009 15:38:07 GMT

Hi:
Basically, PROC REPORT needs a GROUP or ORDER variable that represents the place where break processing should occur. So you can either create your own "fake" page break variable or you could use a BY statement (every BY group starts a new page) or you could use the obs= option, as shown in this forum posting:
http://support.sas.com/forums/thread.jspa?messageID=15692㵌
(this person wanted to suppress page numbers on the first page of the report, but the same OBS= and FIRSTOBS= technique would also work for what you want.

cynthia