BookmarkSubscribeRSS Feed
bee2
Calcite | Level 5

Hi,

 

I am running gee for longitudinal analysis and am encountering a prob:

 

ERROR: No valid observations due to invalid or missing values in the response, explanatory, offset, frequency, or weight variable.

 

The code i am running is :

Proc genmod data=dietdiv2 ;
class hhid  peduc(ref='1');
Model stuntingall3= peduc/type3 dist=poisson link=log;
repeated subject=hhid/type=ind;
estimate 'peducn' peduc 1 -1 1/exp;
run;

 

The exposure (peduc) is measured at visit 1 (baseline) and the outcome(stuntingall) at visit 3:

SAS Output

stuntingall3 Frequency Percent CumulativeFrequency CumulativePercent01Frequency Missing = 19042
290771.62290771.62
115228.384059100.00

peduc Frequency Percent CumulativeFrequency CumulativePercent12Frequency Missing = 18150
238348.13238348.13
256851.874951100.00

Any thoughts on how i can address the errors?

 

Thanks.

3 REPLIES 3
Reeza
Super User

That’s a lot of missing. Is that what you expect?

 


@bee2 wrote:

Hi,

 

I am running gee for longitudinal analysis and am encountering a prob:

 

ERROR: No valid observations due to invalid or missing values in the response, explanatory, offset, frequency, or weight variable.

 

The code i am running is :

Proc genmod data=dietdiv2 ;
class hhid  peduc(ref='1');
Model stuntingall3= peduc/type3 dist=poisson link=log;
repeated subject=hhid/type=ind;
estimate 'peducn' peduc 1 -1 1/exp;
run;

 

The exposure (peduc) is measured at visit 1 (baseline) and the outcome(stuntingall) at visit 3:

SAS Output

stuntingall3 Frequency Percent CumulativeFrequency CumulativePercent01Frequency Missing = 19042
2907 71.62 2907 71.62
1152 28.38 4059 100.00

peduc Frequency Percent CumulativeFrequency CumulativePercent12Frequency Missing = 18150
2383 48.13 2383 48.13
2568 51.87 4951 100.00

Any thoughts on how i can address the errors?

 

Thanks.


 

bee2
Calcite | Level 5
Hi,
I expect to have a lot of missings given that i have 7 follow-up points and the exposure is measured at timepoint 1(baseline) and the outcome at timepoint 3. The responses for both the exposure and outcome are missing at the other time points. Hope that clarifies.
sld
Rhodochrosite | Level 12 sld
Rhodochrosite | Level 12

Does that mean that you have only two values for each HHID, namely stuntingall3 and peduc? If so and if you are using stuntingall3 as the response and peduc as a predictor, then you do not have a data structure with repeated measures and the REPEATED statement is not necessary and would generate errors.

 

Looking ahead, if peduc has only two levels, then the ESTIMATE statement is not correct because it specifies 3 parameters.

 

Ready to join fellow brilliant minds for the SAS Hackathon?

Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.

Register today!
What is ANOVA?

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.

Discussion stats
  • 3 replies
  • 2017 views
  • 0 likes
  • 3 in conversation