DATA Step, Macro, Functions and more

record observations count by ID

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 76
Accepted Solution

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

Posted in reply to Xiaoningdemao

All Replies
Frequent Contributor
Posts: 76

Re: record observations count by ID

Posted in reply to 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!!!!

Super User
Posts: 13,304

Re: record observations count by ID

Posted in reply to Xiaoningdemao

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

Posted in reply to Xiaoningdemao
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

Posted in reply to Xiaoningdemao
Frequent Contributor
Posts: 76

Re: record observations count by ID

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

Need further help from the community? Please ask a new question.

Discussion stats
  • 5 replies
  • 104 views
  • 2 likes
  • 3 in conversation