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;
... View more