topic Re: PROC SQL help in New SAS User

PROC SQL help

marleeakerson — Fri, 17 Jul 2020 17:35:28 GMT

Hello,

I need some help with a proc SQL problem. Take the sample data below:

Table 1

Code Description

1 X

2 Y

3 Z

Table 2

Code ID

2 a

3 b

4 c

So I want to pull all the observations from Table 2 that have a matching Code from Table 1 (so this would be Code 2 and Code 3).

Is there a way to do this in SAS (I presume it is easiest with proc SQL but if it works with a data step that is great too)

Thanks!

Re: PROC SQL help

Reeza — Fri, 17 Jul 2020 17:42:43 GMT

Do you want other columns for Table2?

proc sql;
create table want as select * from table1 where code in (select code from table2);
quit;

proc sql;
create table want as select t1.*, t2.ID
from table1 t1 right join
table2 t2
on t1.code=t2.code;
quit;

Re: PROC SQL help

Reeza — Fri, 17 Jul 2020 17:44:32 GMT

And just a quick note that the SQL documentation has many examples that come in useful.
https://documentation.sas.com/?docsetId=sqlproc&docsetTarget=n1ncn0pznd8wrln1tnp3xdxjz9xz.htm&docsetVersion=9.4&locale=en