topic Re: Proc glimmix & where statement in SAS Procedures

Proc glimmix & where statement

janie99 — Thu, 12 Jun 2014 08:34:39 GMT

I have a data set with 7 potential covariates. At the moment I am testing each one individually against the outcome variable. I am using AIC/BIC to see which covariate fits the model best and building from there. The problem that I am having is that most variables have some missing responses. I have created a new variable called notmissing which codes a row as notmissing=0 if all covariates have a value for that row or notmissing=1 for the rows where one or more covariates has a missing value. What I want to do is run the proc glimmix and include a statement that only includes rows where notmissing=0 so that I can use the AIC/BIC.

This is the code I have written:

proc glimmix data=cmr.u5mrfull method=mspl ;

where=(notmissing=0);

class country regionID;

model u5mr = regionID year ltuberprev/ dist=normal link=id dfm=sat;

random intercept year / subject=country type=chol;

run;

I have run it for each variable but the number of observation used is different in each analysis so this makes me think the code hasn't worked properly or there is something wrong with the notmissing variable but I am not sure which one is causing the problem

Re: Proc glimmix & where statement

PaigeMiller — Thu, 12 Jun 2014 14:48:27 GMT

You probably need to show us how your are creating the notmissing variable.

Also, I am not familiar with the syntax for the WHERE statement

where=(notmissing=0);

I always use something like

where notmissing=0;

proc glimmix data=cmr.u5mrfull(where=(notmissing=0)) method=mspl ;

Re: Proc glimmix & where statement

brsinco — Thu, 12 Jun 2014 19:07:04 GMT

Whenever I have used a where statement with SAS procedures, it has always been with syntax like

where notmissing=0;

Try that with Glimmix and let know if it works.

Brandy

Re: Proc glimmix & where statement

janie99 — Thu, 12 Jun 2014 21:57:05 GMT

Thanks guys! There was a problem with the syntax of the where statement. As suggested I fixed it up to be:

where notmissing=0;