Thanks @Madelyn_SAS . I see that data connectors are included in the SAS Access interface on Viya. ... View more

My understanding is that anyone with right competence and authorization can do it. So it's up to you what kind of ownership of this process you would like to have. ... View more

@thesasuser wrote: I would appreciate if you can list the other approach for CAS tables. Thanks once again. Tables Action Set: Syntax https://go.documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/caspg/cas-table-TblOfActions.htm alterTable Action (in Tables Action Set) https://go.documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/caspg/cas-table-altertable.htm drop= parameter in table.alterTable drop={"variable-name-1" <, "variable-name-2", ...>} Columns to drop https://go.documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/caspg/cas-table-altertable.htm#SAS.cas-table-altertable-drop Koen ... View more

This might be a helpful place to start: https://communities.sas.com/t5/Ask-the-Expert/The-Basics-of-SAS-Viya-4-Administration-Q-amp-A-Slides-and-On/ta-p/829376 ... View more

Have you had a look at this post: https://communities.sas.com/t5/SAS-Communities-Library/SAS-Viya-3-5-SAS-Studio-and-SAS-Compute-Server-non-functional/ta-p/616617? ... View more

@thesasuser - Thanks for the "drop-in" replacement definition as I was not entirely clear what you meant here. BTW, if your SAS 9.4 is not on maintenance M8, then I would regard an upgrade to M8 on your Windows platform as a drop-in replacement. It will also give you another 5 years full support unlike Viya 3.5. ... View more

SAS obeys Windows permissions. I can only assume that SAS users who were able to write to SASApp had the Windows permissions to do so otherwise they would get the error you've posted about.   Try the workarounds in the SAS Note @Tom links to. ... View more

@thesasuser    Below document has the details of how you can configure your database with SAS SAS Viya on Microsoft Azure: Configuration Tasks check section ' Configure Data Access: Oracle Example .' pg#17 ... View more

DLGCDIR allows you to change the working folder within a SAS program, many times if you want (and it also allows you to query what folder is the working folder). SASINITIALFOLDER can only be set at the launch of SAS via the CONFIG file or via invocation options. ... View more

@thesasuser    Have a look at this online doc SAS Intelligence Platform: Overview Architecture of the SAS Intelligence Platform  Go through all the section and sub-sections. It will explain and answer your questions and more   Happy reading, Ahmed ... View more

I've never heard of a product called "SAS portal."     There is SAS Information Delivery Portal, as you mentioned, but note that it is retired now (as of 9.4M8) https://documentation.sas.com/doc/en/bicdc/9.4/biwaag/n0gzjtb3z2o11vn1y0k5kxm7vvxc.htm#:~:text=The%20SAS%20Information%20Delivery%20Portal%20provides%20a%20web%2Dbased%20user,internal%20or%20external%20web%20pages.   I think some companies might use the generic term "SAS portal" to describe a website they have built that provides access to reports generated by SAS.   SAS Stored Process Web App is different than IDP.  You can read about SPWA at: https://documentation.sas.com/doc/en/itechcdc/9.4/stpug/n1gt44n8wc0la0n18s9kajwq0o2q.htm ... View more

Hi @thesasuser, You can use the caslib statement. I'd start with the documentation here to get familiar with caslibs. Note: One pre-req is you have to be in the SASAdministrators group to create and manage caslibs. ... View more