Hi,
I have 51 state name variables(long data) and income data (e.g.starting from inc_JAN_1996, inc_Feb_1996, ..., inc_Dec_2004, ..., inc_Dec_2005) with a wide shape.
In other words, I have 51 long shaped and 120 wide shaped dataset and want to change into long data.
--------------------
reshape long inc_Jan inc_Feb ... inc_Dec, i(statename) j(year)
_____________
From this command, I could get only year data. Please help me to extract month and year data.
Thanks in advance.
Related Posts with How do I extract month and year data from combined variables?
How to test whether the two variables are 2 standard deviation different from each other?Dear Stata experts, I have below comments from one referee for my paper, can someone guide me how t…
Ordered probit and generalized ordered probit estimatesHi! I have an ordinal variable with four level as my dependent variable. In the regression table, I…
Uneven length of x axis in graph combineHi, I am trying to combine 3 coefplots using graph combine in Stata 16. I have coefficient labels o…
Estimating effect size in power calculationHello all, The answer to this question is probably no, but I had a quick question after doing a qui…
How to identify that random effect linear model is required over fixed effect linear model?I'm trying to predict a continuous variable using multiple linear regression model including various…
Subscribe to:
Post Comments (Atom)
0 Response to How do I extract month and year data from combined variables?
Post a Comment