06-13-2015 10:52 PM
I don't understand why SAS road variable in list does not match type prescribeb for this list.
It's all numeric data, but when i look in the librairy some data are in alphanum.. how can i change this ?
In SAS, my data rc1 isnumeric, but not my other data like bg1
Is't because i have 0 and . in my folder ?
THanks and sorry for my english
06-14-2015 01:37 PM
How did you make the data set?
SAS is not going to convert the types of your variables, it will just do what you ask. Now if you tried to use PROC IMPORT to have SAS guess about what type of data you have in a CSV or EXCEL file then you might end up with some variables being defined as character. It is better to write your own program to read the data and then you have control over how the variables are defined.
06-14-2015 08:42 PM
My data are all numeric (see my data in excel on the bottom), but when I put it in SAS university, SAS read the data bq1 bq2 bq3 bgm1 bgm2 bgm3 as alphanum. Why ?
06-14-2015 11:07 PM
Your numbers are left aligned, typically numbers are right aligned. I'm guessing that Excel has the cells formatted as text and SAS is assuming those formats. Try right aligning number and setting to numbers in Excel before import and see if that helps the import.
06-14-2015 05:02 PM
in your first image Obs 13 has a period "." or rather a "Missing" value. check to see what value is in the input file. You may have an "O" (letter O) not a "0" number zero.
William E Benjamin Jr