topic Re: Changing ? to missing in all variables (character and numeric) in SAS Enterprise Guide

Changing ? to missing in all variables (character and numeric)

milad — Sun, 15 Mar 2015 01:27:50 GMT

I am importing some CSV sheets with 60+ variables and the author used ? for missing values so they are imported as ?. How can I simply set all ?s to missing without having to write 60 if-thens?

Re: Changing ? to missing in all variables (character and numeric)

slchen — Sun, 15 Mar 2015 01:51:10 GMT

Something like this.

data want;

set have;

array num_vars _numeric_;

array char_vars _character_;

do over num_vars;

if num_vars=? then call missing(num_vars);

end;

do over char_vars;

if char_vars='?' then call missing(char_vars);

end;

run;

Re: Changing ? to missing in all variables (character and numeric)

milad — Sun, 15 Mar 2015 02:09:33 GMT

Thanks. That works. The only problem is that num vars are assumed to be character var during import because of instances of ? in them.

Any thoughts how to turn them back to num var after correction?