07-07-2011 04:17 PM
We are reading in 100's of MS Access tables into SAS Datasets along with reading in daily flat files into SAS Datasets.
Since the sources of the data are different (MS Access and Flat Files) one of our fields 'Smokes' gets out of whack with 1,0 and .
Is there a way to define a default value for the Infile code below.
Smokes is a Y/N or Missing values.
@ 56 Smokes 1.
Is there something like, to take a . and default it to 1
@ 56 Smokes 1. Default 1;
I know I can do it with code after the final ;
If Smokes . then Smokes = 1;
Just wondering if there is an option right at the variable when I read it in?
07-07-2011 04:34 PM
A user written INFORMAT should do nicely.
input smokes smokes1. @1 orig $char8.;