Importing a space delimited .txt file

[acros]

Hi,

I have a text file that looks like this:

State,State ANSI,County ANSI,County Name,ANSI Cl

AL,01,001,Autauga County,H1

AL,01,003,Baldwin County,H1

AL,01,005,Barbour County,H1

AL,01,007,Bibb County,H1

AL,01,009,Blount County,H1

AL,01,011,Bullock County,H1

The file is also attached.

How can I get this into SAS? I tried a few ways but I couldn't get it to have a data set with 5 columns with the corresponding headings.

Amanda

[art297 · Accepted solution]

It actually appears to be a comma delimited file.  Couldn't you just use something like:

data want;

  infile "c:\art\names.txt" dlm="," dsd firstobs=2;

  length State State_ANSI ANSI_Cl $2;

  length County_ANSI $3;

  length County_Name $50;

  input State State_ANSI County_ANSI County_Name ANSI_Cl;

run;

[acros]

Sorry, yes, comma delimited. Thanks so much! The code worked perfect.