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
slamer2000
slamer2000
Level II

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

Created: Apr 23, 2017 07:42 AM  |  Last Modified: Apr 23, 2017 8:11 AM (8486 views)

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. 
jmp forum 2.jpg

0 Kudos
3 REPLIES 3
txnelson
Super User txnelson
Super User

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

Apr 23, 2017 12:16 PM (8474 views)  |  Posted in reply to message from slamer2000 04-23-2017

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"

Recode 1.PNG

Then just fill in the new bins you want

Recode 2.PNG

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

recode 3.PNG

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.

Jim
slamer2000
slamer2000
Level II

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

Apr 24, 2017 06:30 AM (8449 views)  |  Posted in reply to message from txnelson 04-23-2017

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. 

0 Kudos
ian_jmp
ian_jmp
Level X

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

Created: Apr 24, 2017 06:50 AM  |  Last Modified: Apr 24, 2017 3:51 AM (8447 views)  |  Posted in reply to message from slamer2000 04-24-2017

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.