I need an urgent help pleeeeease. I am going to do matching comparison between intervened group ( in follow up period, then I want to separate results in time=1) and matched control group. then I am going to do reshape, but I get this error, is it because of missed data or repetitive not unique data?
my data is 70mys mexico pension program. if you need more details please let me know.
reshape wide spending_dec age employment expenditure hh_exp childs_live married_years newchilds newadults newolder
> _adults gds, i(newfolio) j(time)
(note: j = 0 1)
values of variable time not unique within newfolio
Your data are currently long. You are performing a reshape wide. You specified i(newfolio) and j(time).
There are observations within i(newfolio) with the same value of j(time). In the long data, variables i() and
j() together must uniquely identify the observations.
long wide
+---------------+ +------------------+
| i j a b | | i a1 a2 b1 b2 |
|---------------| <--- reshape ---> |------------------|
| 1 1 1 2 | | 1 1 3 2 4 |
| 1 2 3 4 | | 2 5 7 6 8 |
| 2 1 5 6 | +------------------+
| 2 2 7 8 |
+---------------+
Type reshape error for a list of the problem variables.
r(9);
.
Related Posts with reshape for matching
generate a line include several variablesHi, I am thinking how to generate ESG_Disclosure which include all years of ESG_disclosure score? so…
DateHi, How do I get to date in dd/mm/yyyy format? For example: 03/01/2011 Thanks! Code: * Example gen…
Creating loops with conditionsGoodmorning everyone, I'm here again to ask you for help. My starting code is this: Code: gen pROE…
Query about merge files in different formatHi, I am wondering how to merge two databases which are in different format? Thank you so much for y…
Marginal effect and its CI using ivreghdfeHi, I am estimating a two-way fixed effect IV regression with an interactive variable as a predicto…
Subscribe to:
Post Comments (Atom)
0 Response to reshape for matching
Post a Comment