Recently in the SAS Community Library: SAS' @StuartRogers provides a close look at the new Microsoft Entra Gallery application and details how it can be used.
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
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
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