BookmarkSubscribeRSS Feed
milts
Pyrite | Level 9


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!

3 REPLIES 3
LinusH
Tourmaline | Level 20

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
milts
Pyrite | Level 9

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.

LinusH
Tourmaline | Level 20

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

Data never sleeps

sas-innovate-wordmark-2025-midnight.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.


Register now!

How to connect to databases in SAS Viya

Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 3 replies
  • 974 views
  • 0 likes
  • 2 in conversation