cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Sign-in to the JMP Community will be unavailable intermittently Dec. 6-7 due to a system update. Thank you for your understanding!
  • We’re retiring the File Exchange at the end of this year. The JMP Marketplace is now your destination for add-ins and extensions.
  • JMP 19 is here! Learn more about the new features.

Discussions

Solve problems, and share tips and tricks with other JMP users.
Choose Language Hide Translation Bar
GardDog
Level III

I have a script, and I want to add some values to my data in a specific row and column. There are no unique values to where I could use an if statement to signify the row. Are there any other options to do this?

 
1 REPLY 1
txnelson
Super User

Re: I have a script, and I want to add some values to my data in a specific row and column. There are no unique values to where I could use an if statement to signify the row. Are there any other options to do this?

Here are a variety of ways to directly access specific row/columns and change their values.  They are all documented in the Scripting Guide.

     Help==>Documentation Library

names default to here(1);

dt=open("$SAMPLE_DATA/big class.jmp");

:height[2] = 99;

dt[4,4]=88;

column(dt, "Height")[6] = 44;

:height[dt<<get rows where(:age == 13)] = 21;

:height[16::20] = 34;

 

Jim

Recommended Articles