topic Format decimal in SAS Procedures

Format decimal

jerry898969 — Wed, 18 Mar 2015 18:25:16 GMT

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__ — Wed, 18 Mar 2015 18:31:57 GMT

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

jerry898969 — Wed, 18 Mar 2015 19:01:48 GMT

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 ;