Help using Base SAS procedures

SAS Infile Default

Reply
Contributor
Posts: 24

SAS Infile Default

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

Respected Advisor
Posts: 3,777

SAS Infile Default

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;

Ask a Question
Discussion stats
  • 1 reply
  • 99 views
  • 0 likes
  • 2 in conversation