topic Re: Importing a space delimited .txt file in SAS Procedures

Importing a space delimited .txt file

acros — Wed, 04 Dec 2013 22:20:38 GMT

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 — Wed, 04 Dec 2013 22:39:21 GMT

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 — Wed, 04 Dec 2013 23:16:53 GMT

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