topic How to print few observations with where condition in Proc Print. in SAS Procedures

How to print few observations with where condition in Proc Print.

Vibcom — Fri, 26 Oct 2018 07:22:19 GMT

I want to show some specific obs from a dataset with Proc Print

Ex-- we have a dataset which contains name with different Genders.

Name Gender

X M

Y M

Z F

A M

I want to print only Gender = M obs with Proc Print, we can use Where condition.But if i don't want to print all obs but some specific number (For Ex-2 -- only x and Y not Z)

How to do it?

Re: How to print few observations with where condition in Proc Print.

Shmuel — Fri, 26 Oct 2018 07:32:02 GMT

data temp;
 set have(where=(gender='M'));
run;
proc print data=temp (obs=2);
  var  <list of variables to print>;
run;

Re: How to print few observations with where condition in Proc Print.

FreelanceReinh — Fri, 26 Oct 2018 08:59:41 GMT

Why not simply

proc print data=have(where=(gender='M') obs=2);
run;

or equivalently

proc print data=have(obs=2);
where gender='M'; 
run;

Re: How to print few observations with where condition in Proc Print.

andreas_lds — Fri, 26 Oct 2018 10:22:17 GMT

Maybe you need to write down the rules an observation has to fulfil to be printed.

Re: How to print few observations with where condition in Proc Print.

s_lassen — Fri, 26 Oct 2018 12:30:42 GMT

If you want the first n observations of a specific subset, it is much easier to use SQL with the OUTOBS option:

Proc sql outoubs=20;
  select name from have where gender='M';
quit;

You may want to use ORDER BY to make sure you get the topmost observations, SQL does not guarantee the order otherwise.

Re: How to print few observations with where condition in Proc Print.

SuryaKiran — Fri, 26 Oct 2018 13:13:38 GMT

Are you trying to control the number of records to print or you want to print the list of record that you wish?

If you have a list where your print result need to include from then, Why not list them in where condition. Create a list of values into a macro and then later filter them in Proc print where condition.

proc sql noprint;
select quote(strip(name)) into:names separated by ','
from sashelp.class
where age>13;
quit;

proc print data=sashelp.class(where=(sex='M' and name in (&names.)));
run;