Hello,
I have data with many missing observations in an excel file. Missing cells have a period ".".
When using proc import, the "." is recognized as a level in subsequent analysis.
However, when I paste the data directly in SAS, the "." is correctly identified as missing value.
This affects the analysis and results.
Can anyone suggest how to appropriately import data from excel and correctly identify "." as missing observations?
Thanks
I have data with many missing observations in an excel file. Missing cells have a period ".".
When using proc import, the "." is recognized as a level in subsequent analysis.
However, when I paste the data directly in SAS, the "." is correctly identified as missing value.
This affects the analysis and results.
Can anyone suggest how to appropriately import data from excel and correctly identify "." as missing observations?
Thanks