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