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!
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
The following works for me. All missing values come in as missing.
Art, CEO, AnalystFinder.com
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
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.