Hi,
Please can you help in below:
I have a SAS dataset with Suject information like subjectid, race, age, and ecg data (visit, visit date, pr, hr, qrs). Please refer to attached file for the required final output.
I want to display data per subject per page.
The top table should have information like subjectid, race, age, and the below table should have information like visit, visit date, pr, hr, qrs.
I tried with below code: but this is not giving me per subject records per page:
options orientation=landscape;
title;
footnote;
ods escapechar='^';
ods listing close;
ods rtf file="\\tsclient\D\Assignment\output2.rtf" STARTPAGE= NO keepn style= US_Landscape_10pt bodytitle;
proc report data =adeg1 missing headline headskip nowd split='\' spacing=0;
columns usubjid trta sex age race;
by usubjid trta sex age race;
define usubjid / order width=8 center 'Subject' ;
define trta / order width=8 center 'Treatment' ;
define sex / order width=8 center 'Sex' ;
define age / order width=8 center 'Age' ;
define race / order width=8 center 'Race' ;
break after usubjid / page;
run;
proc report data =adeg1 missing headline headskip nowd split='\' spacing=0;
columns usubjid adt ady avisit hr qrs qt pr ;
by usubjid trta age sex race;
define usubjid / order=internal noprint ;
define adt / order width=8 center 'A date' ;
define ady / order width=8 center 'Day' ;
define avisit / order width=8 center 'Visit' ;
define hr / order width=8 center 'HR' ;
define qrs / order width=8 center 'QRS' ;
define qt / order width=8 center 'QT' ;
define pr / order width=8 center 'PR' ;
run;
ods rtf close;
ods listing;
Thanks,
Amit
Try the startpage= option:
http://support.sas.com/kb/44/269.html
Set it to none before the first and then set it to now, after the second.
You may need to block out the code for each by group. I.e for each by group, create a proc report with fixed startpage= option, yu can programmatically create this with macro or call execute.
Try the startpage= option:
http://support.sas.com/kb/44/269.html
Set it to none before the first and then set it to now, after the second.
You may need to block out the code for each by group. I.e for each by group, create a proc report with fixed startpage= option, yu can programmatically create this with macro or call execute.
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.