I am receiving the following error in the log after submitting this PROC GLM code.
proc glm data=dsn; by segment; class trim model category subsegment; model price = trim model age category subsegment; quit;
The error is:
"One or more variables are missing or freq or weight is zero on every observation."
I know the error is coming from the subsegment variable because I added the variables one at a time before getting an error with subsegment.
I'm not sure how to diagnose the source of the error. Subsegment does have a 2% missing rate, but not all values are missing. Besides, I thought PROC GLM would simply exclude observations with missing input values.
Can anyone provide help on the source of this error?
Thank you.
Dhrumil Patel
GLM does separate analysis for every BY-value. Check that subsegment is not entirely missing for one of the segments.
Post your log and look at output from proc freq on variable. My guess is you misspelled the variable name?
Thanks for your reply.
I checked it wasn't from misspelling the variable name. It was because of my BY statement. There were combinations of segment and subsegment where the values were completely missing.
Dhrumil
GLM does separate analysis for every BY-value. Check that subsegment is not entirely missing for one of the segments.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.