Have:
1.01E+03 |
1.01E+03 |
1.01E+03 |
1.02E+03 |
1.02E+03 |
want:
1001
1001
1001
1002
1002
but the values are imported as
1000
1000
1000
1000
1000
Any help to import these values correctly from txt file into SAS?
Thanks
data t;
input k;
datalines;
1.01E+03
1.01E+03
1.01E+03
1.02E+03
1.02E+03
;;
Value would come as
1010
1010
1010
1020
1020
Try Ew.d informat .
data t;
input k e20.;
datalines;
1.01E+03
1.01E+03
1.01E+03
1.02E+03
1.02E+03
;
run;
proc print;run;
Please tell us how you imported the data into a SAS dataset.
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 how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.