Reading in data file

[Steelersgirl]

I am having trouble reading in a data file from http://people.stat.sc.edu/Hitchcock/beatles_songlengths.txt. The first variable is the album name and the rest of the variable are the song lengths for the 14 songs in the album. First the minute variable, then the seconds variable. Two of the albums only have 13 songs and the missing variable is replaced by '.'. This is the code I tried to read in the data, but it is not creating the correct table. 

DATA songs;
FILENAME webpage URL 'http://people.stat.sc.edu/Hitchcock/beatles_songlengths.txt';
INFILE webpage MISSOVER DLM=' ';
 INPUT album_name $ min1 sec1 min2 sec2 min3 sec3 min4 sec4 min5 sec5 min6 sec6 min7 sec7 min8 sec8 min9 sec9 min10 sec10 min11 sec11 min12 sec12 min13 sec13 min14 sec14;
 RUN;
  
  
PROC PRINT DATA=songs;
RUN;

[novinosrin · Accepted solution]

DATA songs;
FILENAME webpage URL 'http://people.stat.sc.edu/Hitchcock/beatles_songlengths.txt';
INFILE webpage ;
 INPUT album_name  $ 1-38 min1 sec1 min2 sec2 min3 sec3 min4 sec4 min5 sec5 min6 sec6 min7 sec7 min8 sec8 min9 sec9 min10 sec10 min11 sec11 min12 sec12 min13 sec13 min14 sec14;
 RUN;

[ballardw]

---

@Steelersgirl wrote:

I am having trouble reading in a data file from http://people.stat.sc.edu/Hitchcock/beatles_songlengths.txt. The first variable is the album name and the rest of the variable are the song lengths for the 14 songs in the album. First the minute variable, then the seconds variable. Two of the albums only have 13 songs and the missing variable is replaced by '.'. This is the code I tried to read in the data, but it is not creating the correct table. 

DATA songs;
FILENAME webpage URL 'http://people.stat.sc.edu/Hitchcock/beatles_songlengths.txt';
INFILE webpage MISSOVER DLM=' ';
 INPUT album_name $ min1 sec1 min2 sec2 min3 sec3 min4 sec4 min5 sec5 min6 sec6 min7 sec7 min8 sec8 min9 sec9 min10 sec10 min11 sec11 min12 sec12 min13 sec13 min14 sec14;
 RUN;
  
  
PROC PRINT DATA=songs;
RUN;

---

If you do not define a length for a character variable or tell how wide the field may be then the result will default to 8 characters.

You really should describe the actual symptom(s) not a vague statement like " but it is not creating the correct table".