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
variable with multiple conditionsHello. I'm attempting to create a new variable (metabolic syndrome) based on meeting at least three…
Problems with simple adjusted logistic regression on small sample-size (n=13)Hi I am trying to make a simple logistic regression adjusted for one potential confounder ("Antibtio…
Question about scanning through directory and compress all stata filesHello, I just wanted to ask if I might run into any issues running the code below. We have some tera…
Sample Size AUC/AUROCHi all, I'm working on a study that will evaluate several score to predict the same outcome (surviv…
Number of instruments in GMM-system estimatorDear all, I am currenlty working on the causal relationship between the informal care decision and …
Subscribe to:
Post Comments (Atom)
0 Response to Reshaping wide error values of variable date not unique within id
Post a Comment