generate survey of the month from period

rahul kumar singh

Join Date: Feb 2020
Posts: 72

generate survey of the month from period

20 May 2020, 03:58

i have consumption data of household and want to create survey of the months from PERIOD_FROM and PERIOD_TO.
i have created variable DAYS from PERIOD_FROM and PERIOD_TO. i have data for year 2009 to 2014. all years data have survey of the month except year 2009. so what i actaully want is to merge that data finally of all years thats why i want a solution like below:

Code:

* Example generated by -dataex-. To install: ssc install dataex
clear
input str8 HH_ID str10(PERIOD_FROM PERIOD_TO) str43 ITEM_NAME str4 ITEM_UNIT double(QTY_HOME_PROD QTY_PUR QTY_OT) byte(OT_CODE CODE_WHO) str16 CODE_WHO_OT double(PRICE_UNIT TOT_VAL) str30 REMARKS float DAYS
"IMHB0216" "30/12/2009" "31/12/2009" "Wheat                   " "Kg  "   .   .  1 2 1 "                "  15     15 "                         "   1
"IAPA0082" "29/12/2009" "31/12/2009" "Rice                    " "Kg  "   .   4  . . . "                "  20     80 "                         "   2
"IAPC0035" "28/12/2009" "31/12/2009" "Pearl/Finger millet     " "Kg  "   .  .5  . . . "                "  10      5 "                         "   3
"IAPC0010" "27/12/2009" "31/12/2009" "Rice                    " "Kg  "   .  12  . . . "                "  13    156 "                         "   4
"IAPA0328" "26/12/2009" "31/12/2009" "Sorghum                 " "Kg  "   .   1  . . . "                "  25     25 "                         "   5
"IMHB0047" "25/12/2009" "31/12/2009" "Sorghum                 " "Kg  "   8   .  . . . "                "   8     64 "                         "   6
"IMHB0211" "24/12/2009" "31/12/2009" "PDS Wheat               " "Kg  "   .   4  . . . "                " 5.5     22 "                         "   7
"IMHB0035" "23/12/2009" "31/12/2009" "PDS Rice                " "Kg  "   .   1  . . . "                "  10     10 "                         "   8
"IMHB0058" "22/12/2009" "31/12/2009" "Rice                    " "Kg  "   .   1  . . . "                "  22     22 "                         "   9
"IAPA0309" "21/12/2009" "31/12/2009" "Sorghum                 " "Kg  "   .   5  . . . "                "  25    125 "                         "  10
"IAPD0039" "20/12/2009" "31/12/2009" "Rice                    " "Kg  "   .  15  . . . "                "  30    450 "                         "  11
"IMHC0059" "04/12/2009" "16/12/2009" "Sorghum                 " "Kg  "   .   2  . . . "                "   8     16 "                         "  12
"IAPB0052" "18/12/2009" "31/12/2009" "Rice                    " "Kg  "   .  25  . . . "                "  10    250 "                         "  13
"IMHA0056" "17/12/2009" "31/12/2009" "PDS Wheat               " "Kg  "   .   2  . . . "                "   5     10 "                         "  14
"IMHD0315" "16/12/2009" "31/12/2009" "Wheat                   " "Kg  "   .  12  . . . "                "  15    180 "                         "  15
"IMHA0053" "15/12/2009" "31/12/2009" "PDS Rice                " "Kg  "   .  10  . . . "                "   6     60 "                         "  16
"IMHA0049" "14/12/2009" "31/12/2009" "Wheat                   " "Kg  "  20   .  . . . "                "  14    280 "                         "  17
"IAPA0241" "13/12/2009" "31/12/2009" "Wheat                   " "Kg  "   .   1  . . . "                "  22     22 "                         "  18
"IAPD0001" "12/12/2009" "31/12/2009" "Rice                    " "Kg  "   .  22  . . . "                "  30    660 "                         "  19
"IMHC0215" "22/11/2009" "12/12/2009" "Sorghum                 " "Kg  "  15   .  . . . "                "   8    120 "                         "  20
"IMHB0226" "05/12/2009" "26/12/2009" "PDS Rice                " "Kg  "   .   3  . . . "                "  10     30 "                         "  21
"IMHC0216" "13/11/2009" "05/12/2009" "Sorghum                 " "Kg  "   .  15  . . . "                "   8    120 "                         "  22
"IMHD0290" "24/11/2009" "17/12/2009" "Rice                    " "Kg  "   . 2.5  . . . "                "  20     50 "                         "  23
"IMHA0036" "21/11/2009" "15/12/2009" "PDS Rice                " "Kg  "   .  10  . . . "                "   6     60 "                         "  24
"IMHC0216" "06/12/2009" "31/12/2009" "Sorghum                 " "Kg  "   .  10  . . . "                "   8     80 "                         "  25
"IMHB0032" "03/12/2009" "29/12/2009" "PDS Wheat               " "Kg  "   .  20  . . . "                " 5.5    110 "                         "  26
"IMHC0205" "01/02/2010" "28/02/2010" "PDS Rice                " "Kg  "   .   5  . . . "                "   4     20 "                         "  27
"IAPA0082" "30/11/2009" "28/12/2009" "Wheat                   " "Kg  "   .   1  . . . "                "  20     20 "                         "  28
"IMHC0210" "01/04/2010" "30/04/2010" "PDS Rice                " "Kg  "   .   4  . . . "                " 7.5     30 "                         "  29
"IAPB0035" "01/05/2010" "31/05/2010" "PDS Rice                " "Kg  "   .  16  . . . "                "   2     32 "                         "  30
"IAPB0277" "02/11/2009" "03/12/2009" "PDS Rice                " "Kg  "   .  12  . . . "                "   2     24 "                         "  31
"IAPB0038" "04/11/2009" "06/12/2009" "Rice                    " "Kg  "   .  56  . . . "                "  16    896 "                         "  32
"IAPB0299" "12/11/2009" "15/12/2009" "Rice                    " "Kg  "   .   . 32 1 3 "                "  28    896 "                         "  33
"IAPB0059" "27/10/2009" "30/11/2009" "PDS Rice                " "Kg  "   .  25  . . . "                "   2     50 "                         "  34
"IAPB0278" "29/10/2009" "03/12/2009" "Rice                    " "Kg  "   .  30  . . . "                "  15    450 "                         "  35
"IMHD0275" "17/11/2009" "27/12/2009" "PDS Wheat               " "Kg  "   .  10  . . . "                " 5.5     55 "                         "  40
"IAPA0036" "01/02/2010" "19/03/2010" "Wheat                   " "Kg  "   .   1  . . . "                "  24     24 "                         "  46
"IAPB0289" "02/11/2009" "19/12/2009" "Sorghum                 " "Kg  "   .   4  . . . "                "  10     40 "                         "  47
"IMPA0050" "05/11/2009" "31/12/2009" "Wheat                   " "Kg  "  35   .  . . . "                "  15    525 "                         "  56
"IKND0050" "01/01/2010" "28/02/2010" "PDS Rice                " "Kg  "   .  24  . . . "                "   3     72 "                         "  58
"IAPD0045" "01/01/2010" "31/03/2010" "Wheat                   " "Kg  "   .   3  . . . "                "  20     60 "                         "  89
"IAPB0059" "01/07/2009" "26/10/2009" "PDS Rice                " "Kg  "   .  32  . . . "                "   2     64 "                         " 117
"IAPB0042" "01/07/2009" "27/10/2009" "PDS Rice                " "Kg  "   .  90  . . . "                "   2    180 "                         " 118
"IAPB0203" "01/07/2009" "28/10/2009" "Rice                    " "Kg  "   .  36  . . . "                "  15    540 "                         " 119
"IAPB0036" "01/07/2009" "29/10/2009" "Wheat                   " "Kg  "   .   4  . . . "                "  18     72 "                         " 120
"IAPB0047" "01/07/2009" "30/10/2009" "Rice                    " "Kg  "   .  60  . . . "                "  28   1680 "                         " 121
"IAPB0257" "01/07/2009" "31/10/2009" "Sorghum                 " "Kg  "   .  10  . . . "                "  10    100 "                         " 122
"IMHC0034" "01/07/2009" "01/11/2009" "Sorghum                 " "Kg  "   .  60  . . . "                "   8    480 "                         " 123
"IAPA0303" "01/07/2009" "02/11/2009" "PDS Rice                " "Kg  "   .  64  . . . "                "   2    128 "                         " 124
"IAPC0054" "01/07/2009" "03/11/2009" "Pearl/Finger millet     " "Kg  "  25   .  . . . "                "  10    250 "                         " 125
"IAPC0051" "01/07/2009" "04/11/2009" "Rice                    " "Kg  "   . 180  . . . "                "  30   5400 "                         " 126
"IAPA0305" "01/07/2009" "05/11/2009" "Rice                    " "Kg  " 140   .  . . . "                "  20   2800 "                         " 127
"IAPB0276" "01/07/2009" "06/11/2009" "PDS Rice                " "Kg  "   .  64  . . . "                "   2    128 "                         " 128
"IAPC0040" "01/07/2009" "07/11/2009" "PDS Rice                " "Kg  "   .  80  . . . "                "   2    160 "                         " 129
"IAPA0202" "01/07/2009" "08/11/2009" "Sorghum                 " "Kg  "   .  20  . . . "                "  18    360 "                         " 130
"IMHA0005" "01/07/2009" "09/11/2009" "PDS Wheat               " "Kg  "   .  60  . . . "                "   5    300 "                         " 131
"IAPD0002" "01/07/2009" "10/11/2009" "Wheat                   " "Kg  "   .   6  . . . "                "  24    144 "                         " 132
"IAPA0055" "01/07/2009" "11/11/2009" "Rice                    " "Kg  " 275   .  . . . "                "  20   5500 "                         " 133
"IMHA0261" "01/07/2009" "12/11/2009" "PDS Rice                " "Kg  "   .  80  . . . "                "   6    480 "                         " 134
"IMHA0208" "01/07/2009" "13/11/2009" "PDS Rice                " "Kg  "   .  40  . . . "                "   6    240 "                         " 135
"IMHB0219" "01/07/2009" "14/11/2009" "Sorghum                 " "Kg  "   .  50  . . . "                "   8    400 "                         " 136
"IMHB0206" "01/07/2009" "15/11/2009" "PDS Rice                " "Kg  "   .  40  . . . "                " 6.5    260 "                         " 137
"IMHC0035" "01/07/2009" "16/11/2009" "Wheat                   " "Kg  "   .  25  . . . "                "  12    300 "                         " 138
"IMHB0200" "01/07/2009" "17/11/2009" "Sorghum                 " "Kg  "   . 225  . . . "                " 7.5 1687.5 "                         " 139
"IMHC0001" "01/07/2009" "18/11/2009" "PDS Rice                " "Kg  "   .  50  . . . "                "   4    200 "                         " 140
"IMHD0291" "01/07/2009" "19/11/2009" "PDS Wheat               " "Kg  "   .  25  . . . "                " 5.5  137.5 "                         " 141
"IAPA0308" "01/07/2009" "20/11/2009" "Wheat                   " "Kg  "   .   5  . . . "                "  20    100 "                         " 142
"IMHC0223" "01/07/2009" "21/11/2009" "Rice                    " "Kg  "   .  18  . . . "                "  14    252 "                         " 143
"IAPA0058" "01/07/2009" "22/11/2009" "Pearl/Finger millet     " "Kg  "   .   4  . . . "                "  18     72 "                         " 144
"IMHD0312" "01/07/2009" "23/11/2009" "Rice                    " "Kg  "   .  12  . . . "                "  25    300 "                         " 145
"IAPA0323" "01/07/2009" "24/11/2009" "Rice                    " "Kg  "  40  10  . . . "                "  20   1000 "                         " 146
"IMHB0244" "01/07/2009" "25/11/2009" "Sorghum                 " "Kg  "  60   .  . . . "                " 7.5    450 "                         " 147
"IAPD0042" "01/07/2009" "26/11/2009" "Wheat                   " "Kg  "   .   6  . . . "                "  20    120 "                         " 148
"IAPD0057" "01/07/2009" "27/11/2009" "Wheat                   " "Kg  "   .   5  . . . "                "  20    100 "                         " 149
"IMHC0211" "01/07/2009" "28/11/2009" "PDS Rice                " "Kg  "   .  40  . . . "                "   9    360 "                         " 150
"IAPC0035" "01/07/2009" "29/11/2009" "PDS Rice                " "Kg  "   .  80  . . . "                "   2    160 "                         " 151
"IMHC0218" "01/07/2009" "30/11/2009" "Sorghum                 " "Kg  "   .  40  . . . "                "   8    320 "                         " 152
"IMHB0050" "01/07/2009" "01/12/2009" "Sorghum                 " "Kg  " 200   .  . . . "                " 7.5   1500 "                         " 153
"IMHB0231" "01/07/2009" "02/12/2009" "Sorghum                 " "Kg  "   .   . 25 2 1 "                " 7.5  187.5 "                         " 154
"IMHB0239" "01/07/2009" "03/12/2009" "PDS Rice                " "Kg  "   .  30  . . . "                "  10    300 "                         " 155
"IMHD0002" "01/07/2009" "04/12/2009" "Wheat                   " "Kg  "  50   .  . . . "                "  15    750 "                         " 156
"IMHB0033" "01/07/2009" "05/12/2009" "PDS Rice                " "Kg  "   .  35  . . . "                " 6.5  227.5 "                         " 157
"IKNB0038" "01/07/2009" "31/12/2009" "PDS Rice                " "Kg  "   .  30  . . . "                "   3     90 "                         " 183
"IAPD0048" "12/02/2009" "31/12/2009" "Rice                    " "Kg  "   .  15  . . . "                "  32    480 "                         " 322
end

what i actually want is that.:
let for example for below observation DAYS are less than 31 so it is one month period over which data is collected:

Code:

 
clear
input str8 HH_ID str10(PERIOD_FROM PERIOD_TO) str43 ITEM_NAME str4 ITEM_UNIT double(QTY_HOME_PROD QTY_PUR QTY_OT) byte(OT_CODE CODE_WHO) str16 CODE_WHO_OT double(PRICE_UNIT TOT_VAL) str30 REMARKS float(DAYS)
"IMHB0216" "30/12/2009" "31/12/2009" "Wheat                   " "Kg  "   .   .  1 2 1 "                "  15     15 "                         "    1

so the desired result is:

Code:

 
clear
input str8 HH_ID str10(SUR_MON_YR) str43 ITEM_NAME str4 ITEM_UNIT double(QTY_HOME_PROD QTY_PUR QTY_OT) byte(OT_CODE CODE_WHO) str16 CODE_WHO_OT double(PRICE_UNIT TOT_VAL) str30 REMARKS float( DAYS)
"IMHB0216" "12/2009"  "Wheat                   " "Kg  "   .   .  1 2 1 "                "  15     15 "                         "    1

]

now for another observation:

Code:

 
clear
input str8 HH_ID str10(SUR_MON_YR) str43 ITEM_NAME str4 ITEM_UNIT double(QTY_HOME_PROD QTY_PUR QTY_OT) byte(OT_CODE CODE_WHO) str16 CODE_WHO_OT double(PRICE_UNIT TOT_VAL) str30 REMARKS float( DAYS)
"IKNB0038" "01/07/2009" "31/12/2009" "PDS Rice                " "Kg  "   .  30  . . . "                "   3     90 "                         "  183

here DAYS are 183 so possible number of months are 183/30=6
so the desired result are

Code:

 
clear
input str8 HH_ID str10(SUR_MON_YR) str43 ITEM_NAME str4 ITEM_UNIT double(QTY_HOME_PROD QTY_PUR QTY_OT) byte(OT_CODE CODE_WHO) str16 CODE_WHO_OT double(PRICE_UNIT TOT_VAL) str30 REMARKS float( DAYS)
"IKNB0038" "07/2009" "PDS Rice                " "Kg  "   .  5  . . . "                "   3     15 "                         "  183
"IKNB0038" "08/2009" "PDS Rice                " "Kg  "   .  5  . . . "                "   3     15 "                         "  183
"IKNB0038" "09/2009" "PDS Rice                " "Kg  "   .  5  . . . "                "   3     15 "                         "  183
"IKNB0038" "10/2009" "PDS Rice                " "Kg  "   .  5  . . . "                "   3     15"                          "  183
"IKNB0038" "11/2009" "PDS Rice                " "Kg  "   .  5  . . . "                "   3     15 "                         "  183
"IKNB0038" "12/2009" "PDS Rice                " "Kg  "   .  5  . . . "                "   3     15 "                         "  183

we can see that all other values like quantity QTY_HOME_PROD, QTY_PUR, QTY_OT, and TOT_VAL are equally devided by number of months but PRICE_UNIT did not divided by number of months.

same for all other possible months.
please help me.
Thanks in advance

Tags: None

Phil Bromiley

Join Date: Apr 2014

Posts: 4348
#2

21 May 2020, 14:13

You didn't get a quick answer. You will increase your chances of useful answer by following the FAQ on asking questions. However, your posting has the opposite problem – it is far too long and complex. Someone would have to take a lot of time to just figure out what you're trying to do.

It sounds to me as if you want to use the data from the other years to generate parameters you can use to translate annual data for 2009 into monthly data. If you collapse the data to monthly, you could run a regression with monthly dummies and year total as the right-hand side variables. Then you could use predict to generate predictions for 2009.
Comment
rahul kumar singh

Join Date: Feb 2020

Posts: 72
#3

21 May 2020, 22:40

hi Phill,
thanks for replying.
but i did not get your point. please if you find any solution then help me as soon as possible. i have managed my all data except for 2009 . so it is very crucial stage for me/
Comment

rahul kumar singh

Join Date: Feb 2020
Posts: 72

23 Jul 2020, 14:23

Code:

___  ____  ____  ____  ____ (R)
 /__    /   ____/   /   ____/
___/   /   /___/   /   /___/   16.0   Copyright 1985-2019 StataCorp LLC
  Statistics/Data Analysis            StataCorp
                                      Downloadly.ir     
     MP - Parallel Edition            College Station, Texas 77845 USA
                                      800-STATA-PC        http://www.stata.com
                                      979-696-4600        [email protected]
                                      979-696-4601 (fax)

Single-user 2-core Stata network license expires 20 Aug 2022:
       Serial number:  501609213901
         Licensed to:  DOWNLOADLY.IR 085227746673
                       WwW.DownLoadLy.iR 085227746673

Notes:
      1.  Unicode is supported; see help unicode_advice.
      2.  More than 2 billion observations are allowed; see help obs_advice.
      3.  Maximum number of variables is set to 5000; see help set_maxvar.

. use "C:\Users\Rahul\Desktop\phd\project\final_cultivation_data\cult_wheat_2009_2014.dta"

. xtset  HH_ID YEAR
       panel variable:  HH_ID (unbalanced)
        time variable:  YEAR, 2009 to 2014
                delta:  1 unit

. xtdes

   HH_ID:  1, 2, ..., 1024                                   n =       1024
    YEAR:  2009, 2010, ..., 2014                             T =          6
           Delta(YEAR) = 1 unit
           Span(YEAR)  = 6 periods
           (HH_ID*YEAR uniquely identifies each observation)

Distribution of T_i:   min      5%     25%       50%       75%     95%     max
                         1       1       5         6         6       6       6

     Freq.  Percent    Cum. |  Pattern
 ---------------------------+---------
      715     69.82   69.82 |  111111
      124     12.11   81.93 |  .....1
      117     11.43   93.36 |  11111.
       12      1.17   94.53 |  111...
       11      1.07   95.61 |  11....
       10      0.98   96.58 |  ..1111
        9      0.88   97.46 |  ....11
        6      0.59   98.05 |  ...111
        6      0.59   98.63 |  .11111
       14      1.37  100.00 | (other patterns)
 ---------------------------+---------
     1024    100.00         |  XXXXXX

. xtsum

Variable         |      Mean   Std. Dev.       Min        Max |    Observations
-----------------+--------------------------------------------+----------------
HH_ID    overall |  477.1398   265.6074          1       1024 |     N =    5194
         between |             295.7476          1       1024 |     n =    1024
         within  |                    0   477.1398   477.1398 | T-bar = 5.07227
                 |                                            |
YEAR     overall |  2011.502   1.708852       2009       2014 |     N =    5194
         between |             .9476056       2009       2014 |     n =    1024
         within  |             1.633966   2009.002   2014.002 | T-bar = 5.07227
                 |                                            |
CROP     overall |         .          .          .          . |     N =       0
         between |                    .          .          . |     n =       0
         within  |                    .          .          . |     T =       .
                 |                                            |
OP_MAI~T overall |         .          .          .          . |     N =       0
         between |                    .          .          . |     n =       0
         within  |                    .          .          . |     T =       .
                 |                                            |
OP_BY_~T overall |         .          .          .          . |     N =       0
         between |                    .          .          . |     n =       0
         within  |                    .          .          . |     T =       .
                 |                                            |
OP_OT_~T overall |         .          .          .          . |     N =       0
         between |                    .          .          . |     n =       0
         within  |                    .          .          . |     T =       .
                 |                                            |
AREA_T~L overall |  3.075442   4.684499        .25         50 |     N =    1069
         between |             3.373041        .25   37.33333 |     n =     347
         within  |             1.912851  -9.441225   15.74211 | T-bar = 3.08069
                 |                                            |
OUTPUT~L overall |  2770.035   4841.666          0      61200 |     N =    1069
         between |             3317.818          0      36280 |     n =     347
         within  |             2392.595  -18009.97   27690.03 | T-bar = 3.08069
                 |                                            |
BY_OUT~L overall |  15.90444   29.84584          0        350 |     N =    1069
         between |             21.30003          0      176.5 |     n =     347
         within  |             15.99198  -108.4289   241.5711 | T-bar = 3.08069
                 |                                            |
BY_OUT~E overall |  204.1492   137.8818          0        500 |     N =     717
         between |             128.3169         10        450 |     n =     256
         within  |             70.83855  -55.85077   441.6492 | T-bar = 2.80078
                 |                                            |
OUTPUT~E overall |  15.22676   3.663428          3         31 |     N =    1062
         between |             3.169878         10         30 |     n =     344
         within  |             2.250716   2.893426   26.22676 | T-bar = 3.08721
                 |                                            |
OT_OUT~L overall |         0          0          0          0 |     N =    1069
         between |                    0          0          0 |     n =     347
         within  |                    0          0          0 | T-bar = 3.08069
                 |                                            |
OT_OUT~E overall |         .          .          .          . |     N =       0
         between |                    .          .          . |     n =       0
         within  |                    .          .          . |     T =       .
                 |                                            |
IRRI_A~L overall |  .8417751   2.509592          0         39 |     N =    1069
         between |             1.568083          0   19.33333 |     n =     347
         within  |             1.643701  -8.491558   25.34178 | T-bar = 3.08069
                 |                                            |
PER_IR~A overall |  22.55318   40.22542          0        250 |     N =    1069
         between |             32.78352          0   122.2222 |     n =     347
         within  |              26.2425  -70.50238   210.0532 | T-bar = 3.08069
                 |                                            |
DIST_F~G overall |  .9372166   .8044688          0          4 |     N =     397
         between |             .8374868          0          4 |     n =     175
         within  |             .2545757    -.72945    2.67055 | T-bar = 2.26857
                 |                                            |
SOIL_D~G overall |  62.99139   65.04535         10        900 |     N =     416
         between |              84.5303         10        900 |     n =     181
         within  |             6.830498   12.99139   112.9914 | T-bar = 2.29834
                 |                                            |
SOIL_F~G overall |  2.936699   .5035344          1          4 |     N =     416
         between |             .5004411   1.666667          4 |     n =     181
         within  |             .1714963   1.936699   3.936699 | T-bar = 2.29834
                 |                                            |
SLOPE_~G overall |  1.738021    .712264          1          4 |     N =     416
         between |              .690432          1          4 |     n =     181
         within  |             .2594295   .2380208   2.738021 | T-bar = 2.29834
                 |                                            |
RENTAL~G overall |  5310.143   2715.717       1000      18000 |     N =     414
         between |              2925.09       1250      18000 |     n =     181
         within  |             1195.946   851.8099    9976.81 | T-bar = 2.28729
                 |                                            |
PLOT_V~G overall |  271715.2   243092.1      30000    2500000 |     N =     398
         between |             256311.7      30000    1450000 |     n =     175
         within  |             103627.3  -778284.8    1321715 | T-bar = 2.27429
                 |                                            |
EB_WOR~S overall |  .3554724   2.966483          0         56 |     N =    1069
         between |             1.135174          0       10.5 |     n =     347
         within  |             2.621425  -10.14453   47.02214 | T-bar = 3.08069
                 |                                            |
EC_WOR~S overall |         0          0          0          0 |     N =    1069
         between |                    0          0          0 |     n =     347
         within  |                    0          0          0 | T-bar = 3.08069
                 |                                            |
EF_WOR~S overall |  .5947147   5.337199          0      117.5 |     N =    1069
         between |             3.086101          0         39 |     n =     347
         within  |             4.148617  -31.36362   86.13638 | T-bar = 3.08069
                 |                                            |
EM_WOR~S overall |  4.032152   22.11293          0        427 |     N =    1069
         between |             16.47529          0        215 |     n =     347
         within  |             16.11689  -207.9678   216.0322 | T-bar = 3.08069
                 |                                            |
FC_WOR~S overall |  3.407502   16.84739          0        236 |     N =    1069
         between |             8.731347          0       97.2 |     n =     347
         within  |             12.78787   -93.7925   190.0742 | T-bar = 3.08069
                 |                                            |
FF_WOR~S overall |  33.78656   35.95653          0     195.25 |     N =    1069
         between |             30.41827          0        152 |     n =     347
         within  |             21.00249  -50.25511   144.9949 | T-bar = 3.08069
                 |                                            |
FM_WOR~S overall |  138.2099   143.0261          0       1108 |     N =    1069
         between |             99.35772          0   802.8333 |     n =     347
         within  |             86.23733  -429.6234   771.2099 | T-bar = 3.08069
                 |                                            |
HB_WOR~S overall |  3.283863   7.356714          0         64 |     N =    1069
         between |             6.264553          0         42 |     n =     347
         within  |             4.782876  -27.71614   52.28386 | T-bar = 3.08069
                 |                                            |
HC_WOR~S overall |  2.489616   19.21897          0        328 |     N =    1069
         between |             8.989284          0   107.3333 |     n =     347
         within  |             14.99403  -104.8437   237.8229 | T-bar = 3.08069
                 |                                            |
HF_WOR~S overall |  51.02295   86.60078          0        756 |     N =    1069
         between |             62.04501          0   487.9883 |     n =     347
         within  |             52.82934  -305.3104   532.8563 | T-bar = 3.08069
                 |                                            |
HM_WOR~S overall |  67.59576   173.2427          0       1721 |     N =    1069
         between |             113.6634          0    1099.08 |     n =     347
         within  |               92.443  -626.1542   955.0958 | T-bar = 3.08069
                 |                                            |
OB_WOR~S overall |  11.65386   21.01617          0        150 |     N =    1069
         between |             15.87431          0   79.33333 |     n =     347
         within  |             12.05863   -52.5128   106.3205 | T-bar = 3.08069
                 |                                            |
MACHI~RS overall |    5.9855   69.48506          0       1730 |     N =    1069
         between |             31.25835          0   531.8333 |     n =     347
         within  |             54.47469  -525.8478   1204.152 | T-bar = 3.08069
                 |                                            |
WORKIN~L overall |  41.12631   144.4403          0    2239.34 |     N =    1069
         between |             61.96712          0      444.3 |     n =     347
         within  |             132.5801   -332.097   1907.243 | T-bar = 3.08069
                 |                                            |
EB_WAGES overall |   12.0739   98.31988          0       1750 |     N =    1069
         between |              42.3485          0   466.6667 |     n =     347
         within  |             85.97413  -454.5928   1324.574 | T-bar = 3.08069
                 |                                            |
EC_WAGES overall |         0          0          0          0 |     N =    1069
         between |                    0          0          0 |     n =     347
         within  |                    0          0          0 | T-bar = 3.08069
                 |                                            |
EF_WAGES overall |  7.959775   70.42018          0       1565 |     N =    1069
         between |             39.87145          0        476 |     n =     347
         within  |             54.65581  -410.3736   1154.626 | T-bar = 3.08069
                 |                                            |
EM_WAGES overall |      74.6   520.5725          0      10981 |     N =    1069
         between |             440.4186          0    5521.75 |     n =     347
         within  |             370.5783   -5384.65    5533.85 | T-bar = 3.08069
                 |                                            |
FC_WAGES overall |  42.10617   194.4158          0       2750 |     N =    1069
         between |             102.1586          0      971.6 |     n =     347
         within  |             147.6865  -929.4938   2333.773 | T-bar = 3.08069
                 |                                            |
FF_WAGES overall |  555.7644   705.5622          0       9550 |     N =    1069
         between |              654.853          0       5275 |     n =     347
         within  |             405.4139  -3719.236   4830.764 | T-bar = 3.08069
                 |                                            |
FM_WAGES overall |   2525.45   2688.441          0      28538 |     N =    1069
         between |             1934.094          0   13215.75 |     n =     347
         within  |              1753.04    -6922.8   22100.75 | T-bar = 3.08069
                 |                                            |
HB_WAGES overall |  228.5274   553.2071          0       6400 |     N =    1069
         between |              452.262          0       3290 |     n =     347
         within  |              375.583  -2251.473   4463.527 | T-bar = 3.08069
                 |                                            |
HC_WAGES overall |  34.08232   247.0647          0       4100 |     N =    1069
         between |             121.0908          0   1341.667 |     n =     347
         within  |             192.3669  -1307.584   2975.749 | T-bar = 3.08069
                 |                                            |
HF_WAGES overall |  793.3862   1306.544          0      11240 |     N =    1069
         between |             1030.245          0       8300 |     n =     347
         within  |             792.3863  -3706.614   7770.053 | T-bar = 3.08069
                 |                                            |
HM_WAGES overall |   1220.06   2885.956          0      33100 |     N =    1069
         between |              1981.67          0   14462.69 |     n =     347
         within  |             1786.291   -9064.94   23832.56 | T-bar = 3.08069
                 |                                            |
OB_WAGES overall |  506.9269   1094.693          0      14000 |     N =    1069
         between |             779.7812          0       6550 |     n =     347
         within  |             638.8954  -3826.406   8373.594 | T-bar = 3.08069
                 |                                            |
MACHI~ES overall |   88.0608   940.1994          0      22030 |     N =    1069
         between |             425.1758          0       6795 |     n =     347
         within  |              737.406  -6706.939   15323.06 | T-bar = 3.08069
                 |                                            |
LABOR_~L overall |  6088.998   5899.008        240      48426 |     N =    1069
         between |             4282.459        510   28128.77 |     n =     347
         within  |             3647.247  -13292.75   34051.25 | T-bar = 3.08069
                 |                                            |
MATERI~T overall |   13188.3   21069.39        175     186130 |     N =    1069
         between |             14945.25        175   146126.3 |     n =     347
         within  |              10873.8   -48741.3     103351 | T-bar = 3.08069
                 |                                            |
GENDER   overall |         .          .          .          . |     N =       0
         between |                    .          .          . |     n =       0
         within  |                    .          .          . |     T =       .
                 |                                            |
AGE      overall |  49.38872   12.48003         16         90 |     N =    5194
         between |             12.31758      17.25       87.5 |     n =    1024
         within  |             3.186597   7.722051   83.55538 | T-bar = 5.07227
                 |                                            |
MARI_S~T overall |  1.189257   .6141913          1          6 |     N =    5194
         between |             .6285069          1        5.5 |     n =    1024
         within  |             .1974629  -.4774098    4.52259 | T-bar = 5.07227
                 |                                            |
MARRIA~R overall |         .          .          .          . |     N =       0
         between |                    .          .          . |     n =       0
         within  |                    .          .          . |     T =       .
                 |                                            |
EDU_LE~L overall |  1.664998   1.715523          0         11 |     N =    5194
         between |             1.664903          0         11 |     n =    1024
         within  |             .2962742  -2.501669   9.998331 | T-bar = 5.07227
                 |                                            |
REA_ST~U overall |  3.947259   1.635091          1          7 |     N =    3356
         between |              1.59704          1          7 |     n =     650
         within  |             .2485127   .6139253   8.113925 | T-bar = 5.16308
                 |                                            |
REA_ST~T overall |         .          .          .          . |     N =       0
         between |                    .          .          . |     n =       0
         within  |                    .          .          . |     T =       .
                 |                                            |
MAIN_O~P overall |  3.121895   3.174309          1         12 |     N =    5193
         between |             2.869144          1         12 |     n =    1024
         within  |             1.470053  -6.044772   12.28856 | T-bar = 5.07129
                 |                                            |
SUBS_O~P overall |  4.260177   3.278634          1         12 |     N =    3955
         between |             2.895607          1         12 |     n =     934
         within  |             1.649986  -3.239823   12.59351 | T-bar = 4.23448
                 |                                            |
HEIGHT   overall |  162.2897   7.897502       61.6      189.8 |     N =    3742
         between |             7.817261   128.5333      189.8 |     n =     992
         within  |             2.665181   84.88973   195.7564 | T-bar = 3.77218
                 |                                            |
WEIGHT   overall |  56.18772   11.51858       26.6      175.1 |     N =    3739
         between |             11.23199       27.5     103.08 |     n =     992
         within  |             3.150417   25.22521   139.5752 | T-bar = 3.76915
                 |                                            |
ARM_CI~M overall |  25.05016   3.945443       13.7         52 |     N =    3737
         between |              3.78788         14       35.5 |     n =     992
         within  |              1.46911   15.69016   46.95016 | T-bar = 3.76714
                 |                                            |
FAMILY~E overall |  5.154794   2.377017          1         24 |     N =    5194
         between |             2.229138          1   22.16667 |     n =    1024
         within  |              .755354  -1.511873   10.48813 | T-bar = 5.07227

Announcement

generate survey of the month from period

Comment

Comment

Comment