Tips:Using ?? in the INPUT Statement

From sasCommunity
Jump to: navigation, search

When reading numeric data that may contain invalid values, the (??) can be used to not only suppress the error messages in the LOG, but to also reset the _ERROR_ variable to zero. When there are lots of invalid values, this allows the data set to still be created without producing lots of error messages in the log.

 data base;
 input age ?? name $;
 datalines;
 15   Fred
 14   Sally
 x    John
 run;


Submitted by Art Carpenter. Contact me at my Discussion Page.