Help using Base SAS procedures

Format decimal

Accepted Solution Solved
Reply
Super Contributor
Posts: 398
Accepted Solution

Format decimal

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


Accepted Solutions
Solution
‎03-18-2015 02:31 PM
Respected Advisor
Posts: 3,777

Re: Format decimal

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

View solution in original post


All Replies
Solution
‎03-18-2015 02:31 PM
Respected Advisor
Posts: 3,777

Re: Format decimal

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

Super Contributor
Posts: 398

Re: Format decimal

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 ;

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 320 views
  • 0 likes
  • 2 in conversation