https://communities.sas.com/t5/SAS-Programming/Correctly-importing-numeric-values-that-have-the-occassional/m-p/71382#M15459 Hi, I'm importing a dataset that has 105,000 rows of data. The one column, we'll call 'X', has about 90,000 observations of numeric values and 15,000 rows of character values. If i tell it to import it as a number I get a ton of errors. The dataset I get is fine because it's them in as a missing values, I can drop them and go on with my analysis. Is there a way I can get rid of these error messages and still keep X as a numeric? Fri, 26 Mar 2010 14:33:15 GMT deleted_user 2010-03-26T14:33:15Z https://communities.sas.com/t5/SAS-Programming/Correctly-importing-numeric-values-that-have-the-occassional/m-p/71382#M15459 Hi, I'm importing a dataset that has 105,000 rows of data. The one column, we'll call 'X', has about 90,000 observations of numeric values and 15,000 rows of character values. If i tell it to import it as a number I get a ton of errors. The dataset I get is fine because it's them in as a missing values, I can drop them and go on with my analysis. Is there a way I can get rid of these error messages and still keep X as a numeric? Fri, 26 Mar 2010 14:33:15 GMT https://communities.sas.com/t5/SAS-Programming/Correctly-importing-numeric-values-that-have-the-occassional/m-p/71382#M15459 deleted_user 2010-03-26T14:33:15Z https://communities.sas.com/t5/SAS-Programming/Correctly-importing-numeric-values-that-have-the-occassional/m-p/71383#M15460 If you are not able to code the INPUT statement yourself (where you can introduce ?? ahead of the specified INFORMAT), consider investigating the use of the ERRORS= system option for handling this condition.<BR /> <BR /> Scott Barry<BR /> SBBWorks, Inc.<BR /> <BR /> SAS Language Reference: Concepts, Error Processing in SAS<BR /> <A href="http://support.sas.com/documentation/cdl/en/lrcon/61722/HTML/default/a000993436.htm" target="_blank">http://support.sas.com/documentation/cdl/en/lrcon/61722/HTML/default/a000993436.htm</A> Fri, 26 Mar 2010 14:43:47 GMT https://communities.sas.com/t5/SAS-Programming/Correctly-importing-numeric-values-that-have-the-occassional/m-p/71383#M15460 sbb 2010-03-26T14:43:47Z