SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

WORK Target Table

Reply
Super Contributor
Posts: 326

WORK Target Table


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!

Super User
Posts: 5,426

Re: WORK Target Table

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

Data never sleeps
Super Contributor
Posts: 326

Re: WORK Target Table

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.

Super User
Posts: 5,426

Re: WORK Target Table

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

Data never sleeps
Ask a Question
Discussion stats
  • 3 replies
  • 232 views
  • 0 likes
  • 2 in conversation