Hello, I would like to ask you a question about missing values. Before i ask a question i want to tell a story. Assume, i have two variables in sas, one numeric and character and in every one i have missing values, i.e in numeric variable the missing value will mark as . ,and in character masr as " ". Now export my data set to sql database. When i will open my table in sql, i will see my missing values, as NULL, and it is no difference between numeric or character. In the both of them i will see NULL instead of missing values. 1. First Question : i am right about the symbol of missing value in sql i.e i will see NULL in both of them? Now i want to export table from sql to two sources : one is sas and the second is csv file. When i import to sas with proc import from sql, sas know recognize missing value in numeric(.) and missing value in character(" "). 2. Second Question : Sas know to read metadata of table in sql, he knows to read types of variables from specific table in sql? When i import to csv file or other formats, i see word NULL in every missing values, and when i read this csv file to sas with proc import, sas cannot recognize numeric variable vs chatacter variables. For example, if in the first 10 rows, there are numbers, then Sas state that it is numeric variables, the problem that in row 150 you have value "NULL" and then you got an error. 3.Third Question : How can i read csv(or other format) file in sas with proc import? how can i decide the problem of missing values? Maybe there are a smart decision? Thank you a lot
... View more
