topic Re: While changing the data type to numeric column data changed from 00000 to 0, in Discussions

While changing the data type to numeric column data changed from 00000 to 0,

jinsejoseph — Sat, 10 Jun 2023 23:39:28 GMT

Hi Team,

Need help to avoid the round off,
like when changed from character to numeric column value changed from 0000 to 0
please suggest some solution ,

i need the same entire string for analysis

(view in My Videos)

Re: While changing the data type to numeric column data changed from 00000 to 0,

Mark_Bailey — Wed, 27 Oct 2021 13:59:27 GMT

Zero is represented numerically as 0, so JMP is correct. If you want to format (display) zero differently, then change the Format attribute of the data column.

I do not find such a format, so you will have to make one. See the JMP Help section about custom formats.

Re: While changing the data type to numeric column data changed from 00000 to 0,

dale_lehman — Thu, 28 Oct 2021 14:47:32 GMT

I don't really understand why you would want to change the column to numeric but retain a code of 0000 rather than 0. Presumably, 0000 means something other than 0, such as missing data, not applicable, etc. I would think that it would be better to create a new nominal variable indicating whether or not that code (and what it represents) is present, and then recode the original column so that 0000 becomes missing rather than 0. If I am not understanding what the data represents, then perhaps you don't really want it to be continuous data at all.