In DI studio new library wizard, what is preassigned library and generic library type?
If a library is defined as pre-assigned in SAS Metadata then the library definition gets executed during SAS invocation.
For pre-assigned libraries via SAS Medatada SAS DIS won't generate a Libname statement in the deployed code.
If using pre-assigned libraries pointing to databases then I'm normally also using libname option defer=yes so that the actual connection to the database only gets established once you actually use a table from that database in your DIS job.
In case your server is locked-down then using pre-assigned libraries allows you to use paths to folders which are otherwise not accessible. That opens up quite a few opportunities when it comes to securing an environment and controlling which users can access what using SAS.
If a library is defined as pre-assigned in SAS Metadata then the library definition gets executed during SAS invocation.
For pre-assigned libraries via SAS Medatada SAS DIS won't generate a Libname statement in the deployed code.
If using pre-assigned libraries pointing to databases then I'm normally also using libname option defer=yes so that the actual connection to the database only gets established once you actually use a table from that database in your DIS job.
In case your server is locked-down then using pre-assigned libraries allows you to use paths to folders which are otherwise not accessible. That opens up quite a few opportunities when it comes to securing an environment and controlling which users can access what using SAS.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.