10-03-2016 07:28 PM
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.
10-03-2016 07:40 PM
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.
10-03-2016 07:49 PM
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.
10-03-2016 07:54 PM
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.
10-03-2016 11:30 PM
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.
10-04-2016 04:32 AM
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.
10-04-2016 10:41 AM
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).