Hi,
I`m fairly new to Stata and I know this question is previously answered however I could not make it work for me.
This is the type of data I`m working with:
id date r i
1 2002_11 1.307071 .87494
1 2002_12 1.403008 1.019082
1 2003_01 1.570926 1.152942
1 2003_02 1.894784 1.307366
1 2003_03 1.798847 1.235295
This is the command i`m using:
reshape wide r i, i(id) j(date) str
This is the error:
values of variable date not unique within id
Your data are currently long. You are performing a reshape wide. You specified i(id) and j(date). There are observations
within i(id) with the same value of j(date). In the long data, variables i() and j() together must uniquely identify the
observations.
What do I need to change or add ?
Thanks for all replies.
Best,
Emerson
Related Posts with Reshaping wide error values of variable date not unique within id
how to calculate the cumulative mean by groups?For example, for the observation group 1 time 1, the cumulative mean is missing; for observation gro…
Creating huge number of fixed effectsHi everyone, I have a large firm level panel with 1 million units over 20 years. I want to run a di…
Labeling Graphs after "Separate" and "Collapse"Hello, I have the following code: Code: preserve separate income, by(gender) collapse(…
ARDL modelHow to estimate a ARDL model with interaction variables ? First, i used the PCA method to generate t…
Difference in the estimate between subsample and interaction modelHi all This question might be stupid but I am really curious. Suppose I want to run the following …
Subscribe to:
Post Comments (Atom)
0 Response to Reshaping wide error values of variable date not unique within id
Post a Comment