How do I recode indicator columns into one nominal (or ordinal) column?

jmpuser1234 — Mon, 02 Dec 2013 20:22:33 GMT

I have a data set that has been created with indicator columns for all nominal and ordinal variables (for the purpose of running a regression model). For instance, the variable "Marital Status" has 3 possible values, Single, Married, Divorced. The current data file has two columns for this one variable. A "1" in column one and a "0" in column two indicates "Single", a "0" in column one and a "1" in column two indicates "Married" and a "0" in both columns represents "Divorced". I am using JMP and I would like to create one column for this variable with the values of "Single", "Married", or "Divorced". How do I do that? Would it be different for ordinal data?

Re: How do I recode indicator columns into one nominal (or ordinal) column?

pmroz — Mon, 02 Dec 2013 21:19:32 GMT

Create a third column called Marital Status. Right click on the column header and select Column Info. Click on Column Properties and select Formula. Click on Edit Formula. Double-click inside the red rectangle and enter the following code:

If (

:Column 1 == 1 & :Column 2 == 0, "Single",

:Column 1 == 0 & :Column 2 == 1, "Married",

:Column 1 == 1 & :Column 2 == 1, "Divorced"

)

This assumes that your first two columns are called "Column 1" and "Column 2".

topic Re: How do I recode indicator columns into one nominal (or ordinal) column? in Discussions

How do I recode indicator columns into one nominal (or ordinal) column?

Re: How do I recode indicator columns into one nominal (or ordinal) column?