Help using Base SAS procedures

Error Variable not found

Reply
New Contributor
Posts: 3

Error Variable not found

The variables I have are Community, CommunityName, BirthRate, BelowPovLev, Crowded, Dependency, NoHSDiploma, Income, and Unemployment.

 

I have imported the CSV file, and with Proc Print, every variable shows up in the table. When I try to do any other procedure like sgscatter or corr, the variable Unemployment is not found. There are no spelling errors as I have copied and pasted the word from the Excel file. 

 

56 Proc sgscatter Data=Teen;
57 MATRIX Community BirthRate BelowPovLev Crowded Dependency NoHSDiploma Income
58 Unemployment;
ERROR: Variable UNEMPLOYMENT not found.
59 Run;
 
What am I doing wrong?
Community Manager
Posts: 2,955

Re: Error Variable not found

Best guess is that there is a subtle difference in the name that you're not noticing.  Try running 

 

 

proc contents data=teen; run;

 

 

and see what the output shows for the variable names.

New Contributor
Posts: 3

Re: Error Variable not found

Posted in reply to ChrisHemedinger

Is this what you're referring to? If so, what do I get from this table?


Screen Shot 2016-10-03 at 7.44.23 PM.png
Community Manager
Posts: 2,955

Re: Error Variable not found

Unemployment is a character variable, and I think it needs to be a numeric to be part of the MATRIX statement.  That's a misleading error message if that's the case, I'll admit.

 

If Unemployment is supposed be numeric, check your import step to ensure that variable is defined properly and read with a numeric informat.

New Contributor
Posts: 3

Re: Error Variable not found

Posted in reply to ChrisHemedinger

Okay. In the actual Excel file, everything under Unemployment is numeric. How would I get SAS to read it as numeric? I haven't worked much with Proc Import, sorry.

Super User
Posts: 19,851

Re: Error Variable not found

When you import your CSV file check your log. The code will be in the log. Copy this code and customize as required by changing the informats/formats. 

Super User
Super User
Posts: 7,977

Re: Error Variable not found

If it is a CSV file, then write a datastep to read in the file exactly as you know the data to be.  Don't rely on proc import to guess things for you.

Super User
Posts: 11,343

Re: Error Variable not found

Open the CSV file with something like NOTEPAD or WORDPAD, not Excel, and see if there are any quotes around the values you think should be numeric. Of if the first few rows of data are missing for the variable then Import may assume they are character if the Guessingrows wasn't set high enough (defaults to 20 I believe).

Ask a Question
Discussion stats
  • 7 replies
  • 409 views
  • 0 likes
  • 5 in conversation