Creating Categorical Variable

schreiberj — Sat, 10 Jun 2023 20:37:33 GMT

I am trying to create a categorical variable (a third variable) from two categorical variables.

Thanks...

Re: Creating Categorical Variable

txnelson — Wed, 15 Jul 2020 16:30:52 GMT

Your request is quite vague in what the new column is supposed to contain, so I will assume you want to concatenate the two columns together. To do this,

Move your cursor to the column header you want the new column to be created next to and right click and select "Insert Column"
Right click on the new column's header, and select "Column Info"
In the Column Info window, type in your new column's name and change the Modeling Type to Character.
Click on OK
Once again place right click on the new column's header and select "Formula"
Click on the first column name of the two columns you want to be concatenated.
Now click on the Character category on the left column of the window, and select "Concat"
Click on the second column name of the two columns you want to be concatenated
The JMP Formula Builder should now have built a formula that looks something like
```
firstcolname || secondcolname
```
Click on OK and the formula will be applied to the new column

I strongly suggest that you go through the Discovering JMP and Using JMP documents from the JMP Documentation Library

Help==>JMP Documentation Library

topic Creating Categorical Variable in Discussions

Creating Categorical Variable

Re: Creating Categorical Variable