@ChrisHemedinger - Exterminate! Exterminate! 😆 ... View more

The SAS Viya Copilot logo includes a robot that looks a lot like a Doctor Who Cyberman that used to scare me witless as a kid 😆. Wonder if anyone else in the Community remembers them?! ... View more

Maybe you could resolve this limitation by using multiple browser windows? ... View more

What does your SAS log report when you assign the SNOW LIBNAME? Do you get something like this? I've never had any problems with Snowflake not recognising the WAREHOUSE option. Maybe try adding SCHEMA = PUBLIC as well to see if that helps. ... View more

Looks like your SAS session is unable to allocate a SAS WORK library. Check your SAS config regarding the WORK folder location and troubleshoot why it isn't accessible. ... View more

Without individual IDs I don't think this is possible. In any case this is more of a Sybase IQ question so you should ask the question on on of their forums. ... View more

We've always used the local system account as it will always have the required permissions to run any services. ... View more

Thanks so much for the interesting read!   I have an interesting encoding story too. Where I work we are in the middle of a major SAS 9.4 upgrade project (M2 to M8 both running on Windows Server). The M2 encoding is Latin1, but during the M8 design phase it was recommended we use UTF-8 to future proof us for handling multiple languages. So far so good. It wasn't apparent to me until our M8 installation was complete and we started to migrate data from our old platforms that changing the encoding default means you have to rewrite all SAS datasets using SAS functionality instead of just using much faster OS copy functionality. That means migrating SAS data instead of taking a few days to copy, it now takes weeks (we are talking multiple platforms and many terabytes here). Yes you can do it with the likes of PROC DATASETS but it sure is slow! This is not the journey I anticipated with a simple decision to use a different encoding standard.     ... View more

@yabwon - Thanks so much for the valuable insights! ... View more

Thanks so much @hashman ! Always good to gain insights into the many and varied ways SAS can be used. ... View more

I recommend you engage with Tech Support regarding the slow upload. ... View more

@hashman @yabwon - Personally I've never found the need to use these memory manipulation functions. What use cases benefit from these? ... View more

What does the Databricks job do? What about using SAS/ACCESS Interface to Databricks to execute a stored procedure running the processes you want instead?  ... View more

BTW, if there is a prior error in your program, your DATA step creating the macro variables won't execute, so your macro variables wont be created. You might want to check that possibility. ... View more

This isn't necessarily a coding issue. If you Google your error you will see this: Can you use FTP successfully from a command line using the FTP command?   Are you using a SAS server or not? If you are then the most likely cause is a firewall rule blocking your connection. You will need to talk to your IT support to confirm this.   Your FILENAME statement also includes a double quote which shouldn't be there:    ... View more