topic Proc univariate will not stop running in SAS Programming

Proc univariate will not stop running

drosh — Tue, 05 Jul 2016 13:30:22 GMT

Proc univariate will not stop running. It may have something to do with the changes I made in options. However, not sure what those changes were. Can someone help me reset SAS to its original settings? I'm using version 9.3

The error I get is: PROC UNIVARIATE is currently executing. All subsequently submitted statements will not begin executing until its completion.

Re: Proc univariate will not stop running

ballardw — Tue, 05 Jul 2016 15:06:43 GMT

Not the friendliest approach but terminate the SAS session if it is taking too long. Settings are unlikely to be involved unless you are accessing output to a network location with slow response.

Before re-running your proc univariate take a look at the dataset with either proc contents or the explorer.

If there are many records and many variables the time is often actually associated with building the results tabless and requested graphs.

Consider if you need all of the variables.

It often helps to post the code of anything submitted causing performance issues as suggestions without details often lead to lots of responses of "I am not using that option". With the submitted code then fewer guesses are involved.

Re: Proc univariate will not stop running

drosh — Tue, 05 Jul 2016 15:10:02 GMT

Here is the code I was running. There is nothing fancy in it.

proc univariate data = sasuser.salary;
run;

##- Please type your reply above this line. Simple formatting, no
attachments. -##

Re: Proc univariate will not stop running

ballardw — Tue, 05 Jul 2016 17:07:17 GMT

How many records are in the dataset? How many numeric variables?

Re: Proc univariate will not stop running

drosh — Tue, 05 Jul 2016 17:19:02 GMT

I have corrected the issue, it was due to the scroll lines in output not
being set to zero.

Thanks for your help!

##- Please type your reply above this line. Simple formatting, no
attachments. -##