topic Re: WORK Target Table in SAS Data Management

WORK Target Table

milts — Thu, 14 Feb 2013 09:26:40 GMT

Hi,

I'm using DI 3.4 and I would like to generate the code for a job whose target table's libref is work. However I'm getting an error Invalid Metadata: No library specified. Would it not be possible to generate a code for a DI job whose target table is a work table? Thanks!

Re: WORK Target Table

LinusH — Thu, 14 Feb 2013 16:39:47 GMT

Rare situation to have a Work target table...

Without investigating that, have you defined the Work-library in metadata?

No problem for me (DIS 4.5).

Re: WORK Target Table

milts — Fri, 15 Feb 2013 01:09:21 GMT

You are correct it's kinda odd to see something like that. I haven't explored their whole process yet why they designed such.

There are no work-library declarations in the metadata. The target table's library is only set to the default which is <none> since the table should reside into the work path generated when the SAS session begins.

Re: WORK Target Table

LinusH — Fri, 15 Feb 2013 12:07:49 GMT

Then you need to declare it in metadata. Just define it as pre-assigned, and then it will probably work.