BookmarkSubscribeRSS Feed
xtc283x
Quartz | Level 8

My dependent variable contains positive integers truncated at 1. It is also quite skewed. The n is small with 48 observations. My first try was a multiplicative (log-log) model. Thinking I could improve on the Mean Squared Error, I tried quantile regression at the 25th percentile. This had the positive effect of reducing the MSE by 33% versus the OLS multiplicate model, but had the undesireable result of producing some negative predictions. So, I tried Proc QLIM specifying a truncated lower bound equal to 1, thinking that any predictions from this procedure would be constrained at the lower bound. 

 

I was wrong. Proc QLIM produces negative predictions in spite of a lower bound at 1. This result is unexpected and surprising. The documentation doesn't address the issue. 

 

What am I missing here? 

2 REPLIES 2
PGStats
Opal | Level 21

Have you tried Poisson and negaiive binomial counts models (available with many procedures, such as COUNTREG)?

PG
xtc283x
Quartz | Level 8

I have not tried those but they are good suggestions which I will pursue. Regardless, I'm still curious about why QLIM is giving me negative predictions. Any insights?

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
  • 2 replies
  • 1337 views
  • 0 likes
  • 2 in conversation