BookmarkSubscribeRSS Feed
billi_billi
Calcite | Level 5

I am  new to use and using PROC MIXED using clustered data to answer the question access to medical care is related to the risk. Below is my code in which predictors are different type of risk: income, education and insurance risk (1= risk,0=no risk) and risk_score is the cummulative risk of all the three risks (ranging from 0-6), and outcome here is doctor's office in vicinity (1=yes,0=no) and I am controlling for confounding factors age, race, gender. Observations are clustered so I am using random effect statement. This code is working fine but I also need exponentiated coefficients and 95% CI in my output. Is there any option to get those in the output. 

 

 

proc mixed data= data PLOTS(MAXPOINTS=NONE) method=type3;
class risk_score income_risk educ_risk insurance_risk  medical Race gender ;
model medical = age Race gender ;
random risk_score income_risk educ_risk insurance_risk ;
run;

 

Thank you in advance.

 

4 REPLIES 4
PaigeMiller
Diamond | Level 26

To get confidence intervals of the coefficients

 

model medical = age Race gender / solution cl;

I have never head of getting exponentiated coefficients, and I am not aware of any built in feature in PROC MIXED to do this, but you could certainly store the coefficients in a SAS data set, and then exponentiate them in a DATA step.

--
Paige Miller
billi_billi
Calcite | Level 5

@PaigeMiller do you mind telling how to store coefficients in a SAS data set, and then exponentiate them in a DATA step or if there is any documentation that I can look up to do this?

PaigeMiller
Diamond | Level 26
ods output solutionf=coefficients;

before your PROC MIXED statement creates a SAS data set named COEFFICIENTS which contains ... well ... you know

 

Then you can exponentiate as desired in a SAS data set.

 

data coefficients1;
    set coefficients;
    exponentiated = estimate ** 2; /* for example, if you want them squared */
run;
--
Paige Miller
ed_sas_member
Meteorite | Level 14

Hi @billi_billi 

You can put 

	model medical=age Race gender / cl solution;

SAS Innovate 2025: Call for Content

Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!

Submit your idea!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 4 replies
  • 852 views
  • 1 like
  • 3 in conversation