Column and formatted inputs to load a file are similar but different.
When you load the following datasheet test.txt,
Name Sex DOB Weight
12345678901234567890
John M08/10/202060
For column input
Data test.col;
infile "path/test.txt";
input
name $1-5
sex $6
DOB $7-16
Weight 17-18;
run;
you will get DOB in character. You can use input to convert the character to numeric of DOB before the calculation with DOB.
But if you use formatted input:
Data test.col;
infile "path/test.txt";
input
@1 name $5.
@6 sex $1.
@7 DOB mmddyy10.
@17 Weight 2.;
run;
you will get the numeric DOB.