Those LIBNAMEs look like they are using SAS/SHARE. There could be a variety of reasons for the security failure errors. Follow @LinusH 's advice.   BTW, it is not a good idea to post unencrypted passwords in screenshots. You are most likely breaking your organisation's security rules. ... View more

I've never used Airflow but in my experience it is best practice to have your scheduler, or the scheduler's agent, running on the same server as SAS. This isn't possible when SAS runs on Windows Server as Airflow runs only on Linux. Google tells me could run Airflow on Windows Server in a virtualised environment (a VM) running Linux. But that seems like way too much complication just to run a scheduler.   Enterprise Schedulers get around the problem of scheduling across different OS's by having OS compatible agents running on each server. Control-M is one such example.   We use the SAS-provided OEM Platform Process Manager to schedule on Windows Server SAS and that works just fine as it nicely integrates with SAS Management Console. Airflow can't do that.   I think you are going to run into problems with executing Windows Server SAS from Linux Airflow as you actually have to remotely logon to the Window Server to execute any commands. FTP might be one possible option but it all sounds very clunky...       ... View more

I suggest opening a track with SAS Tech Support is your best option for this type of issue.  ... View more

Have you checked out the CHAR_COLUMN_LIMIT option? By default it is 32767, but you could set it to the maximum expected limit across all of your character columns. It can be applied as both a LIBNAME option and dataset option so you could vary this by dataset. ... View more

I suggest you open a Tech Support track. I'm just providing advice from the documentation as I've never used Databricks. ... View more

Does this help? https://learn.microsoft.com/en-us/answers/questions/2287432/(article)-restore-old-right-click-context-menu-in   ... View more

Providing a screenshot of what you are doing would be helpful. ... View more

Have you tried running a SAS program from the Windows command line like so: sas -sysin 'c:\MyFolder\MySASpgm.sas' ... View more

The first problem I see is this line: %if %sysfunc(exist(LABTRET.ABT_CS_&YYMM.Y()) %Then %Do; You have an extra left bracket on the EXIST function. Try this: %if %sysfunc(exist(LABTRET.ABT_CS_&YYMM.Y)) %Then %Do;     ... View more

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