How do I subset a large dataset using a list of specific ID numbers?

sasgyro — Thu, 18 Jun 2020 21:08:39 GMT

I have a series of patients who have certain characteristics( variables)

I need to pick out the patients that meet the criteria by using their patient ID (300 unique identifiers) and separate them into their own dataset so they are alike only by that one characteristic.

i=I want it to be like this:

Data want;
SET have;
where patientnum= 3 6 5 4 8 7 9 0 ;
run;

but this doesn't work. and using OR and AND statements cancels the previous ID number

Re: How do I subset a large dataset using a list of specific ID numbers?

novinosrin — Thu, 18 Jun 2020 21:19:02 GMT

 Data want;
SET have;
where patientnum in (3 6 5 4 8 7 9 0) ;
run;

/*or*/

where patientnum in (3, 6, 5, 4, 8, 7, 9, 0) ;

topic How do I subset a large dataset using a list of specific ID numbers? in SAS Data Science

How do I subset a large dataset using a list of specific ID numbers?

Re: How do I subset a large dataset using a list of specific ID numbers?