topic Re: Lookups in SAS Data Management

Lookups

Eitan123 — Mon, 15 Mar 2021 12:59:20 GMT

Hey,

I've got some Data Integration ETL processes made by an ex college, in which there are several lookups.

How can I know, for any given lookup, which columns are the ones being compared between the two tables of the lookup?

I went into one of the lookup's properties assuming that "Mappings" will give an answer but all I see is the source and target tables, without the way the target table got its new columns from lookup.

I'm Using SAS 6.6

Re: Lookups

ballardw — Mon, 15 Mar 2021 14:49:37 GMT

You need to provide lots more detail as SAS might perform "look ups" using Formats, Informats, SQL join/update with tables, Merge/update or modify statements in a data step, hash objects, arrays , or macro variables (to start).

Code doing the "look up" and/ or example content.

Since SAS 6.6 is from 1994 or so I suspect you are using something a bit more recent Maybe SAS Data Integration Studio or Data Flux

Re: Lookups

LinusH — Mon, 15 Mar 2021 15:07:31 GMT

Actually @ballardw "Data Integration Lookups" is specific enough.

And yes, I think the version no is incorrect, it's usually in the form of "9.402" for DI Studio.

To answer the question:

In the Lookup transformation - select the Lookups tab.

Select the lookup you want to examine

Click Lookup Properties button in the lower right corner.

There you'll bothe Source to Lookup mapping, and Lookup to target mapping tabs.