The SAS Output Delivery System and reporting techniques

Lookup b/w two datasets multiple variable

Reply
Frequent Contributor
Posts: 78

Lookup b/w two datasets multiple variable

I have Two datasets as below "primary" and "secondary" :

PRIMARY

OBS CJOB       HLQ    NO1     NO2  NO3 ....

1       JOB1       SMGP            1          2         2

2       JOB2       TEMP            8           8         8

3       JOB3        PERM           9           9         9.
.

.

.

SECONDARY

CJOB    HLQ

JOB1      TEMP

JOB2      XXXX

I have a requirement to do lookup from Secondary dataset to Primary dataset  and get match output based on either CJOB or HLQ

So from above example Since Secondary dataset as Job1/Job2 and HLQ=TEMP   

Output should be Observation 1 and 2

I tried with Index however since Key can be on one unique that doesn't seems to work ..any idea??

Esteemed Advisor
Posts: 5,198

Re: Lookup b/w two datasets multiple variable

SQL with an OR join criteria.

Data never sleeps
Frequent Contributor
Posts: 78

Re: Lookup b/w two datasets multiple variable

Would you be able to give me example?

Esteemed Advisor
Posts: 5,198

Re: Lookup b/w two datasets multiple variable

proc sql;

select p.*

from primary as p

inner join secondary as s

on p.cjob = s.cjob or

p.hlq = s.hlq

;

quit;

Data never sleeps
Ask a Question
Discussion stats
  • 3 replies
  • 368 views
  • 0 likes
  • 2 in conversation