Why can't SAS find my variables in a successfully imported data set?

[csullivan27]

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.

ERROR: Variable TEAMID not found.

ERROR: Variable SEASONID 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.

[Reeza · Accepted solution]

Your file is called MyExcel

In your PROC you refer to data=variation_study

That doesn't quite align. They should be the same. 

[csullivan27]

Thank you very much. I knew it would be an easy fix!