Then this should be feasible. The inserts can as well use bulk-load. ... View more

Have assessed the percentage of rows that usually is getting updated? If it's too high, incremental update might not much faster. Do you store the data in SQLS for to make it available for a wider audience? If you have have (or could add) a license for SHARE*NET you could make your SAS dataset available directly to users via ODBC. Another option could be if you have access to a Hadoop cluster, load the file there, and have SQLS use that as an external table. ... View more

There are several things that can affect you performance: - SQL Server resources - SAS server resources - Bandwidth - Method of detecting changes. If you have/can create an update timestamp or similar, I would upload the subset to SQL Server, and perform UPDATE/INSERT or MERGE there. Make sure you have relevant indexes for you key. ... View more

Studio on Viya 4 is bot the exact same product as in 9.4/3.5, even if they loko similar. And ASFAIK there is no such functionality OOTB for this. You current options would be: Stay in EG, it has support for Viya 4 Program you own version of this, ising MP CONNECT Transfer you SMC logic to SAS Job Flows The DI Studio transformation Fork which is similar to what you describe has not yet been implemented in SAS Studio. ... View more

Agree that permission doesn't make sense, unless you are using row-level permissions. Assumed you have tried tracing to get more information out? options sastrace="d,,,ds" sastraceloc=saslog nostsuffix msglevel=i; ... View more

Your example is abstract, but even so your "want" data set looks hard to use. What is the purpose of the different variables? Without knowing the application I would suggest transposing the data instead. This removes all blank cells, and keeps the lineage from which columns the values originated. ... View more

Short on the components you are mentioning: OLAP cubes Detailed (single table) will be migrates to CAS tables. Start Schema will migrated as Viya Job definitions - which in turn creates CAS tables. DI Studio: many transformations haas a like-4-lika migration path, some don't. Some options in transformations are not supported. When a transformation can't be migrated like-4-lke, a program step is created (lika a User Written Code in DIS).  Again, this information will be given to in per job/object level if you perform Content Assessment. ... View more

There are so many different use cases, and specific customer configurations, so I think it will be hard to get relevant input here. Your starting point should be to do a Content Assessment. From this you can identify potential risk areas for your migration, and perform detailed analysis. ... View more

The reports available are described (on a high level): https://documentation.sas.com/doc/en/bicdc/9.4/evug/n12v4rjg74mgrhn19m2gg64rerxq.htm They require that you activate logging features in your platform. Couldn't find a report that would suit your needs directly, but logging analysis tells what PROCs being used, that may say something on what products being used. I think using Content Assessment would give you more insight. ... View more

Nice! But if I can wish I think it would be nice if this option is remembered. Now I have to check this every time I return to this page. ... View more

Assumed you have tested use role RL_SF_DP_MDS_CONSUMER_UAT02; use warehouse wh_lending_m; in Snowsight, using the SRV_FCH_SAS_UAT02_SASCONNECT login? ... View more

As I understand it, you can set authorizations to libraries inside SAS Viya. But, this probably won't stop user from accessing the library path directly. "The data source definitions do not reside in folders and are created with READ permissions for all authenticated users. Operating system permissions to the library physical paths are respected by the Compute server when the libref is assigned. This means that if a user cannot read the file-system directory they will not see the library in their SAS session." https://communities.sas.com/t5/SAS-Communities-Library/Managing-Connections-to-Data-Sources-and-SAS-Libraries-for/ta-p/825138 ... View more

Base libraries uses file system authorizations, so speak to your platform/security team for guidance. ... View more

I don't think there's any reports OOTB for SAS Management Console. SAS Content Assessment has som reports on usage and products. If you have Viya 3.5 you can view them in VA. Otherwise you can probably build your own reports from the data mart tables that is generated. ... View more