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
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;
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;
Sorry, yes, comma delimited. Thanks so much! The code worked perfect.
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.