import numeric values with E

[ari]

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

[RahulG]

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

[ari]

but the values are imported as

1000
1000
1000
1000
1000

from the text file

[Ksharp]

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;

[ari]

This works. Thanks Xia

[PGStats]

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