SAS Infile Default

JaySwan — Thu, 07 Jul 2011 20:17:48 GMT

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__ — Thu, 07 Jul 2011 20:34:14 GMT

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;

;;;;

run;

proc print;

run;

topic SAS Infile Default in SAS Procedures