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?
Kind suggestion of a methodology for a sensitivity or robustness check of fixed effectPlease, can someone help me in the group, I am doing research in the area of health economics (child…
foreach loop with different prefixesI need to do some data manipulation that involves variables with many different alpha prefixes (rang…
Variance of a ratio with unknown covariance between numerator and denominatorI have two means and their standard errors from a paper. I would like to calculate their ratio and i…
How i can make columns from list in other variableHi, i have some data with different column from which i wan to make i am attaching desired output …
How can I label the values of the bars within a twoway bar graph?Hello! I am creating a bar graph with confidence intervals(picture attached below). It would be nic…
Subscribe to:
Post Comments (Atom)
0 Response to How do I extract month and year data from combined variables?
Post a Comment