topic Re: How do I reference data from column A to column B? (I honestly can't find the answer) in Discussions

How do I reference data from column A to column B? (I honestly can't find the answer)

slamer2000 — Sun, 23 Apr 2017 15:11:35 GMT

Hi there, I know this is probably very easy for most but I've been searching through the JMP discussion pages, and also google searches just to simply do the following.

I want all the data in my "Age" column to be "referenced" or the same, as another column called AgeGroups since in this column I have made age ranges for the data values (16 to 24, 25-30 etc..). I've seen plenty of similar discussion questions about scripting related problems. I've been searching but I really can't find an answer that I can understand as I just got started with JMP after previously using SPSS. I've only had a little experience with the SPSS' syntax but I'm still very new to programming. Help is much appreciated.

Re: How do I reference data from column A to column B? (I honestly can't find the answer)

txnelson — Sun, 23 Apr 2017 16:16:07 GMT

There are a few different ways you can accomplish what you want. From running in an interactive mode, using "Recode" is probably the easiest way.

Select the column to be recoded

Then click on the red triangle in the column panel and select "Recode"

Then just fill in the new bins you want

and then click on Done, and select new column, and you will find the new binning column

You can also select to make a "Formula Column", rather than a "New Column". If you do this, the new column that is created is done using a column formula, rather than hard coded values.

Re: How do I reference data from column A to column B? (I honestly can't find the answer)

slamer2000 — Mon, 24 Apr 2017 10:30:42 GMT

Thanks for that advice. Yes, the recoding method does the job. I think the solution that I was looking for is a solution similar to what you mentioned about making a formula column. How do I do something like how in excel where you input a simple formula e.g =CELLx:CELLy so that one cell or in my case, one column equals to another? I know its probably done by coding but since I'm still new to JMP I don't know how to do it and as I said, I had searched for the answer (as well as the program code) as far as I could search but for some reason couldn't find it.

Re: How do I reference data from column A to column B? (I honestly can't find the answer)

ian_jmp — Mon, 24 Apr 2017 10:51:58 GMT

JMP allows you to build formula columns via 'pont and click'. To get started, take a look here. Also, note that 'Recode' allows you to make a formula column (see one of the screenshots above). No matter how you make it, a formula column will have a '+' sign next to it in the table columns panel. Clicking on the '+' takes you directly to the formula editor showing the formula involved.