SAS Infile Default

[JaySwan]

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.

Example:

@ 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?

TIA

Jay

[data_null__]

A user written INFORMAT should do nicely.

proc format;

   invalue smokes(just)

      0=0

      1,.=1

      other=_error_;

   run;

data test;

   input smokes smokes1. @1 orig $char8.;

   cards;

.

1

.

2

0

1

;;;;

   run;

proc print;

   run;