record observations count by ID

Solved
Frequent Contributor
Posts: 76

record observations count by ID

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.

Accepted Solutions
Solution
‎10-19-2017 11:25 AM
Super User
Posts: 23,262

Re: record observations count by ID

All Replies
Frequent Contributor
Posts: 76

Re: record observations count by ID

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!!!!

Super User
Posts: 13,304

Re: record observations count by ID

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?

Super User
Posts: 23,262

Re: record observations count by ID

This is a tutorial on creating an enumerating variable.

Solution
‎10-19-2017 11:25 AM
Super User
Posts: 23,262

Re: record observations count by ID

Frequent Contributor
Posts: 76

Re: record observations count by ID

exactly what i want!!!!
Thank you so much Reeza.
☑ This topic is solved.