Import Excel file with missing values

[Lijuu]

How to import excel file with missing value into sas.

The format for the missing value is looks like: 

Id  X  Y     Z

1   .   5      .

2  .    3      . 

3  .    1      .

4  a   2     3

5  b   7    4

Thank you!                                 

[art297]

The following works for me. All missing values come in as missing.

Art, CEO, AnalystFinder.com

[SuryaKiran · Accepted solution]

Missing characters in SAS are represented by blanks and missing numeric values are represented by a period ( . ) In the data you showed you have period as missing character. Make sure to change those values into blank after reading data into SAS using Proc Import because period for character is not treated as missing.

Convert characters into missing as  follows:

data want ;
set test;
array change_Char _Character_;
do over change_Char ;
if strip(change_Char)="." then change_Char=" ";
end;
run;

Also some numeric variables can be imported as character, using INPUT() you can convert them to numeric

[Lijuu]

Thank you in advance!