How to assign a number for a repeated measurement

AM

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.

txnelson

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