topic read txt file with appropriate format to variables in SAS Programming

read txt file with appropriate format to variables

KyuL — Thu, 22 Oct 2020 07:24:49 GMT

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;

Re: read txt file with appropriate format to variables

Kurt_Bremser — Thu, 22 Oct 2020 09:20:25 GMT

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;

Re: read txt file with appropriate format to variables

KyuL — Thu, 22 Oct 2020 09:35:55 GMT

I ran successfully too. Thanks a lot.

Re: read txt file with appropriate format to variables

Kurt_Bremser — Thu, 22 Oct 2020 09:47:58 GMT

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