topic How do I retain only the data specific to identifiers located in another dataset? in SAS Programming

How do I retain only the data specific to identifiers located in another dataset?

lavernal — Fri, 18 Jan 2013 05:35:01 GMT

Hi all,

I am relatively new to SAS and has been trying to sort my dataset. I have a dataset A containing the identifiers for companies I need and another dataset B containing the whole universe of companies. How do I find only the companies I need from the universe in dataset B using the identifiers in dataset A?

Thank you for any advice given.

Re: How do I retain only the data specific to identifiers located in another dataset?

Tom — Fri, 18 Jan 2013 06:02:00 GMT

Many ways.

Classic SAS code.

data want ;

merge A(in=in1) B ;

by id;

if in1;

run;

Proc SQL

proc sql ;

create table want as select * from a left join b on a.id = b.id ;

quit;