* Read in the sas_foot_delim data set;
* with commas as delimiters;

data footdlm;

*infile 'z:\My Documents\teaching\stat_517\sas_foot_delim.txt' firstobs=2 DLM=',' missover;
FILENAME webpage URL 'http://people.stat.sc.edu/hitchcock/sas_foot_delim.txt';
INFILE webpage firstobs=2 DLM=',' missover;
INPUT Date MMDDYY10. VisitingTeam :$20. VisitingScore HomeTeam :$16. HomeScore Line;
RUN;

PROC PRINT DATA = footdlm;
title 'Football Scores';
RUN;

** What about if two commas indicate a missing value?  (Buffalo, Oregon scores)
** Or if a data values _contains_ a comma? i.e., "Miami, Ohio"  ;

data footcsv;

*infile 'z:\My Documents\teaching\stat_517\sas_foot_delim.csv' firstobs=2 DSD missover;
FILENAME webpage URL 'http://people.stat.sc.edu/hitchcock/sas_foot_delim.csv';
INFILE webpage  firstobs=2 DSD missover;
INPUT Date :MMDDYY10. VisitingTeam :$20. VisitingScore HomeTeam :$16. HomeScore Line;
RUN;

PROC PRINT DATA = footcsv;
title 'Football Scores';
RUN;