Input Statements

[huikeng_sas]

Hi,

I ran the following program, which has a missing period (.) at the last informat for State:

data work.a;
infile 'test.txt';
input @2 populateion comma9.
@12 Rank 1.
@14 CITY $12.
@27 STATE $2 ;

run;

The program ran and the result is as follow:

Obs populateion Rank CITY STATE

1 8143197 1 New York 8
2 3844829 2 Los Angeles 3
3 2842518 3 Chicago 2

May I know how did SAS derive the values 8, 3, 2 for the colum state?

[data_null__]

The missing . on the FORMAT turn it the input to "column input" as if you said.

input state $ 2-2;