topic Re: import numeric values with E in SAS Programming

import numeric values with E

ari — Tue, 19 Jul 2016 09:30:03 GMT

Have:

1.01E+03

1.02E+03

want:

1001

1002

but the values are imported as

1000

Any help to import these values correctly from txt file into SAS?

Thanks

RahulG — Tue, 19 Jul 2016 09:13:00 GMT

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

1020

ari — Tue, 19 Jul 2016 09:30:43 GMT

but the values are imported as

1000
1000
1000
1000
1000

from the text file

Ksharp — Tue, 19 Jul 2016 09:34:54 GMT

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;

PGStats — Tue, 19 Jul 2016 15:54:04 GMT

Please tell us how you imported the data into a SAS dataset.

ari — Thu, 21 Jul 2016 09:55:17 GMT

This works. Thanks Xia