Write and run SAS programs in your web browser

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

Accepted Solution Solved
Reply
New Contributor
Posts: 4
Accepted Solution

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

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.


Accepted Solutions
Solution
‎10-25-2016 11:27 PM
Grand Advisor
Posts: 17,313

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

Your file is called MyExcel

 

In your PROC you refer to data=variation_study

 

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

View solution in original post


All Replies
Solution
‎10-25-2016 11:27 PM
Grand Advisor
Posts: 17,313

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

Your file is called MyExcel

 

In your PROC you refer to data=variation_study

 

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

New Contributor
Posts: 4

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

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

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 184 views
  • 0 likes
  • 2 in conversation