topic Lookup b/w two datasets multiple variable in ODS and Base Reporting

Lookup b/w two datasets multiple variable

rkumar23 — Wed, 24 Jun 2015 06:49:28 GMT

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 — Wed, 24 Jun 2015 06:51:01 GMT

SQL with an OR join criteria.

rkumar23 — Wed, 24 Jun 2015 07:04:46 GMT

Would you be able to give me example?

LinusH — Wed, 24 Jun 2015 07:27:13 GMT

proc sql;

select p.*

from primary as p

inner join secondary as s

on p.cjob = s.cjob or

p.hlq = s.hlq

;

quit;