Print out a report by group?

ybz12003 — Thu, 23 Jul 2020 18:30:41 GMT

Hi all,

I would like to print out a report by grouping studysites for a dataset 'test'. I have a code below. However, I found out that the output file was order by studysite, it print out the studysite and the IDs one by one. I don't like that, I would like to out put the file with grouping the studysite first, then sorting the IDs later. I found there is no 'GROUP' option in the PROC PRINT, please advice how to approach it? Thanks.

options orientation=portrait;
proc print data=test;
	var id repeat_id studysite DOB months days;
	where repeat_id in (&replistdob.);
	by studysite repeat_id;
	title 'More than 1 dob for a repeat ID';
run;

Re: Print out a report by group?

PaigeMiller — Thu, 23 Jul 2020 18:36:43 GMT

I would like to out put the file with grouping the studysite first, then sorting the IDs later.

use by studysite; instead of by studysite repeat_id;

Re: Print out a report by group?

ybz12003 — Thu, 23 Jul 2020 18:41:28 GMT

Thanks!

topic Re: Print out a report by group? in SAS Programming

Print out a report by group?

Re: Print out a report by group?

Re: Print out a report by group?