DATA Step, Macro, Functions and more

Input Statements

Reply
SAS Employee
Posts: 18

Input Statements

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?
Respected Advisor
Posts: 3,799

Re: Input Statements

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

input state $ 2-2;
Ask a Question
Discussion stats
  • 1 reply
  • 110 views
  • 0 likes
  • 2 in conversation