Format decimal

[jerry898969]

Hello,

I'm importing a text file that has data that comes in as 020100 but I need to format it as 201.00. 

So I need it to be a number and then have the 2 decimals.

When I try and format the value to F7.2 it shows up 20100.0 and F8.2 shows up as 20100.00.

filename temp "C:\temp\test.txt" ;

data temp ;    
    ATTRIB 
        VAL  FORMAT=F8.2
;
infile temp ;
input
VAL 1-6
;
run ;

Thank you

[data_null__ · Accepted solution]

You need and INFORMAT so that you can read it with implied decimal place.  Or you can use INPUT VAL 1-6 2;

[jerry898969]

Hi data_null_;

Thank you so much.  I did this and it seems to work correctly.

filename temp "C:\temp\test.txt" ;

data temp ;   

    ATTRIB

        VAL  FORMAT=F7.2

;

infile temp ;

input

VAL 1-6 2

;

run ;