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

Microsoft Edge is also supported by SODA and runs on Macs. You could give that a try. Alternatively if you have access to a Windows computer you could also use Enterprise Guide with SODA and that bypasses browser issues entirely. ... View more

@ecruz1989  - It is worth noting that 9.4M7 is now in limited support but M8 has another 3 years of full support. What is your organisation's policy regarding use of limited support software? Am I correct in assuming the M8 upgrade will be an upgrade in place? Are the 4 servers one SAS installation or 4 separate installations? Even if it is one installation then 4 weeks sounds reasonably realistic.  ... View more

We would need to see a snippet of the SAS log from the scheduled job from the start until the macro error to understand what is happening. ... View more

My guess is that each of your scripts is run in its own SAS session hence it won't know about macro variables created in the first script / SAS session. Running the scripts in one SAS session would solve the problem. However since you haven't provided any details regarding how your scheduled job is structured, it is a bit hard to offer further guidance. ... View more

Try 10.203.25.121 in your EG connection profile then. It is not recognising your host name. ... View more

You will need to talk to your SAS support people to fix this. Troubleshooting will be needed to find what is causing it. Is this the first time you have tried setting this up or was it working and now it isn't?   One test you can try is to ping the SAS server from a Windows command line: ping videssasaos001.nh.inet   If this is unsuccessful then it means the SAS server isn't available on your network.   Also normally you connect to your SAS metadata server, not your workspace server and that is on the default port of 8561. ... View more