Tried using the following code and obtained the error message below. Would greatly appreciate any insight into how to correct code/what I am doing wrong.  variables BMI and age are continuous, gender is binary. Code: proc mcmc data=pdata outpost=pdata seed=1234 nmc=20000; ods select PostSumInt; parms beta0 0 beta1 0 beta2 0 beta3 0 s2 1; prior s2 ~ igamma(0.01, s=0.01); prior beta: ~ general(0); w = beta0 + beta1*bmi + beta2*age + beta3*gender; random delta ~ normal(w, var=100) subject=childid; pi = logistic(delta); model sick ~ binomial(p=pi); run;   ERROR: A hyperparameter of the random effect delta changed value in observation 2. The hyperparameter is a function of the data set variable bmi, which must remain constant within subjects. ... View more

hello, I want to find the first record: the value is 1 and  lasted 24 hours, like my picture： in obs 1,the value is 1 and the record after 24h is obs  4，but between these two records is a record with AVALCN=0,so  obs 1  is N; in obs 2 ,the value is 1 and the record after 24h is obs  5，but between these two records is a record with AVALCN=0,so  obs 2  is N; in obs 3,AVALCN=0 ,,so  obs 2  is N; in obs 4,,the value is 1 and the record after 24h is obs  6，the value between these two records is 1 ,so  obs 4  is Y; in obs 5,the value is 1 ，no records were obtained after 24h,so  obs 5  is N; ... View more

proc export data=sashelp.class outfile="TEST1" dbms = xlsx replace; run; proc export data=sashelp.class outfile="TEST1" dbms=xlsx replace; run; I'm trying to append an existing file using Proc export, but it didn't work. i want this ouput   ... View more

Hi All One of our teams is working on data that must be used in marketing campaigns using SAS CI Studio. The output they produce is stored in parquet files. I need to import that data into SAS using SAS 9.4. Based on my research, it looks like we will need SAS/ACCESS interface to ODBC. I would just like to confirm that this is the only way before I request that (cost implication).   Many thanks! ... View more