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
You need and INFORMAT so that you can read it with implied decimal place. Or you can use INPUT VAL 1-6 2;
You need and INFORMAT so that you can read it with implied decimal place. Or you can use INPUT VAL 1-6 2;
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 ;
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.