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

[lavernal]

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.

[Tom · Accepted solution]

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;