I am trying to post new observation from new page in Excel sheet using proc report but BREAK does not seem to work here.
I have attached the report that I am receiving right now. The highlighted ID and the following details, need to start from new page.
Can someone please help me here. SAS Version 9
My code -
ODS TAGSETS.EXCELXP
FILE = REPORT2
RS=NONE
OPTIONS
(
ABSOLUTE_COLUMN_WIDTH= "30,30"
ROW_HEIGHTS = '0,0,10,0,0,0,0'
ORIENTATION = 'LANDSCAPE'
ZOOM = '100'
EMBEDDED_TITLES = 'YES'
EMBEDDED_FOOTNOTES = 'YES'
MISSING_ALIGN = 'CENTER'
SHEET_NAME = 'Participant Basic Info'
SHEET_INTERVAL = 'PROC'
);
TITLE1 justify=c &T1;
TITLE2 justify=c &T2;
PROC REPORT DATA = AU MISSING SPLIT='*'
STYLE(HEADER)={BACKGROUND=BLUE COLOR=WHITE FONT_WEIGHT=BOLD
BORDERWIDTH=2 BORDERCOLOR=BLACK BORDERSTYLE=SOLID}
STYLE(COLUMN)={BACKGROUND=WHITE COLOR=BLACK FONT_WEIGHT=BOLD
BORDERWIDTH=2 BORDERCOLOR=BLACK BORDERSTYLE=SOLID};
BY
ID
;
COLUMN
ID
ITEM
VALUE
;
DEFINE ID / GROUP NOPRINT style={just=center};
DEFINE ITEM / ORDER=DATA 'Field Description' style={just=center
};
DEFINE VALUE / ORDER=DATA 'Field Value' style={just=center
tagattr='wrap:yes'
};
LABEL ID = 'Participant ID';
BREAK AFTER ID/PAGE;
RUN;
ODS TAGSETS.EXCELXP CLOSE;
ODS LISTING;
Excel does not have the concept of pages other than in the Print Preview setting. In the lower right corner of Excel you will find some buttons, one is Normal - default view, the next is Page Layout - this will show you a paged representation as it would appear if you printed it. To be honest I have no idea if you can control print preview options from SAS in this way, nor will Excel normally do this for you. If you want nice printed output or paged output use an output destination appropriate to the task, e.g. rtf or pdf. Excel is a spreadsheet not a word processor.
Hey
Thanks for the reply. Tried using it but didn't work.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.