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
Gen a variable in a loop: error "variable already defined"Hello everyone. I am trying to run this loop. I need to get two subsamples of frequent and occasion…
Combine graphs created with -mlowess-Hello Statalist, is there any option to combine several graphs I created with HTML Code: mlowess ?…
Q-Q plots - why is Tukey Mean-Difference plots not an option in Stata?Q-Q plot combined with Tukey mean-difference plot - re 'Visualizing Data by Cleveland (1993) Dear A…
Prompt for values interactively in do fileDear Statalist, Is there any way to prompt for local variable with pattern i.e. numeric only/alpha …
Reshape from wide to longHi everyone, I get data from Datastream and there are some firms having no data, i.e. price_14 "$$…
Subscribe to:
Post Comments (Atom)
0 Response to Reshaping wide error values of variable date not unique within id
Post a Comment