@Tom wrote: @Patrick wrote: I'm still mostly using EG but was curious to see how this could work with Studio 3.8 connecting to a Linux server.   The quickest adhoc way I could figure out was: 1. Export to Excel and store somewhere on the SAS compute side as documented here.  2. Open the Excel file out of a WinSCP session that's configured to open Excel's directly   Which is pretty much what people that run SAS on Unix have been doing for the past 20-30 years. If you just mount the disks from both Unix and Windows you can use Windows Explorer instead of WinSCP. I know. It's in my experience often hard to get "IT" motivated to establish such a shared mount/access via smb or the like. ... View more

Please update your post as answered in that case. ... View more

I finally managed to install SAS 9.4 64-bit on my MacBook Pro M2, and it doesn't take any advanced computer knowledge. My equipment: 2022 MacBook Pro M2, 24 GB Memory, 1TB HD. Software: Parallel Desktop 18 for Mac, Windows 11 ARM Enterprise version  I didn't try Windows 11 Pro on ARM, though.   Just do a clean installation of Windows, then install SAS 9.4 64-bit FIRST. I chose 32-bit EG, but I guess that doesn't matter much. Before installing SAS, stop sharing the Documents folder on Mac and Windows. Assign a local folder on Windows for the Documents, so the SAS won't return "NOTE: Unable to open SASUSER.PROFILE. WORK.PROFILE will be opened instead." message after the installation is completed.   After installation, try to see if your SAS works okay. If it does, then save the Snapshot. You might want to install other computer packages, which is very tricky. I found that my base SAS would no longer work every time I installed Microsoft 365. However, I can install Office 2021, and they work fine together. Every time you want to install a new computer package, save the current working environment with Snapshots on Parallel Desktop. You might want to have a larger HD for this. I think 512 GB or above is essential.   SAS 9.4 32-bit generates several mistakes during the installation and the SASUSER.PROFILE cannot be opened even without sharing the Documents folder, but it somehow can still run regressions.  ... View more

@Debi_SAS It's currently scheduled for release in Jan 2023, and we'll have more details then. Most of the changes are to update underlying components to newer/more modern versions. ... View more

This order looks sensible to me. PC Files Server can start/stop at any time.   OLAP should start with other Compute-tier services... per official documentation, start after Web Infrastructure Platform Data Server but before Object Spawner. ... View more

can we have any reference examples, how to create special metadata folder just for a library and create two sas metadata groups. ... View more

Here are few links you can have a look at https://www.lexjansen.com/scsug/2004/Clifford%20-%20Scalable%20Access%20to%20SAS%20Data.pdf   SAS online Docs: https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/engspde/engspdewhatsnew94.htm https://support.sas.com/rnd/scalability/spde/spde_setup.pdf ... View more

Record and play response files work very well.     ... View more

I am encouraged by your endorsement of PowerShell. I have dabbled for years but it is hard to replace 20 years of shell scripts. Regarding gathering usage metrics, I have found that management are rarely interested until there is an issue - review of licensing costs or some other product they have been convinced is cheaper. Lately, it has been cloud cost estimates.   One day before I retire, I am hoping there will be in person user group meetings to discuss this stuff. ... View more

If you don't have EG, or local Base SAS, or the EBI stack, or Viya - there is another option   My team have built a free, open source server for SAS:  https://github.com/sasjs/server   You can install it on your Linux server in 2 lines of code:   curl -L https://github.com/sasjs/server/releases/latest/download/linux.zip > linux.zip unzip linux.zip You can then just run `./api-linux` to launch.  Give it the path to your executable and you immediately have a web server (on port 5000) with SAS in it. If you'd like to do further setup (whitelisting, user accounts, alternative runtimes, permissions etc) check out the docs:  https://server.sasjs.io     ... View more

I assume you want to do an upgrade in place so you will need to bear in mind that SAS will be out of action for the duration of the upgrade. Typically this is a multi-day job so your management need to be OK with the downtime. ... View more

Here's a Powershell script (need to take the .txt extension off for that we use to monitor SAS sessions on our Windows server. It creates a CSV file with a list of user ID, PID, start time, CPU (total and user) and command line. It's scheduled to run every 15 minutes and then we have SAS programs to process the files once a day. Years ago when we were on Solaris we had a shell script which did a similar thing. ... View more

It's part of the suite of apps that come with Base and SAS Metadata Server, such as SAS Management Console. No special license needed. The standalone install (as @Nigel_Pain points out) can be a challenge though, as you must go through the SAS Deployment Wizard. ... View more