record observations count by ID

[Xiaoningdemao]

Dear All,

i have the following data

ID height
1 150
1 155
1 157
2 160
3 170
3 171

these are the repeated measure of height;

what i want is:

ID height_1   height_2   height_3
1 150            155           157
2 160
3 170            171

Other than height, i have many other measurements, and i don't know how many repeats there is, different measurements may have different number of repeats.

Thank you so much in advance!!!

Best wishes.

[Xiaoningdemao]

the approach i want to resolve this issue, is to use proc transpose, but i need a variable to count the repeats, i have trouble formulate variable "repeats";

ID height   repeats
1 150         1
1 155         2
1 157         3
2 160         1
3 170         1
3 171         2

any thought on this?

Thanks!!!!

[ballardw]

---

@Xiaoningdemao wrote:

the approach i want to resolve this issue, is to use proc transpose, but i need a variable to count the repeats, i have trouble formulate variable "repeats";

ID height   repeats
1 150         1
1 155         2
1 157         3
2 160         1
3 170         1
3 171         2

any thought on this?

Thanks!!!!

---

What is the expected output for this example considering your "repeats"?

Also, what may you be doing with the resulting data set?

[Reeza]

This is a tutorial on creating an enumerating variable.

[Reeza · Accepted solution]

Link may help: https://stats.idre.ucla.edu/sas/faq/how-can-i-create-an-enumeration-variable-by-groups/

[Xiaoningdemao]

exactly what i want!!!!
Thank you so much Reeza.