Help how to Import a Table Txt File with Column Headers

[daft22]

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.

[PGStats · Accepted solution]

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

[daft22]

Thank you so much! I appreciate your help!