topic Re: Hmmm.... Is SAS Dead In The Water?, or Just Taking It's Time? in SAS Programming

Hmmm.... Is SAS Dead In The Water?, or Just Taking It's Time?

NKormanik — Thu, 03 Mar 2022 10:13:59 GMT

Doing a series of Proc Logistics on multiple datasets (finally!).

SAS seems to have frozen after getting through around 7 datasets (of 59 total).

Trying everything I can think of to take a pulse to see if SAS is still alive.

Resource Monitor shows it's running, 31 threads, 6.24% of CPU.

Analyze Wait Chain says "One or more threads of sas.exe are waiting to finish network I/O." On a stand-alone machine?

Is there a better way to ascertain whether the patient is alive or dead?

Is it a good idea, or even possible, to 'flush' between iterations? In other words, before allowing SAS to proceed onto the next dataset, should I insist it visit the Ladies Room? How exactly do I do that?

Thanks!

Nicholas Kormanik

Re: Hmmm.... Is SAS Dead In The Water?, or Just Taking It's Time?

ChrisHemedinger — Thu, 03 Mar 2022 12:23:51 GMT

Some tricks I do when setting up long-running jobs:

redirect SAS log to known location, and periodically check that log info is being updated. On UNIX I use "tail -50 logs/file.log". On Windows I use Notepad++ which doesn't demand an exclusive lock.
If the job will create lots of transient data sets that aren't needed for the entire process, use PROC DELETE or PROC DATASETS to delete these between steps.
Redirect the WORK option to a folder that has lots of space in case some tasks (SORT or SQL) will generate large utility files. Mostly applies to UNIX where quotas can differ based on space.

For a Windows job already in motion where you haven't done these steps, use a tool like Process Explorer to monitor the open file handles to find signs of life.

Re: Hmmm.... Is SAS Dead In The Water?, or Just Taking It's Time?

Ksharp — Thu, 03 Mar 2022 12:25:51 GMT

https://blogs.sas.com/content/iml/2018/04/25/sweep-thousands-of-regressions.html

https://blogs.sas.com/content/iml/2017/02/13/run-1000-regressions.html

Re: Hmmm.... Is SAS Dead In The Water?, or Just Taking It's Time?

ballardw — Thu, 03 Mar 2022 14:31:23 GMT

And maybe send all output to an ODS file destination instead of the default HTML results window. Depending on procedure and output it can take more time to make the "results" output display than to run the analysis.

Re: Hmmm.... Is SAS Dead In The Water?, or Just Taking It's Time?

SASKiwi — Thu, 03 Mar 2022 22:39:14 GMT

If any SAS programs are running slowly then look through your SAS log. If Real Time taken for any step is a lot higher than the CPU Time then you can be pretty much guaranteed that your bottleneck is IO.

I'm assuming SAS is running your PC as you are looking at MS Task Manager. So where are you reading your data from and writing to? If you are using remote drives or file servers for your data these can be really slow. If all of your data is on local drives then you'll be limited by their bandwidth. How old is your PC? Solid State drives are way faster than traditional disk drives.