Hello, I'm analyzing data from a randomized complete block design at multiple sites across multiple years. There are 4 blocks (1-4) at each site, so block is nested within each site (block(site)). I am trying to run this as a simple mixed model and also as a repeated measures. I would just like to know if my coding is correct for both. Any insight would be appreciated. Thanks. A single year analysis to start : proc mixed ; class Site Block Treatment; model biomass = Site|Treatment; random Block(Site); run; Multiple years without repeated statement. Random terms: block nested within site and then block*site*treatment to account for multiple observations across years. proc mixed ; class Year Site Block Treatment; model biomass = Year|Site|Treatment; random Block(Site) Block*Site*Treatment; run; Multiple years with repeated measures, but I'm unsure how to show that block is nested within each site (maybe the interaction accounts for this). proc mixed ; class Year Site Block Treatment; model biomass = Year|Site|Treatment/ddfm=kr; repeated Year / SUB= Site*Block*Treatment type=un ; run;
... View more
Hello, I have a deployed SAS job runs in flow which always fails during the first run and after we re -run manually it will get succeeded. The issue is due to sql server stored procedure which we call in it in the SAS job. So we thought of adding exception handling in the schedule manager for that job. We have defined that 'if the job fails with exit code greater than zero, we asked it to re-run automatically', But its not working. Is there any other way to remove the manual process of re run ? Thanks
... View more
Hi Folks, I hope you're doing well. I wanted to reach out to see if you could help me with finding the CAS memory Utilization in SAS Viya LTS version 2022.09. I've been trying to locate information like "Memory Used", "Memory Free", "Memory Total", etc., as mentioned in the documentation. The documentation suggests that we can view this information in SAS Environment Manager under the Servers section, specifically under cas-shared-default and then CAS Memory Utilization. However, I couldn't seem to find the CAS Memory Utilization under cas-shared-default. Do you happen to know of any other method or location where we can view the CAS memory Utilization in SAS Viya LTS 2022.09 version? Any guidance or assistance you can provide on this matter would be greatly appreciated. Thank you in advance for your help! Thanks, Hemanth MG
... View more
Hi, I have a job flow set up. One of the jobs has a warning (but not an error and does not fail). In this scenario the next job in the flow after the one with the warning does not start and I think this is because of the previous job having a return code. One used to be able to control this in LSF but how does one do this in Viya Flows so that the next job would start and accept a job with warnings as a complete job? I have tried abort 0 in my code which works but this changes the job status to 'Cancelled' which is not ideal. Thanks Andre
... View more
Hi,
I took the SAS 9.4 Base Certification practice exam. Below are the steps for question 13.
This project will use data set cert.input36. At any time, you may save your program as program36 in cert\programs. Write a SAS program that will clean the data in cert.input36 as follows:
Step 1:
create a temporary data set, cleandata36.
In this data set, convert all group values to upper case.
Then keep only observations with group equal to 'A' or 'B'.
Step 2:
Determine the MEDIAN value for the Kilograms variable for each group (A,B) in the cleandata36 data set. Round MEDIAN to the nearest whole number.
Step 3:
create results.output36 from cleandata36
Ensure that all values for variable Kilograms are between 40 and 200, inclusively.
If the value is missing or out of range, replace the value with the MEDIAN Kilograms value for the respective group (A,B) calculated in step 2.
How many observations are in results.output36?
The original dataset had 5000 observations.
My answer was 4897 observations.
The practice exam has 4992 observations for the answer.
I can't figure out why there is a 95 observation difference.
I did answer the second question regarding the median correctly.
Thanks for your help.
I used the following code:
data cleandata36; set cert.input36; group = upcase(group); where group in ('A' 'B'); run;
proc means data=cleandata36 median maxdec=0; class group; var kilograms; run;
data results.output36; set cleandata36; if Group = 'A' and kilograms lt 40 or kilograms gt 200 then kilograms = 79; if Group = 'B' and kilograms lt 40 or kilograms gt 200 then kilograms = 89; run;
proc means data=results.output36 maxdec= 2 min max mean median n; class group; var kilograms; run;
The answer code is: data work.cleandata36; set cert.input36; group=upcase(group); if group in ('A','B'); run;
proc means data=work.cleandata36 median;
class group;
var kilograms;
run;
data results.output36;
set cleandata36;
if Kilograms < 40 or Kilograms > 200 then do;
if group='A' then kilograms=79;
else kilograms=89;
end;
run;
proc contents data=results.output36;
... View more