topic Import Excel file with missing values in SAS Procedures

Import Excel file with missing values

Lijuu — Sun, 22 Apr 2018 15:03:06 GMT

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!

Re: lijuu

art297 — Sat, 21 Apr 2018 18:37:36 GMT

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

Art, CEO, AnalystFinder.com

Re: lijuu

SuryaKiran — Sat, 21 Apr 2018 20:10:09 GMT

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

Re: lijuu

Lijuu — Sat, 21 Apr 2018 23:30:26 GMT

Thank you in advance!