Help how to Import a Table Txt File with Column Headers

daft22 — Sun, 24 Feb 2019 04:03:15 GMT

Hello!

I am trying to import a txt file that has a table (delimited by spaces), which also has column headers. The txt file looks as follows:

City State Price
Baltimore MD 10.95
Brooklyn NY 12.99
Buffalo NY 11.50
Harlem NY 12.50
Newark NJ 11.50
Rochester NY 10.95
Stamford CT 11.50
Syracuse NY 10.95
Troy NY 11.50

And my code so far looks like this:

DATA Ribs;
INFILE '/folders/myfolders/sasuser.v94/DinosaurBBQRibs.txt' DLM='';
INPUT City :$9. State :$2. Price :COMMA6.2 @@;
RUN;

My table looks fine, except the first row includes City and State, and a . for price, but I don't want to include them there and I can't seem to get it correct.

Re: Help how to Import a Table Txt File with Column Headers

PGStats — Sun, 24 Feb 2019 04:28:02 GMT

Add firstobs=2 to the infile statement. And remove the @@, that's for creating many obs with each line.

Re: Help how to Import a Table Txt File with Column Headers

daft22 — Sun, 24 Feb 2019 04:31:18 GMT

Thank you so much! I appreciate your help!

topic Re: Help how to Import a Table Txt File with Column Headers in SAS Programming

Help how to Import a Table Txt File with Column Headers

Re: Help how to Import a Table Txt File with Column Headers

Re: Help how to Import a Table Txt File with Column Headers