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.
Save $250 on SAS Innovate and get a free advance copy of the new SAS For Dummies book! Use the code "SASforDummies" to register. Don't miss out, May 6-9, in Orlando, Florida.
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.