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

csullivan27 — Wed, 26 Oct 2016 02:42:42 GMT

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.

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

Reeza — Wed, 26 Oct 2016 03:05:30 GMT

Your file is called MyExcel

In your PROC you refer to data=variation_study

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

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

csullivan27 — Wed, 26 Oct 2016 03:29:00 GMT

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

topic Re: Why can't SAS find my variables in a successfully imported data set? in SAS Studio

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

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

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