Hello!
I faced with a problem of making graphs.
I have the following task. There are files from 2006 to 2017, the information in them is the answers of people from different age about their food costs. Every 7 day (within 6 months) such questionnaires were fulfilled. I need to present a graph (linear), where on X axis there will be date (divide the X axis by these 6 months and point out weeks of each month by numbers), on Y axis there will be the sum of costs of pensioners in this period.
The part of the code is the following. Here I extract necessary variables from these group of files and rename them.
forvalues num = 1(1)58 {
capture ren UA4_1 dateinterview_`num'
capture ren UA4_2 monthinterview_`num'
capture ren UB`num'_1 indivQ_`num'
capture ren UB`num'_2_1 inHH_`num'
capture ren UB`num'_2_23 whynotinHH_`num'
capture ren UB`num'_3 monthsinHH_`num'
capture ren UB`num'_4 sex_`num'
capture ren ue1_`num'c moneyfood_`num'
}
*
I have tried many options but everything has failed. Could you help me?
Thank you in advance!