Hello Experts,
I am running Data Flux job which contains only SAS code and getting below error.
Code is very simple and environment has enough workspace but still getting below error::
ERROR: Close error:
ERROR: Error allocating statement handle:
WARNING: The data set WORK.ONE may be incomplete. When this step was stopped there were 0 observations and 0 variables.
NOTE: Compression disabled for the WORK.ONE table because the compression overhead would increase the size of the table.
Additionally code working fine in SAS Studio but while runnig it through SAS DF management server I am getting error in log.
Does anyone face similar issue and if yes please let me know what is resolution for this ..
Code ::
data work.&tblenm(compress=yes); set hdp.&tblenm; where input(load_date,DDMMYY10.) >= "&purge_dt."d; run;
Thank you in advance .
... View more
We just ran an upgrade and installed some patches in Viya (3.4) and when it came back online, we couldn't get into SAS Studio, getting the error below. It was working fine before. If the screenshot isn't easy to read, the text says: "There was an error while starting SAS® Studio. Unable to create compute server session. Failed to launch process. Failed to launch process: host=vSASviya.inhouse.nwalliance.org port=53230 ssl=false Failed to connect to server. A valid authentication credential could not be found." We are able to access everything else in Viya. When looking in Environment Manager, the launcher-server is running, so it appears that maybe authentification was reset, but can't seem to find how to resolve or where to troubleshoot this. Thanks, Aaron James Northwest Energy Efficiency Alliance
... View more
Hi all, Data steps and most SAS procedures require many statements terminated by a RUN; before they can run. Proc SQL is different. Every statement is complete and can be executed immediately, without knowing what follows. So I wonder, what is the role of the QUIT; statement? Does it ever make a difference, besides writing the true running time to the log? I never use to bother with the QUIT; statement. Now I tend to use it for neatness and for avoiding being scolded. But the question remains: is it ever necessary? PG
... View more
I want to Apply Tests for Special Causes in the p-chart, but the sample size for each group is different. So, I don’t have a fixed UCL and LCL, and I will get the following warning with below code: WARNING: Asymmetric control limits encountered for yes_answer1 for at least one subgroup. proc shewhart data=tmp2;
pchart yes_answer1*quarter / subgroupn = total_count1
tests =1 to 8
TESTNMETHOD=STANDARDIZE
table
tablelegend;
run; Note: The SHEWHART procedure provides an option for working with unequal subgroup sample sizes. For example, I can use the LIMITN= option to specify a fixed (nominal) sample size for computing the control limits. Below is the sample size for each group that I have; my question is, how can I choose the number for LIMITN? quarter Subgroup 2021Q3 30 2021Q4 66 2022Q1 54 2022Q2 66 2022Q3 69 2022Q4 74 2023Q1 83 2023Q2 96
... View more
I am about to take my A00-215 exam. I need an exam preparation resource. Does anyone recommend the best practice test for successful exam preparation?
... View more