User Community
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: 
  • New to JMP? Join us Sept. 23-24 for the Early User Edition of Discovery Summit, tailor-made for new users. Register now for free!
  • Your voice matters! Tell us how you prefer to receive JMP updates, so we can tailor our communication to your needs. Take short survey.
  • See how to access JMP Marketplace - and - find, create & share add-ins to extend your JMP. Watch video.

Discussions

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

Creating Subject-IDs

Mar 16, 2015 02:22 AM (12084 views)

How do I create a column that merely numbers all of the data. I already have all of my data ready, I just need a column to use that is 1-etc. for the Subject-ID. Thank you!

0 Kudos
2 REPLIES 2
pmroz
Super User pmroz
Super User

Re: Creating Subject-IDs

Mar 16, 2015 08:28 AM (11985 views)  |  Posted in reply to message from kmohajer 03-16-2015

Right click on a new column and select New Column.  Click on Initialize Data and select Sequence Data.  Enter your desired values for From, To and Step.

hlrauch
hlrauch
Level III

Re: Creating Subject-IDs

Mar 17, 2015 09:57 AM (11985 views)  |  Posted in reply to message from kmohajer 03-16-2015

If you need the data/row number to update whenever you add or delete rows, you can create a column with a simple formula. Add a new column and then right-click on the header/name of the new column and select Formula. In the formula window click on Row in the Functions(grouped) list and then click on Row in the pop-up list of functions. The formula "Row()" will appear in the formula box. Click OK.

Recommended Articles