Hello, All,
I have monthly claims data with 27% having zero value, and some monthly values exceeding $1M. Members can have 12 months of data. As a repeated measure, I'm using GLIMMIX to predict the monthly value where, in a data step to prepare the data, I'm using the statement:
if COST = 0 then dist = "POISSON"; else dist = "GAMMA";
This simulates a Tweedie distribution.
Then in the model, I have:
proc glimmix data = DSN method = quad;
class month dist plan;
model COST = month plan / solution DIST=byobs(dist) ;
random intercept / subject = member TYPE = Toeplitz ;
estimate "Plan vs No Plan" intercept 1 plan 0 1 / E ilink;
estimate "Month 1: Plan vs no plan" intercept 1 month 1 0 0 0 0 0 0 0 0 0 0 0 0 0 plan 0 1 / E ilink;
run; title1;
E and ILINK provides me with a mean estimate but it is not in scale of the COST. What is the back transformation from the estimated mean to recover the actual cost?
Thanks.
Try not use ilink. estimate "Plan vs No Plan" intercept 1 plan 0 1 ; or try lsmeans lsmeans plan/ilink diff exp cl;
I switched EXP for EST in the LSMEANS statement and it worked. Thanks for the tip.
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
ANOVA, or Analysis Of Variance, is used to compare the averages or means of two or more populations to better understand how they differ. Watch this tutorial for more.
Find more tutorials on the SAS Users YouTube channel.