topic Re: Table lookup in SAS Programming

Table lookup

mauri0623 — Thu, 27 Jun 2019 18:39:18 GMT

Hello,

I have the followings,

I have one table with 4 variables each, the first table has the variable names as alc, accounting, odn, and tas and the other has these variables as prj_num, loa, task, and tas. I want to do a table lookup where,

alc=prjnum and

accounting = loa and

tas = tas and

odn =task if they are the same I then need to place them in a data set called match, If however,

alc=prjnum and

accounting = loa and

tas = tas and

task is missing I want to place them in a data set called dai.

Please your help is professional accepted and much appreciated.

Best Regards,

Mauri

Re: Table lookup

PeterClemmensen — Thu, 27 Jun 2019 18:40:33 GMT

Can you provide a small example of what your data looks like? Makes it much easier to provide a usable code answer.

Re: Table lookup

Reeza — Thu, 27 Jun 2019 18:42:48 GMT

Use a LEFT JOIN or MERGE to join the main table to the look up table.
Split it out afterwards using a data step to split it to different data sets.

Re: Table lookup

mauri0623 — Thu, 27 Jun 2019 19:31:44 GMT

I can supply you with partial data that resembles the real data,

Please see both attachments.