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 ;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.