topic record observations count by ID in SAS Programming

record observations count by ID

Xiaoningdemao — Wed, 18 Oct 2017 21:30:19 GMT

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.

Re: record observations count by ID

Xiaoningdemao — Wed, 18 Oct 2017 21:33:30 GMT

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

Re: record observations count by ID

ballardw — Wed, 18 Oct 2017 22:03:03 GMT

@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?

Re: record observations count by ID

Reeza — Wed, 18 Oct 2017 22:44:49 GMT

This is a tutorial on creating an enumerating variable.

Re: record observations count by ID

Reeza — Wed, 18 Oct 2017 22:45:10 GMT

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

Re: record observations count by ID

Xiaoningdemao — Wed, 18 Oct 2017 23:23:13 GMT

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