datatype of the JMP sample data: Rats

Question

Hello, there,

I am studying the JMP sample data Rats, but get confused by the datatype of the column "Censor". It has values of "Failed" or "Censored"; however, the datatype is still numeric. How could it be?

I created a similar data in Excel. I opened it in JMP and tried to change the column of "censor" into the numeric, but never succeeded.

Could anyone help me out?

Thanks.

C.

gx · Answer

Thank you very much. Yes, this works.

Well, I still wonder how the sample data were created. Hope to figure that out someday...

C.

Craige_Hales · Answer

Not sure what the preferred way is @Mark_Bailey but try this: select the character-data column, then cols->recode and map character values to values that can be converted to numbers, 0 and 1 probably. You can either make a new column or change the settings to do it in place. After that is finished, then convert the character column to numeric.

gx · Answer

Thank you very much for your reply. I did notice that. I guess that moves to my next question regarding my own data. I have data in excel and open with JMP

Here the censor column has values of "failed" or "Censored" and datatype of "Character". I then tried to modify data following the sample data as shown below:

I clicked "Apply" and all the censor column changed to "." like below:

Did I do something wrong?

Thanks a lot..

C.