topic Re: column and formatted inputs in New SAS User

column and formatted inputs

anming — Sun, 06 Dec 2020 17:05:59 GMT

Column and formatted inputs to load a file are similar but different.

When you load the following datasheet test.txt,

Name Sex DOB Weight

12345678901234567890

John M08/10/202060

For column input

Data test.col;

infile "path/test.txt";

input

name $1-5

sex $6

DOB $7-16

Weight 17-18;

run;

you will get DOB in character. You can use input to convert the character to numeric of DOB before the calculation with DOB.

But if you use formatted input:

Data test.col;

infile "path/test.txt";

input

@1 name $5.

@6 sex $1.

@7 DOB mmddyy10.

@17 Weight 2.;

run;

you will get the numeric DOB.

Re: column and formatted inputs

Tom — Sun, 06 Dec 2020 17:17:59 GMT

You cannot use any special informats when using column ranges. But you can mix formatted input and column ranges in the same INPUT statement.

input
  name $1-5
  sex $6
  @7 DOB mmddyy10.
  Weight 17-18
;

Re: column and formatted inputs

Cynthia_sas — Sun, 06 Dec 2020 18:30:44 GMT

Hi:
Go to the documentation and read about the differences between column input and formatted input. With column input you can ONLY read character or numeric data in standard format. Your date is NOT in a standard format (has slashes), so it CANNOT be read except as a character string in the first program. That is the "side effect" of using column input. Either list input or formatted input, as you show could read the data with an informat. LISTING input won't work in this case because it looks like your data is not separated by a delimiter. So your only choice IF you want to read DOB as numeric is formatted input. If you look in the documentation on COLUMN input: https://go.documentation.sas.com/?cdcId=pgmsascdc&cdcVersion=9.4_3.5&docsetId=lestmtsref&docsetTarget=n0lrz3gb7m9e4rn137op544ddg0v.htm&locale=en you'll see that it specifically tell you that you can ONLY read standard numeric form with COLUMN based input.
Cynthia