Hi,
I have a longitudinal data set, which contains the monthly information. Required to convert from monthly to quarterly data. Data is, now, in the following format. How can I do it?
Any kind of advice appreciated.
input str134 B str4 D str12 E str38 Columns float ID
"B. (Mining And Quarrying)" "2007" "01-January" "63.7" 2
"B. (Mining And Quarrying)" "2007" "02-February" "61.5" 2
"B. (Mining And Quarrying)" "2007" "03-March" "67.7" 2
"B. (Mining And Quarrying)" "2007" "04-April" "73" 2
"B. (Mining And Quarrying)" "2007" "05-May" "78.59999999999999" 2
"B. (Mining And Quarrying)" "2007" "06-June" "80.8" 2
"B. (Mining And Quarrying)" "2007" "07-July" "86.59999999999999" 2
Related Posts with Conversion from monthly to quarterly data
Flexible parametric modelling, models do not convergeHi, I’m using the -stpm2- command to generate a flexible parametric model (relative survival, >1…
f test following reghdfe for joint significance of individual fixed effectsHi all, I'd like to run a f-test to test joint significance of each fixed effects. For example, I'd…
Implied Cost of Equity, mm_root function skips the results of some observationsHi There, I have used the following codes to calculate the implied cost of equity. While the code c…
Losing Precision with ASEC ID ValuesHi Statalisters, I'm currently working with the 2019 CPS ASEC, trying to match individual responden…
Decomposing regression into within and between effectsConsider the following baseline model: yijk = beta * xijk + errorijk where i indicates a child, j i…
Subscribe to:
Post Comments (Atom)
0 Response to Conversion from monthly to quarterly data
Post a Comment