topic To convert 13 digit into string. in Programming 1 and 2

To convert 13 digit into string.

aziq_az1304 — Thu, 01 Dec 2022 10:04:45 GMT

Hi, I'm still new to sas programming. My question as per example below :-

In excel : 1.322E+22

Need to change into this format : 1322000246674 (string)

Anyone can help me on this. I've tried change the format into string somehow it is still the same.

I've tried used functionPUT/INPUT but still the same.

Re: To convert 13 digit into string.

PaigeMiller — Thu, 01 Dec 2022 10:50:47 GMT

Do you want to do this in Excel or in SAS?

I don't think you can convert a number with E+22 exactly

Re: To convert 13 digit into string.

Rick_SAS — Thu, 01 Dec 2022 11:05:37 GMT

Were you able to successfully read the data from Excel into a numeric variable in a SAS data set? That is the first step.

The second step is to use the PUT statement and specify a format that is suitable for your purpose. In the following program, I show how to use the w.d format 30.16, but you might prefer to use 30. if the number is always an integer.

/* Assume that you have read the data into a SAS data set named "Have".
  Here, I create the data set with fake data. */
data Have;
input x;
datalines;
1.322E+22
1.23456789E16
;

data Want;
length str $30;
set Have;
str = put(x, 30.16);  /* apply a SAS format to convert the number to a string */
run;

proc print; run;

For more information, see "Convert numeric values to character."