Lookup b/w two datasets multiple variable

[rkumar23]

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??

[LinusH]

SQL with an OR join criteria.

[rkumar23]

Would you be able to give me example?

[LinusH]

proc sql;

select p.*

from primary as p

inner join secondary as s

on p.cjob = s.cjob or

p.hlq = s.hlq

;

quit;