I did a simple test with sashelp.class and got expected result. Can you post some test data (in form of a data step/datalines) so we can try your exact scenario? ... View more

Sorry, I don't understand how you wish calculate "order". Can elaborate a bit more? ... View more

To be able to read sas7bdat from SAS compute, you need to mount it. See the community post: https://communities.sas.com/t5/SAS-Communities-Library/Using-Azure-Blob-Storage-for-sas7bdat-files-with-SAS-Viya-Part-1/ta-p/906563 ... View more

Can you clarify what you mean by "data"? ASFAIK ADLS2 is supported for CAS tables, Parquet and ORC libname and via filename. ... View more

.sas programs are just flat files, so from a movement perspective, it's "just" an copy operation of choice. The tricky part is to make them compatible with your Viya environment. Most likely it comes down search paths to file and libraries. If you are migrating from 9.4 on Linux it is potentially easier than from a Windows Server. See Content Assessment Code Check for more details. When it comes to EG, you may need to migrate, since EG is a supported client for Viya. If you migrate EG to SAS Studio you will lose some functionality, Content Assessment Profile should be able to tell you what. ... View more

When you say storage, do you mean SW and data on disk?  Disk is usually cheap (unless you have humongous sized data) and usually easy to augment over time. Cores and RAM usually drives cost. Apart from contacting SAS, here are some useful (?) links: System Requirements: https://documentation.sas.com/doc/en/itopscdc/v_072/itopssr/titlepage.htm?fromDefault=#page=9 Sizing Recommendations: https://documentation.sas.com/doc/en/sasadmincdc/v_072/itopssr/n08i2gqb3vflqxn0zcydkgcood20.htm Sizing Prez: https://communities.sas.com/t5/SAS-Explore-Presentations/Sizing-your-SAS-Viya-4-Environment/ta-p/838247   ... View more

I mean, why don't you just try? ... View more

Not specifically, no. Again, maybe engage with you local SAS team or partner. If you have a specific question/use case you can try to formulate an inquiry here on communities, probably under the Solutions/Data Management. ... View more

@domroy, I can't find any clear migration path either. I seem that Federation Server is supported in Content Assessment, so if you haven't run that already, do. And I would contact your SAS representative with the overall strategy and plans for Federation Server sites. ... View more

Column length up 32 is no problem for SAS, but column name length has the same limitation as table name. If you have tables that you know comply with SAS naming standard (also beware of special character, spaces, initial digit etc) and they're not visible to SAS - try to connect to the database using the same credentials from another client using the same connection configuration. ... View more

I don't have access to Viya 4 at this point. But it seems there is no OOTB functionality for this. It seems that you could implement this on a Flow instance level, by pointing out a program to execute when a job flow exits: https://documentation.sas.com/doc/en/sasadmincdc/v_071/evfun/n0b9cf8ru47gp6n1lvamxqwbr3by.htm#p00388x4a7b6ywn1ce2d03tz88ns ... View more

Ok, I don't have access to Studio Engineer at this point to try myself. What does the "i" symbol say if you click/hoover over it? You should compare data type and columns lengths for your datasets. ... View more

It's hard from just one screenshot to tell what's wrong. Maybe you could attach the generated SAS code? ... View more