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.
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
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
Thank you! It works perfectly. Have a nice day.