Dear Statalist Users,
Although I went through many related discussions and explanations about my question, nothing helped me. I will be thankful for your suggestions in the following problem.
I am working with a Call Details Record (CDR) Dataset. In the data, for each caller id I observe the antenna used to make/receive call. I want to generate the variable for the number of times a certain antenna is used by a caller. What I am looking for is the following:
caller_id time antenna_id count_var
1 t_11 50 2
1 t_12 55 1
1 t_13 50 2
2 t_21 51 1
2 t_22 52 1
2 t_23 53 3
2 t_24 53 3
2 t_25 53 3
3 t_31 55 2
3 t_32 55 2
3 t_33 50 1
3 t_34 51 1
3 t_35 52 2
3 t_36 52 2
3 t_37 54 3
3 t_38 54 3
3 t_39 54 3
...
Thanks in advance for your cooperation. Bests.
S.
Related Posts with Problem with count variable generation
xtivreg2 and interpretation of post estimation resultsHi, I am running an xtivewg2 command using some instrumental variables. I would like to reconfirm m…
Extracting the year from a variable in stataHello, I probably have a very simple query but I can't work out how to solve it I have a variable en…
Loop over quarterly variables to find yearly meansHi Everyone, I'm quite new to Stata (version 17.0) and I'm having some trouble implementing a loop …
Create a chart to track changes of exectuive titlesHi Statalist, I want to create a chart to record the title changes of exectuives. For example, I w…
My nl equation has an error, please help!Hello everyone, I am trying to estimate the parameters a and c of a nonlinear equation. The nonline…
Subscribe to:
Post Comments (Atom)
0 Response to Problem with count variable generation
Post a Comment