Hi there, I need help in inputting the following data intoSAS. -----------------

Question

 05/07/2008
Cincinnati    5       Chicago      2
New York      0       Atlanta      3
05/08/2008
Cincinnati    1       Chicago      3
New York      6       Atlanta      2
San Diego    10       Los Angeles  8
05/09/2008
Chicago      13       Cincinnati   2
--------------------------
And this is what I tried;
-------------------

data qn1;
infile 'C:UsersSSSDesktopdata3.txt';
input @1 date mmddyy8. @; retain date;
input @3 H_team $ 3-14 @16  H_score @25 V_team $ 25-35 @38 V_score;

proc print data=qn1;format date mmddyy10.; run;
------------------------

I appreciate your help and will rate nicely.

Thank you,

Explanation / Answer

data qn1;

Input date anydtdte15.
H_team $ 1-13   H_score 14-15 V_team $23-35 V_score 36-37 ;
output;
  
datalines;
05/07/2008
Cincinnati    5      Chicago      2
New York     0      Atlanta      3
05/08/2008
Cincinnati    1      Chicago      3
New York     6      Atlanta      2
San Diego    10      Los Angeles 8
05/09/2008
Chicago     13       Cincinnati  2

;
run;

proc print data=qn1 ;format date mmddyy10.;run;

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.