SAS DI Table Lookup with SAS EG

[Maex]

Hello everybody,

how can I make a SAS DI Lookup Table with SAG EG?

Ciao Max 🙂

[Patrick]

SAS EG and SAS DI are two different clients. You can create a permanent table with both clients. 

Not sure why one would do it this way but you could create a permanent table using SAS EG and then register this table in SAS Metadata via SAS DIS and use it in a DIS lookup transformation.

[LinusH]

Actaully I find it easier to create and edit tables in EG rather than in DIS.

[Patrick]

@LinusH 

Can't really disagree but then one has also to consider how to move to production. I normally end-up to implement some simple one-off DIS jobs to create tables based on metadata definitions.

...the "sad" story is: I have to use to SQL Delete transformation to create empty table structures as the SQL Create requires a pre-existing source table.