Hello, I am very new to SAS and would appreciate some help in running a mixed model. I am familiar with SPSS and R however, I would like to learn the SAS programming language. I have managed to import my xlsx file using the snippets feature and the log tells me that the WORK.MYEXCEL data set was successfully created. However, when I begin the run the next few lines of my code (which look like this...)
proc mixed DATA=Variation_study;
class PlayerID TeamID SeasonID;
model DepVar = PositionID WinLoss;
random = SeasonID/ subject = PlayerID;
random = SeasonID/ subject = TeamID;
run;
I get the following errors...
ERROR: Variable PLAYERID not found.
Given the data set was successfully imported, i'm unsure of how SAS can't find these variables? Are the names invalid?
Thankyou in advance.
Your file is called MyExcel
In your PROC you refer to data=variation_study
That doesn't quite align. They should be the same.
Your file is called MyExcel
In your PROC you refer to data=variation_study
That doesn't quite align. They should be the same.
Thank you very much. I knew it would be an easy fix!
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.
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.