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.
Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9.
Early bird rate extended! Save $200 when you sign up by March 31.
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.