The Metadata Browser (invoke with the metabrowse command) in the SAS Windowing Environment is particularly useful for navigating the data structures:   ... View more

@freshstarter - Actually we use pre-assigned Snowflake libraries exclusively also. I just used the LIBNAME statement as an illustration 🙂. ... View more

There's no reason why you can't use LIBNAMEs with Passthru to Snowflake. We use them. They look like this: libname SF snow <Snowflake connection definition>; proc sql; connect using SF; select * from connection to SF (SELECT * FROM MySnowFlakeTable); disconnect from SF; quit; Also you should be able to add the bulk loading options to the LIBNAME also. ... View more

FYI, SAS Data Quality has name parsing algorithms that cater for national differences to do the splitting you want. Of course this is more geared to enterprise-wide solutions as opposed to individual requirements. ... View more

@Jonas_Jing - I think you have an IO issue with copying multiple files not a multi-threading restriction. I believe you could use SAS/CONNECT, which comes with Viya, and start several SAS sessions and simulaneously download multiple files that way. ... View more

Use PROC CONTENTS to list the variables in your dataset: proc contents data = MyDataset; run Maybe there is a problem earlier in your code that dropped the variable you need. Use PROC CONTENTS to find where that variable got dropped.  ... View more

I suggest you raise a Tech Support track for this as it requires further investigation. ... View more

A Windows service typically runs under the Windows system account. Try running it with your own user account instead to see if that helps. ... View more

The error you are getting suggests to me that the SAS/ACCESS Interface to Redshift has not been correctly configured. Do you know of anyone where you work who is using SAS with Redshift or are you the first to try? It would also be work confirming that SAS/ACCESS Interface to Redshift is installed and licensed although it most likely is based on the error message: proc product_status; run; proc setinit; run;      ... View more

So what is it that you don't want to replace? Your SAS log or your results or both? The option you refer to is gone in EG 8 but it is possible to keep a log history by having a project log.   ... View more

It is just a note, not an error. If you don't use SAS Studio tasks then you can ignore which is what I do. ... View more

A good starting point is this SAS Support page: https://support.sas.com/software/updates/   Are you doing an upgrade in-place or not? Regardless you should start by running the SAS Content Assessment tool to evaluate your current installation and find any issues with upgrading. ... View more

I wouldn't be putting quotes around metadata-stored passwords like in authdomains as SAS wouldn't be able to tell if it is part of the password or not. Why don't you just try such a password without quotes in an authdomain and see if it works or not? ... View more