Error Variable not found

[md11r0]

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?

[ChrisHemedinger]

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.

[md11r0]

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

[ChrisHemedinger]

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.

[md11r0]

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.

[Reeza]

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. 

[RW9]

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.

[ballardw]

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).