Hi, Attached is the "president.txt" file. The question asked me to use substr() function to create a new character variables to hold the day, month, and year from variable DOBC. I tried the function but it didn't work. Could anyone help me to correct the code? Thanks a lot. filename TXTfile '/folders/myfolders/Assignment 2/President.txt';
data President;
infile TXTfile expandtabs lrecl=300 truncover;
input @1 FullName $22.
@25 City $19.
@49 State & $20.
ASP :2.
DOB :mmddyy10.
Term :4.
Votes :comma10.
PercVote :percent10.2
;
DOBC = DOB;
DOBC2 = DOB;
format DOB mmddyy10. Votes comma10. PercVote percent10.2
DOBC date9. DOBC2 ddmmyy10.;
run;
data test;
set President;
length day $2 mon $3 year $4;
day = substr(DOBC,1,2);
mon = substr(DOBC,3,3);
year = substr(DOBC,6);
run;
... View more