topic SAS DI Table Lookup with SAS EG in New SAS User

SAS DI Table Lookup with SAS EG

Maex — Thu, 07 Mar 2019 14:00:47 GMT

Hello everybody,

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

Ciao Max 🙂

Re: SAS DI Table Lookup with SAS EG

Patrick — Sun, 10 Mar 2019 00:33:39 GMT

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.

Re: SAS DI Table Lookup with SAS EG

LinusH — Sun, 10 Mar 2019 20:50:22 GMT

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

Re: SAS DI Table Lookup with SAS EG

Patrick — Sun, 10 Mar 2019 21:35:45 GMT

@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.