Recently in the SAS Community Library: When developing a brand-new SAS Viya job, it sometimes might be hard to figure out where to begin. It’s always a best practice to start with a working SAS program, but when it comes to developing a prompt form for the end user, there are many decisions to make. Should you create an HTML form? What kind of controls should you provide to the user? What parameters do you need to supply? Fortunately, SAS provides a set of sample jobs, including both code and forms, that can make getting started much easier. This post by @GregTreiman discusses how to use the included SAS samples to jump start your own job development.
Greetings all! We are getting workspace I/O errors in SAS EG. It is in our production environment with a viya backend. This is happening in EG on a virtual machine that is used by mulitiple people. So several people could be using the same client at the same time. Looking at SAS Enterprise Monitor we don't see the work environment as being full. Is it possible that the issue is with users sharing the same client on a VM. I'm thinking that maybe this same issue wouldn't happen if we were using the web base studio. Does anyone have any thoughts on this? Let me know if there are any follow-up questions to help clarify the question.
... View more
Hi
Thank you for your inputs and helps on this topic.
I was able to run the proc lifetest and phreg but confused, which datasets need to be used to get the information since outputs produces so much information . I need to get the following information. I was providing dataset I have.
/* Create the original dataset */
*Information in data
AVAL ->Number of Days after the Treatment that Adverse Event Occurred"
CNSR-> If the event occurred, then CNSR =0 otherwise, 1
ARM-> IND and Placebo;
data have;
input USUBJID ARM AVAL CNSR;
datalines;
1 1 1 1
2 1 2 0
3 1 10 1
4 2 5 1
5 2 6 0
6 2 8 1
7 2 10 0
8 2 11 0
9 1 12 1
10 2 13 1
11 2 15 1
12 1 10 0
13 1 18 1
14 2 19 0
15 2 21 1
16 1 23 1
17 1 5 1
18 2 25 1
;
run;
data have;
set have;
if arm = 1 the TRT = 'Placebo';
if arm =2 then TRT = 'IND';
run;
** for Quartiles and estimates/ Not using any from Estimates data**
proc lifetest method=KM data=have plots=none;*timelist=(5,10,15);
strata arm;
time aval*cnsr(1);
ods output productlimitestimates = estimates
Quartiles = quart;
run;
** for HR and 95 %CI/ Not sure where to get P- value**;
proc phreg data=have;
class arm (ref='2');
model aval*cnsr(1) = arm / risklimits ties=efron rl;
hazardratio arm / diff=ref;
ods output ParameterEstimates = hR;
run;
*** for adverse event free probability and 95% CI at day 10**;
proc lifetest method=KM data=have plots=none timelist=(5,10,15);
strata arm;
time aval*cnsr(1);
ods output productlimitestimates = estiTime;
run;
From PHREG: Cox Model
1 . Probability (IND Vs Placebo) - P-value
2. Hazard Ratio (IND Vs Placebo)
3 . 95% CI (IND Vs Placebo)
From PROC LIFETEST:
Quartiles:
1. Q1 with 95%CI
2. Q3 with 95% CI
3. Median with 95% CI
From PROC LIFETEST:
Adverse Event Free probability at Day 10
... View more
data mydata;
infile "/.../test/wu.valide.auto.prm.lst" FIRSTOBS=6;
input obs rsp $ risk $ line $ cie $ Nb_transactions prime;
run;
I am not setting properly the options.
Does someone better than me can help.
PREMIUMS VALIDATION - TEST
NB
Obs RSP RISK LINE CIE TRANSACTIONS PRIME
1 1843858 85379040
2 3 1843858 85379040
3 AUTO 1843858 85379040
4 AUTO 3 1843858 85379040
5 COMM 322475 14702635
6 PERS 1521383 70676405
7 COMM 3 322475 14702635
8 PERS 3 1521383 70676405
9 COMM AUTO 322475 14702635
10 PERS AUTO 1521383 70676405
11 COMM AUTO 3 322475 14702635
12 PERS AUTO 3 1521383 70676405
13 DIRECT 1777709 86858816
14 RSPCEDED 66149 -1479776
15 DIRECT 3 1777709 86858816
16 RSPCEDED 3 66149 -1479776
17 DIRECT AUTO 1777709 86858816
18 RSPCEDED AUTO 66149 -1479776
19 DIRECT AUTO 3 1777709 86858816
20 RSPCEDED AUTO 3 66149 -1479776
21 DIRECT COMM 322475 14702635
22 DIRECT PERS 1455234 72156181
23 RSPCEDED PERS 66149 -1479776
24 DIRECT COMM 3 322475 14702635
25 DIRECT PERS 3 1455234 72156181
26 RSPCEDED PERS 3 66149 -1479776
27 DIRECT COMM AUTO 322475 14702635
28 DIRECT PERS AUTO 1455234 72156181
29 RSPCEDED PERS AUTO 66149 -1479776
30 DIRECT COMM AUTO 3 322475 14702635
31 DIRECT PERS AUTO 3 1455234 72156181
32 RSPCEDED PERS AUTO 3 66149 -1479776
... View more
Please be gentle - I'm new - using SAS 9.4 I'm trying to find the first date the Pick_Date is Null. Any assistance is appreciated! Thanks in advance!!
Here is what my data table looks like:
Table Orchard
Apple_Var
Ready_Date
Pick_Date
Change_Date
Red_Del
8/24/2024
8/24/2024
8/24/2024
Red_Del
8/24/2024
8/25/2024
8/25/2024
Red_Del
8/24/2024
8/26/2024
8/26/2024
Red_Del
8/24/2024
8/27/2027
8/27/2024
Red_Del
8/24/2024
8/28/2024
Granny
8/26/2024
8/26/2024
8/26/2024
Granny
8/26/2024
8/27/2024
8/27/2024
Granny
8/26/2024
8/28/2024
8/28/2024
Granny
8/26/2024
8/29/2024
Here is my desired output:
Table Orchard
Apple_Var
Ready_Date
Pick_Date
Change_Date
Red_Del
8/24/2024
8/28/2024
Granny
8/26/2024
8/29/2024
... View more
Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9. Sign up by Dec. 31 to get the 2024 rate of just $495. Register now!