cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
Choose Language Hide Translation Bar
jinsejoseph
jinsejoseph
Level III

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

Created: Oct 27, 2021 09:39 AM  |  Last Modified: Jun 10, 2023 4:39 PM (835 views)

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)

0 Kudos
2 REPLIES 2
Mark_Bailey
Staff Mark_Bailey
Staff

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

Oct 27, 2021 09:59 AM (818 views)  |  Posted in reply to message from jinsejoseph 10-27-2021

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.

dale_lehman
dale_lehman
Level VII

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

Oct 28, 2021 10:47 AM (788 views)  |  Posted in reply to message from jinsejoseph 10-27-2021

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. 

0 Kudos