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: 
  • DownloadSemiconductor Toolkit: Tools to create wafer maps, add wafer geometry to graphics, explore die defects & compare wafers.
  • Discovery Summit 2026: Early User Edition - September 23-24.Register. It's free.
  • Use JMP Clinical with CDISC-compliant data. Review studies, ID safety and efficacy signals & communicate findings with interactive graphics. Register to see how. Aug. 27, 2 pm US ET.

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 (12127 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 (12028 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 (12028 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