topic Re: How to assign a number for a repeated measurement in Discussions

How to assign a number for a repeated measurement

AM — Mon, 18 Feb 2019 14:41:24 GMT

Hi,

I have a dt with measurements of vital signs repeated three times at a visit for each subject.:

Subjects	Vital Signs	Result	visit	Repetition
1	Dias	60	1	a
1	Dias	65	1	b
1	Dias	62	1	c
1	Sys	122	1	a
1	Sys	120	1	b
1	Sys	125	1	c
1	Pul	72	1	a
1	Pul	74	1	b
1	Pul	77	1	c
2	Dias	65	1	a
....	...	....	....	....

I would like to write a formula that calculates repetitions for vital signs measurements in a new column (e.g. repetition a, b, c). What would be the best way to assign those values?

Thank you in advance forhelp.

Re: How to assign a number for a repeated measurement

txnelson — Mon, 18 Feb 2019 15:32:42 GMT

If making the Repetition a numeric value is an option, then you could simply create the new column, and then go to Col Info, and under "Initialize Data" select "Sequence Data" and then specify a sequence of 1 to 3

Or you could create the formula

theList = {"a", "b", "c"};
If( Mod( Row(), 3 ) > 0,
	theList[Mod( Row(), 3 )],
	theList[3]
);

Make sure the column is defined as a Character column to use the above formula

Re: How to assign a number for a repeated measurement

ron_horne — Mon, 18 Feb 2019 21:40:25 GMT

hi @AM ,

@txnelson gave a good clean solution for your question. But if your data is actually more complicated have a look at the following

https://community.jmp.com/t5/Discussions/Syntax-How-do-I-create-an-index-column-by-ID/m-p/9751/highlight/true#M9537

it does the same but in a more robust way managing messy data sets.

Re: How to assign a number for a repeated measurement

AM — Tue, 19 Feb 2019 07:45:04 GMT

Thank you! It works perfectly. Have a nice day.