read txt file with appropriate format to variables

[KyuL]

Hi,

Attached is the "president.txt" file.

I need to assign appropriate format to DOB (5th column), votes (7th column), and PercVote (8th column).

Here is my code. 

Could anyone help me to correct the code? Thanks a lot. 

filename TXTfile '/folders/myfolders/Assignment 2/President.txt';

data President;
     infile TXTfile missover;
     input FullName & $22.
     
     
           City $19.
           State $20. 
           ASP 2.
           DOB mmddyy10.
           Term 4.
           Votes comma10. 
           PercVote percent10.;
     format DOB mmddyy10. Votes comma10. PercVote percent10.;
run;

proc print data = President;

run;

[Kurt_Bremser · Accepted solution]

I copied your file to my UE, and ran this code with success:

data test;
infile '/folders/myfolders/President.txt' expandtabs lrecl=300 truncover;
input
  @1 FullName $22.    
  @25 City $19.
  @49 State & $20. 
  ASP :2.
  DOB :mmddyy10.
  Term :4.
  Votes :comma10. 
  PercVote :percent10.
;
format DOB mmddyy10. Votes comma10. PercVote percent10.;
run;

[KyuL]

I ran successfully too. Thanks a lot.

[Kurt_Bremser]

Please feel free to ask about details if something is unclear.