topic Re: Why a long numeric value changed after converting the variable from character to numeric? in SAS Programming

Why a long numeric value changed after converting the variable from character to numeric?

newboy1218 — Thu, 23 Apr 2020 01:35:41 GMT

Hi, I have a dataset where it has a variable that is a character but the value is in a numeric format. Thus, I transformed it from char to num by doing the following logit. However, after the transformation, the numeric value of the ones with a long digit is changed. Why is that? How can I make sure all the values do not change?

data output (rename = (ID2 = ID));
	set input;
	format ID2 32.;
	ID2 = ID * 1;
	drop ID;
run;

input dataset:

ID (char)

1 4475970392100582373

2 15545765241442042890

3 42747761341861168

dataset:

ID (num)

1 4475970392100582400

2 15545765241442043904

3 42747761341861168 (this one didn't change)

Re: Why a long numeric value changed after converting the variable from character to numeric?

SASKiwi — Thu, 23 Apr 2020 02:14:28 GMT

SAS uses 8 bytes of storage to hold numbers so that means it can only hold about 15 digits accurately. The moral of the story is don't convert IDs held as character to numeric as you are likely to lose precision as a consequence. There is no reason to convert numbers stored in character form unless you are performing numerical analysis or mathematical calculations.

Re: Why a long numeric value changed after converting the variable from character to numeric?

newboy1218 — Thu, 23 Apr 2020 02:16:12 GMT

I see. The reason why I wanted to convert this variable is I want to use this variable later to do merge. I have 2 datasets have the same variables and I want to merge them by this variable. So, if I keep this variable as character, can I still merge these 2 tables?

Re: Why a long numeric value changed after converting the variable from character to numeric?

SASKiwi — Thu, 23 Apr 2020 02:40:01 GMT

Yes, as long as the two variables are both character you can merge them. In fact merging is more reliable leaving them as character.

Re: Why a long numeric value changed after converting the variable from character to numeric?

newboy1218 — Thu, 23 Apr 2020 02:44:57 GMT

I see. Thank you so much.