topic Re: one proc print multiple data set in SAS Procedures

one proc print multiple data set

tianerhu — Sat, 07 Mar 2020 02:58:48 GMT

How to print Multiple datasets in one proc print statement?


data  females males;
   set apple.survey;
if  Gender = "F" then output females;
else if Gender = "M" then output males;
run;
proc print data = females;
run;
proc print data = males;
run;

Re: one proc print multiple data set

novinosrin — Sat, 07 Mar 2020 03:07:27 GMT

How to print Multiple datasets in one proc print statement?

Do not split, rather sort and print to make it look multiple groups i.e

proc sort data=apple.survey out=want;

 by gender;

run;

proc print data =want;

run;

Re: one proc print multiple data set

Astounding — Sat, 07 Mar 2020 03:55:40 GMT

If you go this route, you can add to the PROC PRINT step:

proc print data=want uniform;
   by gender;
   pageby gender;
run;

Re: one proc print multiple data set

novinosrin — Sat, 07 Mar 2020 15:50:49 GMT

Thank you @Astounding I learned something new viz. uniform option. Nice!

Re: one proc print multiple data set

PaigeMiller — Sat, 07 Mar 2020 17:29:54 GMT

@tianerhu wrote:

How to print Multiple datasets in one proc print statement?


data  females males;
   set apple.survey;
if  Gender = "F" then output females;
else if Gender = "M" then output males;
run;
proc print data = females;
run;
proc print data = males;
run;

So the answer has already been given above, but there is no reason whatsoever to split the data set into two in the first place, and then do the same thing on both splits. Usually this is very poor practice.

Re: one proc print multiple data set

tianerhu — Sat, 07 Mar 2020 22:40:03 GMT

thank you , but it does not work

Re: one proc print multiple data set

tianerhu — Sat, 07 Mar 2020 22:44:17 GMT

Thank you , but it doesn't work .

Re: one proc print multiple data set

tianerhu — Sat, 07 Mar 2020 22:45:32 GMT

Thank you , but it doesn't work .

Re: one proc print multiple data set

Reeza — Mon, 09 Mar 2020 15:46:13 GMT

PROC PRINT cannot print multiple data sets at once. If you have groups within your data, the SAS method for analysis is optimal when you do not split your data set into multiple data sets. Then you can use BY group processing. However, if you have split your data then you need to call PROC PRINT multiple times. This is a design choice, which is yours as the programmer.

Re: one proc print multiple data set

tianerhu — Sat, 14 Mar 2020 04:33:42 GMT

thank you .