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!
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.