topic Creating a subset file with selected ID in SAS Procedures

Creating a subset file with selected ID

Sapkota — Wed, 21 May 2014 16:18:45 GMT

I would like to subset one dataset so that my output file has only the desired ID numbers. For an example, from a file with the following ID (plus other variables) I would

like to have a subset file that contains only the ID = 122142, 321212, 123213, 113211, 123131, 232116. Please help.

Sapkota

122142

321212

123213

113211

123131

232116

665454

465653

543543

434536

094345

098543

934543

436344

and so on

Re: Creating a subset file with selected ID

stat_sas — Wed, 21 May 2014 16:23:25 GMT

Try this.

proc sql;

select * from have

where id in (122142, 321212, 123213, 113211, 123131, 232116);

quit;

Re: Creating a subset file with selected ID

Reeza — Wed, 21 May 2014 16:31:07 GMT

If you're new to SAS, the SAS tutorials on the UCLA website are a great resource.

SAS Learning Module: Subsetting data in SAS

SAS Class Notes: Managing Data

Re: Creating a subset file with selected ID

ballardw — Thu, 22 May 2014 16:58:30 GMT

If they are character variables and not numeric you'll to quote each value:

in ('122142', '321212', etc)

the commas are optional in later versions of SAS but I think help readability of the code.