***************************************************************************************** * Stata program for the conversion of data from the India NSS68 survey * from ASCII format to Stata format. * This program converts data from Schedule 1.0 Type 1 and adds variables and value labels. * * Author: Akiko Sagesaka, World Bank Data Group (Jul. 2013) ***************************************************************************************** clear set mem 1200M set more off #delimit ; global pathin "C:\HHS\Datalib\India\IND_2011_NSS68-SCH1.0-T1\IND_2011_NSS68-SCH1.0-T1_v01_M\Data\Original"; global pathout "C:\HHS\Datalib\India\IND_2011_NSS68-SCH1.0-T1\IND_2011_NSS68-SCH1.0-T1_v01_M\Data\Stata"; ***************************************************************; * SCHEDULE 1.0 - LEVEL 1 (Block 1) ; ***************************************************************; drop _all; infix str B1_v00 1 - 3 str B1_v01 4 - 8 str B1_v02 9 - 10 str B1_v03 11 - 13 str B1_v04 14 - 14 str B1_v05 15 - 15 str B1_v06 16 - 18 str B1_v07 19 - 20 str B1_v08 21 - 22 str B1_v09 23 - 24 str B1_v20 25 - 25 str B1_v10 26 - 26 str B1_v11 27 - 27 str B1_v12 28 - 31 str B1_v13 32 - 32 str B1_v14 33 - 33 str B1_v15 34 - 35 str Level 36 - 37 str B1_v16 43 - 44 str B1_v17 45 - 45 str B1_v18 46 - 46 str B1_v19 47 - 47 str B2_v02a 48 - 53 str B2_v02b 54 - 59 str B2_v04 60 - 62 str B2_v05a_1 63 - 63 str B2_v05a_2 64 - 64 str B2_v05b_1 65 - 65 str B2_v05b_2 66 - 66 str NSS 127 - 129 str NSC 130 - 132 str MLT 133 - 142 using "$pathin\R6801T1L01.TXT"; gen state=substr(B1_v06,1,2); compress; gen ID= B1_v01+B1_v13+B1_v14+B1_v15; isid ID; destring *, replace; format ID %12.0g; order ID state *; gen hhwt=MLT/100 if NSS==NSC; replace hhwt=MLT/200 if NSS!=NSC; label variable ID "ID number"; label variable state "State" ; label variable B1_v00 "Round and Centre code"; label variable B1_v01 "LOT/FSU number"; label variable B1_v02 "Round"; label variable B1_v03 "Schedule Number"; label variable B1_v04 "Sample"; label variable B1_v05 "Sector"; label variable B1_v06 "State-Region"; label variable B1_v07 "District"; label variable B1_v08 "Stratum Number"; label variable B1_v09 "Sub-Stratum"; label variable B1_v20 "Schedule type"; label variable B1_v10 "Sub-Round"; label variable B1_v11 "Sub-Sample"; label variable B1_v12 "FOD Sub-Region"; label variable B1_v13 "Hamlet-Group/Sub-Block no."; label variable B1_v14 "Second Stage Stratum"; label variable B1_v15 "HHS No."; label variable Level "Level"; label variable B1_v16 "Sl. No. of informant"; label variable B1_v17 "Response Code"; label variable B1_v18 "Survey Code"; label variable B1_v19 "Substitution Code"; label variable B2_v02a "Date of Survey"; label variable B2_v02b "Date of Despatch"; label variable B2_v04 "Time to canvass(mins.)"; label variable B2_v05a_1 "Remarks - in block 14/15"; label variable B2_v05a_2 "Remarks - in block 14/15"; label variable B2_v05b_1 "Remarks - elsewhere"; label variable B2_v05b_2 "Remarks - elsewhere"; label variable NSS "NSS"; label variable NSC "NSC"; label variable MLT "MLT"; label variable hhwt "Weighting coefficient" ; la def sample 1 "Central" 2 "State"; la def sector 1 "Rural" 2 "Urban"; la def respcode 1 "Informant co-operative and capable" 2 "Informant co-operative but not capable" 3 "Informant busy" 4 "Informant reluctant" 9 "Others"; la def survcode 1 "Original" 2 "Substitute" 3 "Casualty"; la def reason 1 "Informant busy" 2 "Members away from home" 3 "Informant non-cooperative" 9 "Others"; la def state 1 "Jammu & Kashmir" 2 "Himachal Pradesh" 3 "Punjab" 4 "Chandigarh" 5 "Uttaranchal" 6 "Haryana" 7 "Delhi" 8 "Rajasthan" 9 "Uttar Pradesh" 10 "Bihar" 11 "Sikkim" 12 "Arunachal Pradesh" 13 "Nagaland" 14 "Manipur" 15 "Mizoram" 16 "Tripura" 17 "Meghalaya" 18 "Assam" 19 "West Bengal" 20 "Jharkhand" 21 "Orissa" 22 "Chattisgarh" 23 "Madhya Pradesh" 24 "Gujarat" 25 "Daman & Diu" 26 "D & N Haveli" 27 "Maharastra" 28 "Andhra Pradesh" 29 "Karnataka" 30 "Goa" 31 "Lakshadweep" 32 "Kerala" 33 "Tamil Nadu" 34 "Pondicherry" 35 "A & N Islands"; la def yesno 1 "Yes" 2 "No"; label values state state; label values B1_v04 sample; label values B1_v05 sector; label values B1_v17 respcode; label values B1_v18 survcode; label values B1_v19 reason; label values B2_v05a_1 B2_v05a_2 B2_v05b_1 B2_v05b_2 yesno; sort ID; save "$pathout\NSS68_Sch1-T1_bk_1_2", replace; ***************************************************************; * SCHEDULE 1.0 - LEVEL 2 (Block 3) ; ***************************************************************; drop _all; infix str B1_v00 1 - 3 str B1_v01 4 - 8 str B1_v02 9 - 10 str B1_v03 11 - 13 str B1_v04 14 - 14 str B1_v05 15 - 15 str B1_v06 16 - 18 str B1_v07 19 - 20 str B1_v08 21 - 22 str B1_v09 23 - 24 str B1_v20 25 - 25 str B1_v10 26 - 26 str B1_v11 27 - 27 str B1_v12 28 - 31 str B1_v13 32 - 32 str B1_v14 33 - 33 str B1_v15 34 - 35 str Level 36 - 37 str B3_v01 43 - 44 str B3_v02 45 - 49 str B3_v03 50 - 52 str B3_v04 53 - 53 str B3_v05 54 - 54 str B3_v06 55 - 55 str B3_v07 56 - 56 str B3_v08 57 - 57 str B3_v09 58 - 65 str B3_v10 66 - 73 str B3_v11 74 - 81 str B3_v12 82 - 89 str B3_v13 90 - 97 str B3_v14 98 - 105 str B3_v15 106 - 113 str NSS 127 - 129 str NSC 130 - 132 str MLT 133 - 142 using "$pathin\R6801T1L02.TXT"; gen state=substr(B1_v06,1,2); compress; gen ID= B1_v01+B1_v13+B1_v14+B1_v15; isid ID; destring *, replace; format ID %12.0g; gen hhwt=MLT/100 if NSS==NSC; replace hhwt=MLT/200 if NSS!=NSC; gen B3_v04a=B1_v05*10+B3_v04; order ID state B1_v00 B1_v01 B1_v02 B1_v03 B1_v04 B1_v05 B1_v06 B1_v07 B1_v08 B1_v09 B1_v10 B1_v11 B1_v12 B1_v13 B1_v14 B1_v15 B1_v20 Level B3_v01 B3_v02 B3_v03 B3_v04 B3_v04a B3_v05 B3_v06 B3_v07 B3_v08 B3_v09 B3_v10 B3_v11 B3_v12 B3_v13 B3_v14 B3_v15 NSS NSC MLT; loc item B3_v09 B3_v10 B3_v11 B3_v12 B3_v13 B3_v14 B3_v15; foreach x in `item' {; replace `x'=`x'/1000; }; label variable ID "ID number"; label variable state "State" ; label variable B1_v00 "Round and Centre code"; label variable B1_v01 "LOT/FSU number"; label variable B1_v02 "Round"; label variable B1_v03 "Schedule Number"; label variable B1_v04 "Sample"; label variable B1_v05 "Sector"; label variable B1_v06 "State-Region"; label variable B1_v07 "District"; label variable B1_v08 "Stratum Number"; label variable B1_v09 "Sub-Stratum"; label variable B1_v20 "Schedule type"; label variable B1_v10 "Sub-Round"; label variable B1_v11 "Sub-Sample"; label variable B1_v12 "FOD Sub-Region"; label variable B1_v13 "Hamlet-Group/Sub-Block no."; label variable B1_v14 "Second Stage Stratum"; label variable B1_v15 "HHS No."; label variable Level "Level"; label variable B3_v01 "HH Size"; label variable B3_v02 "NIC-2008 Code(5-digit)"; label variable B3_v03 "NCO-2004 Code(3-digit)"; label variable B3_v04 "HH type"; label variable B3_v04a "HH type (Sector-wise)"; label variable B3_v05 "Religion"; label variable B3_v06 "Social Group"; label variable B3_v07 "Whether owns any land?"; label variable B3_v08 "Type of land owned"; label variable B3_v09 "Land-Owned (0.000 hectares)"; label variable B3_v10 "Land- Leased-in (0.000 hectares)"; label variable B3_v11 "Otherwise possessed (neither owned nor leased-in) (0.000 hectares)"; label variable B3_v12 "Land-Leased-out (0.000 hectares)"; label variable B3_v13 "Land-Total possessed (0.000 hectares)"; label variable B3_v14 "During July10-June-11--Cultivated (0.000 hectares)"; label variable B3_v15 "During July10-June-11--Irrigated (0.000 hectares)"; label variable NSS "NSS"; label variable NSC "NSC"; label variable MLT "MLT"; label variable hhwt "Weighting coefficient" ; la def B3_v04a 11 "self-employed in agriculture" 12 "self-employed in non-agriculture" 13 "regular wage/salary earning" 14 "casual labour in agriculture" 15 "casual labour in non-agriculture" 19 "others" 21 "self-employed" 22 "regular wage/salary earning" 23 "casual labour" 29 "others"; la def B3_v05 1 "Hinduism" 2 "Islam" 3 "Christianity" 4 "Sikhism" 5 "Jainism" 6 "Buddhism" 7 "Zoroastrianism" 9 "Others"; la def B3_v06 1 "Scheduled Tribes" 2 "Scheduled Castes" 3 "Other Backward Classes" 9 "Others"; la def B3_v08 1 "homestead only" 2 "homestead and other land" 3 "other land only"; label values state state; label values B1_v04 sample; label values B1_v05 sector; label values B3_v04a B3_v04a; label values B3_v05 B3_v05; label values B3_v06 B3_v06; label values B3_v07 yesno; label values B3_v08 B3_v08; sort ID; save "$pathout\NSS68_Sch1-T1_bk_3", replace; ***************************************************************; * SCHEDULE 1.0 - LEVEL 3 (Block 3) ; ***************************************************************; drop _all; infix str B1_v00 1 - 3 str B1_v01 4 - 8 str B1_v02 9 - 10 str B1_v03 11 - 13 str B1_v04 14 - 14 str B1_v05 15 - 15 str B1_v06 16 - 18 str B1_v07 19 - 20 str B1_v08 21 - 22 str B1_v09 23 - 24 str B1_v20 25 - 25 str B1_v10 26 - 26 str B1_v11 27 - 27 str B1_v12 28 - 31 str B1_v13 32 - 32 str B1_v14 33 - 33 str B1_v15 34 - 35 str Level 36 - 37 str B3_v16 43 - 44 str B3_v17 45 - 45 str B3_v18 46 - 46 str B3_v19 47 - 47 str B3_v20 48 - 48 str B3_v21 49 - 52 str B3_v22 53 - 53 str B3_v23 54 - 54 str B3_v24 55 - 63 str B3_v25 64 - 72 str NSS 127 - 129 str NSC 130 - 132 str MLT 133 - 142 using "$pathin\R6801T1L03.TXT"; gen state=substr(B1_v06,1,2); compress; gen ID= B1_v01+B1_v13+B1_v14+B1_v15; isid ID; destring *, replace; format ID %12.0g; keep ID B3_v16 B3_v17 B3_v18 B3_v19 B3_v20 B3_v21 B3_v22 B3_v23 B3_v24 B3_v25; loc item B3_v24 B3_v25; foreach x in `item' {; replace `x'=`x'/100; }; label variable B3_v16 "Cooking code"; label variable B3_v17 "Lighting code"; label variable B3_v18 "Dwelling unit code"; label variable B3_v19 "Regular salary earner?"; label variable B3_v20 "Perform Ceremony?"; label variable B3_v21 "Meals seved to non-hhld members"; label variable B3_v22 "Possess ration card?"; label variable B3_v23 "Type of ration card"; label variable B3_v24 "MPCE(Rs. 0.00) - URP"; label variable B3_v25 "MPCE(Rs. 0.00) - MRP"; la def B3_v16 1 "coke, coal" 2 "firewood and chips" 3 "LPG" 4 "gobar gas" 5 "dung cake"; la def B3_v17 1 "kerosene" 2 "other oil" 3 "gas" 4 "candle" 5 "electricity" 9 "others" 6 "no lighting arrangement"; la def B3_v18 1 "owned" 2 "hired" 3 "no dwelling unit" 9 "others"; la def B3_v23 1 "Antyodaya" 2 "BPL" 3 "Others"; label values B3_v19 B3_v20 B3_v22 yesno; label values B3_v16 B3_v16; label values B3_v17 B3_v17; label values B3_v18 B3_v18; label values B3_v23 B3_v23; sort ID; merge ID using "$pathout\NSS68_Sch1-T1_bk_3"; drop _merge; order ID state B1_v00 B1_v01 B1_v02 B1_v03 B1_v04 B1_v05 B1_v06 B1_v07 B1_v08 B1_v09 B1_v10 B1_v11 B1_v12 B1_v13 B1_v14 B1_v15 B1_v20 Level B3_v01 B3_v02 B3_v03 B3_v04 B3_v04a B3_v05 B3_v06 B3_v07 B3_v08 B3_v09 B3_v10 B3_v11 B3_v12 B3_v13 B3_v14 B3_v15 B3_v16 B3_v17 B3_v18 B3_v19 B3_v20 B3_v21 B3_v22 B3_v23 B3_v24 B3_v25 NSS NSC MLT; compress; label variable ID "ID number"; sort ID; save "$pathout\NSS68_Sch1-T1_bk_3", replace; ***************************************************************; * SCHEDULE 1.0 - LEVEL 4 (Block 4) ; ***************************************************************; drop _all; infix str B1_v00 1 - 3 str B1_v01 4 - 8 str B1_v02 9 - 10 str B1_v03 11 - 13 str B1_v04 14 - 14 str B1_v05 15 - 15 str B1_v06 16 - 18 str B1_v07 19 - 20 str B1_v08 21 - 22 str B1_v09 23 - 24 str B1_v20 25 - 25 str B1_v10 26 - 26 str B1_v11 27 - 27 str B1_v12 28 - 31 str B1_v13 32 - 32 str B1_v14 33 - 33 str B1_v15 34 - 35 str Level 36 - 37 str B4_v01 41 - 42 str B4_v03 43 - 43 str B4_v04 44 - 44 str B4_v05 45 - 47 str B4_v06 48 - 48 str B4_v07 49 - 50 str B4_v08 51 - 52 str B4_v09 53 - 53 str B4_v10 54 - 55 str B4_v11 56 - 57 str B4_v12 58 - 59 str B4_v13 60 - 61 str B4_v14 62 - 63 str NSS 127 - 129 str NSC 130 - 132 str MLT 133 - 142 using "$pathin\R6801T1L04.TXT"; gen state=substr(B1_v06,1,2); compress; gen ID= B1_v01+B1_v13+B1_v14+B1_v15; isid ID B4_v01; destring *, replace; format ID %12.0g; order ID state B1_v00 B1_v01 B1_v02 B1_v03 B1_v04 B1_v05 B1_v06 B1_v07 B1_v08 B1_v09 B1_v10 B1_v11 B1_v12 B1_v13 B1_v14 B1_v15 B1_v20 Level B4_v01 B4_v03 B4_v04 B4_v05 B4_v06 B4_v07 B4_v08 B4_v09 B4_v10 B4_v11 B4_v12 B4_v13 B4_v14 NSS NSC MLT; gen hhwt=MLT/100 if NSS==NSC; replace hhwt=MLT/200 if NSS!=NSC; label variable ID "ID number"; label variable state "State" ; label variable B1_v00 "Round and Centre code"; label variable B1_v01 "LOT/FSU number"; label variable B1_v02 "Round"; label variable B1_v03 "Schedule Number"; label variable B1_v04 "Sample"; label variable B1_v05 "Sector"; label variable B1_v06 "State-Region"; label variable B1_v07 "District"; label variable B1_v08 "Stratum Number"; label variable B1_v09 "Sub-Stratum"; label variable B1_v20 "Schedule type"; label variable B1_v10 "Sub-Round"; label variable B1_v11 "Sub-Sample"; label variable B1_v12 "FOD Sub-Region"; label variable B1_v13 "Hamlet-Group/Sub-Block no."; label variable B1_v14 "Second Stage Stratum"; label variable B1_v15 "HHS No."; label variable Level "Level"; label variable B4_v01 "Person Srl No."; label variable B4_v03 "Relation"; label variable B4_v04 "Sex"; label variable B4_v05 "Age"; label variable B4_v06 "Marital Status"; label variable B4_v07 "Education"; label variable B4_v08 "Days Stayed away"; label variable B4_v09 "No. of Meals per day"; label variable B4_v10 "Meals (School)"; label variable B4_v11 "Meals (Employer)"; label variable B4_v12 "Meals (Others)"; label variable B4_v13 "Meals (Payment)"; label variable B4_v14 "Meals (At Home)"; label variable NSS "NSS"; label variable NSC "NSC"; label variable MLT "MLT"; label variable hhwt "Weighting coefficient"; la def B4_v03 1 "self" 2 "spouse of head" 3 "married child" 4 "spouse of married child" 5 "unmarried child" 6 "grandchild" 7 "father/mother/father-in-law/mother-in-law" 8 "brother/sister/brother-in-law/sister-in-law/other relatives" 9 "servant/employees/other non-relatives"; la def B4_v04 1 "male" 2 "female"; la def B4_v06 1 "never married" 2 "currently married" 3 "widowed" 4 "divorced/separated"; la def B4_v07 1 "not literate" 2 "literate without formal schooling through EGS/NFEC/AEC" 3 "literate without formal schooling through TLC" 4 "literate without formal schooling others" 5 "literate with formal schooling - below primary" 6 "literate with formal schooling - primary" 7 "literate with formal schooling - middle" 8 "literate with formal schooling - secondary" 10 "literate with formal schooling - higher secondary" 11 "literate with formal schooling - diploma/certificate course" 12 "literate with formal schooling - graduate" 13 "literate with formal schooling - postgraduate and above"; label values state state; label values B1_v04 sample; label values B1_v05 sector; label values B4_v03 B4_v03; label values B4_v04 B4_v04; label values B4_v06 B4_v06; label values B4_v07 B4_v07; sort ID B4_v01; save "$pathout\NSS68_Sch1-T1_bk_4", replace; ***************************************************************; * SCHEDULE 1.0 - LEVEL 5 (Blocks 5 & 6) ; ***************************************************************; drop _all; infix str B1_v00 1 - 3 str B1_v01 4 - 8 str B1_v02 9 - 10 str B1_v03 11 - 13 str B1_v04 14 - 14 str B1_v05 15 - 15 str B1_v06 16 - 18 str B1_v07 19 - 20 str B1_v08 21 - 22 str B1_v09 23 - 24 str B1_v20 25 - 25 str B1_v10 26 - 26 str B1_v11 27 - 27 str B1_v12 28 - 31 str B1_v13 32 - 32 str B1_v14 33 - 33 str B1_v15 34 - 35 str Level 36 - 37 str B5_v02 40 - 42 str B5_v03 43 - 51 str B5_v04 52 - 59 str B5_v05 60 - 68 str B5_v06 69 - 76 str B5_v07 77 - 77 str NSS 127 - 129 str NSC 130 - 132 str MLT 133 - 142 using "$pathin\R6801T1L05.TXT"; gen state=substr(B1_v06,1,2); compress; gen ID= B1_v01+B1_v13+B1_v14+B1_v15; isid ID B5_v02; destring *, replace; format ID %12.0g; order ID state B1_v00 B1_v01 B1_v02 B1_v03 B1_v04 B1_v05 B1_v06 B1_v07 B1_v08 B1_v09 B1_v10 B1_v11 B1_v12 B1_v13 B1_v14 B1_v15 B1_v20 Level B5_v02 B5_v03 B5_v04 B5_v05 B5_v06 B5_v07 NSS NSC MLT; gen hhwt=MLT/100 if NSS==NSC; replace hhwt=MLT/200 if NSS!=NSC; loc item B5_v03 B5_v05; foreach x in `item' {; replace `x'=`x'/1000; }; foreach x in `item' {; replace `x'=`x'*1000 if inlist(B5_v02,190,216,220,223,224,225,228,280,281,282,325,329,332,336,341); replace `x'=`x'*1000 if inrange(B5_v02,250,273); replace `x'=`x'*1000 if inrange(B5_v02,293,320); }; label variable ID "ID number"; label variable state "State" ; label variable B1_v00 "Round and Centre code"; label variable B1_v01 "LOT/FSU number"; label variable B1_v02 "Round"; label variable B1_v03 "Schedule Number"; label variable B1_v04 "Sample"; label variable B1_v05 "Sector"; label variable B1_v06 "State-Region"; label variable B1_v07 "District"; label variable B1_v08 "Stratum Number"; label variable B1_v09 "Sub-Stratum"; label variable B1_v20 "Schedule type"; label variable B1_v10 "Sub-Round"; label variable B1_v11 "Sub-Sample"; label variable B1_v12 "FOD Sub-Region"; label variable B1_v13 "Hamlet-Group/Sub-Block no."; label variable B1_v14 "Second Stage Stratum"; label variable B1_v15 "HHS No."; label variable Level "Level"; label variable B5_v02 "Item Code"; label variable B5_v03 "Home-Produce--Quantity"; label variable B5_v04 "Home-Produce--Value"; label variable B5_v05 "Total Consumption--Quantity"; label variable B5_v06 "Total Consumption--Value"; label variable B5_v07 "Source Code"; label variable NSS "NSS"; label variable NSC "NSC"; label variable MLT "MLT"; label variable hhwt "Weighting coefficient"; la def B5_v02 101 "rice – PDS" 102 "rice – other sources" 103 "chira" 104 "khoi, lawa" 105 "muri" 106 "other rice products" 107 "wheat/ atta – PDS" 108 "wheat/ atta – other sources" 110 "maida" 111 "suji, rawa" 112 "sewai, noodles " 113 "bread (bakery)" 114 "other wheat products" 115 "jowar & its products" 116 "bajra & its products" 117 "maize & products" 118 "barley & its products " 120 "small millets & their products" 121 "ragi & its products" 122 "other cereals" 129 "cereal: sub-total (101-122)" 139 "cereal substitutes: tapioca, etc" 140 "arhar, tur" 141 "gram: split" 142 "gram: whole" 143 "moong" 144 "masur" 145 "urd" 146 "peas" 147 "khesari" 148 "other pulses" 150 "gram products" 151 "besan" 152 "other pulse products" 159 "pulses & pulse products: s.t. (140-152)" 160 "milk: liquid (litre)" 161 "baby food" 162 "milk: condensed/ powder" 163 "curd" 164 "ghee" 165 "butter" 166 "ice-cream" 167 "other milk products" 169 "milk & milk products: s.t.(160-167)" 170 "salt" 171 "sugar - PDS" 172 "sugar - other sources" 173 "gur" 174 "candy, misri" 175 "honey" 179 "salt & sugar: s.t. (170-175)" 180 "vanaspati, margarine" 181 "mustard oil" 182 "groundnut oil" 183 "coconut oil" 184 "refined oil [sunflower, soyabean, saffola, etc.]" 185 "edible oil: others" 189 "edible oil: s.t. (180-185)" 190 "eggs (no.)" 191 "fish, prawn" 192 "goat meat/mutton" 193 "beef/ buffalo meat " 194 "pork" 195 "chicken" 196 "others: birds, crab, oyster, tortoise, etc." 199 "egg, fish & meat: s.t. (190-196)" 200 "potato" 201 "onion" 202 "tomato" 203 "brinjal" 204 "radish" 205 "carrot" 206 "palak/other leafy vegetables" 207 "green chillies" 208 "lady's finger" 210 "parwal/patal, kundru" 211 "cauliflower" 212 "cabbage" 213 "gourd, pumpkin" 214 "peas" 215 "beans, barbati" 216 "lemon (no.)" 217 "other vegetables " 219 "vegetables: s.t. (200-217)" 220 "banana (no.)" 221 "jackfruit" 222 "watermelon" 223 "pineapple (no.)" 224 "coconut (no.)" 225 "green coconut (no.)" 226 "guava" 227 "singara" 228 "orange, mausami (no.)" 230 "papaya" 231 "mango" 232 "kharbooza" 233 "pears/nashpati" 234 "berries" 235 "leechi" 236 "apple" 237 "grapes" 238 "other fresh fruits" 239 "fruits (fresh): s.t. (220-238)" 240 "coconut: copra" 241 "groundnut" 242 "dates" 243 "cashewnut" 244 "walnut" 245 "other nuts" 246 "raisin, kishmish, monacca, etc." 247 "other dry fruits" 249 "fruits (dry): s.t. (240-247)" 250 "ginger (gm)" 251 "garlic (gm)" 252 "jeera (gm)" 253 "dhania (gm)" 254 "turmeric (gm)" 255 "black pepper (gm)" 256 "dry chillies (gm)" 257 "tamarind (gm)" 258 "curry powder (gm)" 260 "oilseeds (gm)" 261 "other spices (gm)" 269 "spices: s.t. (250-261)" 270 "tea: cups (no.)" 271 "tea: leaf (gm)" 272 "coffee: cups (no.)" 273 "coffee: powder (gm)" 274 "mineral water (litre)" 275 "cold beverages: bottled/canned (litre)" 276 "fruit juice and shake (litre)" 277 "other beverages: cocoa, chocolate, etc." 279 "beverages: sub-total (270-277)" 280 "cooked meals purchased (no.)" 281 "cooked meals received free in workplace? (no.)" 282 "cooked meals received as assistance (no.)" 283 "cooked snacks purchased [samosa, puri, paratha, burger, chowmein, idli, dosa, vada, chops, pakoras, pao bhaji, etc.]" 284 "other served processed food" 289 "served processed food: sub-total(280-284)" 290 "prepared sweets, cake, pastry " 291 "biscuits, chocolates, etc. " 292 "papad, bhujia, namkeen, mixture, chanachur" 293 "chips (gm)" 294 "pickles (gm)" 295 "sauce, jam, jelly (gm)" 296 "other packaged processed food " 299 "packaged processed food: sub-total(290-296)" 300 "pan: leaf (no.)" 301 "pan: finished (no.)" 302 "ingredients for pan (gm)" 309 "pan: s.t. (300-302)" 310 "bidi (no.)" 311 "cigarettes (no.)" 312 "leaf tobacco (gm)" 313 "snuff (gm)" 314 "hookah tobacco (gm)" 315 "cheroot (no.)" 316 "zarda, kimam, surti (gm)" 317 "other tobacco products " 319 "tobacco: s.t. (310-317)" 320 "ganja (gm)" 321 "toddy (litre)" 322 "country liquor (litre)" 323 "beer (litre)" 324 "foreign/refined liquor or wine (litre)" 325 "other intoxicants " 329 "intoxicants: s.t. (320-325)" 330 "coke " 331 "firewood and chips " 332 "electricity (std. unit)" 333 "dung cake " 334 "kerosene – PDS (litre)" 335 "kerosene – other sources (litre)" 336 "matches (box)" 337 "coal" 338 "LPG [excl. conveyance]" 340 "charcoal " 341 "candle (no.)" 342 "gobar gas " 343 "petrol (litre) [excl. conveyance]" 344 "diesel (litre) [excl. conveyance]" 345 "other fuel " 349 "fuel and light: s.t. (330-345)"; la def B5_v07 1 "only purchase" 2 "only home-grown stock" 3 "both purchase and home-grown stock" 4 "only free collection" 5 "only exchange of goods and services" 6 "only gifts/charities" 9 "others"; label values state state; label values B1_v04 sample; label values B1_v05 sector; label values B5_v02 B5_v02; label values B5_v07 B5_v07; sort ID B5_v02; save "$pathout\NSS68_Sch1-T1_bk_5_6", replace; ***************************************************************; * SCHEDULE 1.0 - LEVEL 6 (Blocks 7 & 8) ; ***************************************************************; drop _all; infix str B1_v00 1 - 3 str B1_v01 4 - 8 str B1_v02 9 - 10 str B1_v03 11 - 13 str B1_v04 14 - 14 str B1_v05 15 - 15 str B1_v06 16 - 18 str B1_v07 19 - 20 str B1_v08 21 - 22 str B1_v09 23 - 24 str B1_v20 25 - 25 str B1_v10 26 - 26 str B1_v11 27 - 27 str B1_v12 28 - 31 str B1_v13 32 - 32 str B1_v14 33 - 33 str B1_v15 34 - 35 str Level 36 - 37 str B7_v02 40 - 42 str B7_v03 43 - 51 str B7_v04 52 - 59 str B7_v05 60 - 68 str B7_v06 69 - 76 str NSS 127 - 129 str NSC 130 - 132 str MLT 133 - 142 using "$pathin\R6801T1L06.TXT"; gen state=substr(B1_v06,1,2); compress; gen ID= B1_v01+B1_v13+B1_v14+B1_v15; isid ID B7_v02; destring *, replace; format ID %12.0g; order ID state B1_v00 B1_v01 B1_v02 B1_v03 B1_v04 B1_v05 B1_v06 B1_v07 B1_v08 B1_v09 B1_v10 B1_v11 B1_v12 B1_v13 B1_v14 B1_v15 B1_v20 Level B7_v02 B7_v03 B7_v04 B7_v05 B7_v06 NSS NSC MLT; gen hhwt=MLT/100 if NSS==NSC; replace hhwt=MLT/200 if NSS!=NSC; loc item B7_v03 B7_v05; foreach x in `item' {; replace `x'=`x'/1000 if inlist(B7_v02,352,353,383); }; label variable ID "ID number"; label variable state "State" ; label variable B1_v00 "Round and Centre code"; label variable B1_v01 "LOT/FSU number"; label variable B1_v02 "Round"; label variable B1_v03 "Schedule Number"; label variable B1_v04 "Sample"; label variable B1_v05 "Sector"; label variable B1_v06 "State-Region"; label variable B1_v07 "District"; label variable B1_v08 "Stratum Number"; label variable B1_v09 "Sub-Stratum"; label variable B1_v20 "Schedule type"; label variable B1_v10 "Sub-Round"; label variable B1_v11 "Sub-Sample"; label variable B1_v12 "FOD Sub-Region"; label variable B1_v13 "Hamlet-Group/Sub-Block no."; label variable B1_v14 "Second Stage Stratum"; label variable B1_v15 "HHS No."; label variable Level "Level"; label variable B7_v02 "Item Code"; label variable B7_v03 "Last 30 days--Quantity/ no. of pairs"; label variable B7_v04 "Last 30 days--Value"; label variable B7_v05 "Last 365 days--Quantity/ no. of pairs"; label variable B7_v06 "Last 365 days--Value"; label variable NSS "NSS"; label variable NSC "NSC"; label variable MLT "MLT"; label variable hhwt "Weighting coefficient"; la def B7_v02 350 "dhoti (no.)" 351 "saree (no.)" 352 "cloth for shirt, pyjama, kurta, salwar, etc.(metre)" 353 "cloth for coat, trousers, suit, etc. (metre)" 354 "coat, jacket, sweater, windcheater (no.)" 355 "shawl, chaddar (no.)" 356 "school/college uniform: boys " 357 "school/college uniform: girls " 358 "kurta-pajama suits: males (no.)" 360 "kurta-pajama suits: females (no.)" 361 "kurta, kameez (no.)" 362 "pajamas, salwar (no.)" 363 "shirts, T-shirts (no.)" 364 "shorts, trousers, bermudas (no.)" 365 "frocks, skirts, etc. (no.)" 366 "blouse, dupatta, scarf, muffler (no.)" 367 "lungi (no.)" 368 "other casual wear" 370 "baniyan, socks, other hosiery and" 371 "undergarments, etc. (no.)" 372 "gamchha, towel, handkerchief (no.)" 373 "infant clothing " 374 "headwear, belts, ties (no.)" 375 "knitting wool (gm)" 376 "clothing (first-hand): other " 377 "clothing: second-hand " 379 "clothing: sub-total (350-376)" 380 "bed sheet, bed cover (no.)" 381 "rug, blanket (no.)" 382 "pillow, quilt, mattress (no.)" 383 "cloth for upholstery, curtains, tablecloth, etc. (metre)" 384 "mosquito net (no.)" 385 "bedding: others " 389 "bedding, etc.: s.t. (380-385)" 390 "leather boots, shoes" 391 "leather sandals, chappals, etc." 392 "other leather footwear" 393 "rubber / PVC footwear" 394 "other footwear" 395 "footwear: second-hand" 399 "footwear: sub-total (390-395)"; label values state state; label values B1_v04 sample; label values B1_v05 sector; label values B7_v02 B7_v02; sort ID B7_v02; save "$pathout\NSS68_Sch1-T1_bk_7_8", replace; ***************************************************************; * SCHEDULE 1.0 - LEVEL 7 (Block 9) ; ***************************************************************; drop _all; infix str B1_v00 1 - 3 str B1_v01 4 - 8 str B1_v02 9 - 10 str B1_v03 11 - 13 str B1_v04 14 - 14 str B1_v05 15 - 15 str B1_v06 16 - 18 str B1_v07 19 - 20 str B1_v08 21 - 22 str B1_v09 23 - 24 str B1_v20 25 - 25 str B1_v10 26 - 26 str B1_v11 27 - 27 str B1_v12 28 - 31 str B1_v13 32 - 32 str B1_v14 33 - 33 str B1_v15 34 - 35 str Level 36 - 37 str B9_v02 40 - 42 str B9_v03 43 - 50 str B9_v04 51 - 58 str NSS 127 - 129 str NSC 130 - 132 str MLT 133 - 142 using "$pathin\R6801T1L07.TXT"; gen state=substr(B1_v06,1,2); compress; gen ID= B1_v01+B1_v13+B1_v14+B1_v15; isid ID B9_v02; destring *, replace; format ID %12.0g; order ID state B1_v00 B1_v01 B1_v02 B1_v03 B1_v04 B1_v05 B1_v06 B1_v07 B1_v08 B1_v09 B1_v10 B1_v11 B1_v12 B1_v13 B1_v14 B1_v15 B1_v20 Level B9_v02 B9_v03 B9_v04 NSS NSC MLT; gen hhwt=MLT/100 if NSS==NSC; replace hhwt=MLT/200 if NSS!=NSC; label variable ID "ID number"; label variable state "State" ; label variable B1_v00 "Round and Centre code"; label variable B1_v01 "LOT/FSU number"; label variable B1_v02 "Round"; label variable B1_v03 "Schedule Number"; label variable B1_v04 "Sample"; label variable B1_v05 "Sector"; label variable B1_v06 "State-Region"; label variable B1_v07 "District"; label variable B1_v08 "Stratum Number"; label variable B1_v09 "Sub-Stratum"; label variable B1_v20 "Schedule type"; label variable B1_v10 "Sub-Round"; label variable B1_v11 "Sub-Sample"; label variable B1_v12 "FOD Sub-Region"; label variable B1_v13 "Hamlet-Group/Sub-Block no."; label variable B1_v14 "Second Stage Stratum"; label variable B1_v15 "HHS No."; label variable Level "Level"; label variable B9_v02 "Item Code "; label variable B9_v03 "Last 30 days--Value"; label variable B9_v04 "Last 365 days--Value"; label variable NSS "NSS"; label variable NSC "NSC"; label variable MLT "MLT"; label variable hhwt "Weighting coefficient"; la def B9_v02 400 "books, journals: first hand" 401 "books, journals, etc.: second hand" 402 "newspapers, periodicals" 403 "library charges" 404 "stationery, photocopying charges" 405 "tuition and other fees (school, college, etc.)" 406 "private tutor/ coaching centre " 407 "educational CD " 408 "other educational expenses (incl. fees for enrollment in web-based training)" 409 "education: s.t. (400-408)" 410 "medicine" 411 "X-ray, ECG, pathological test, etc." 412 "doctor’s/surgeon’s fee" 413 "hospital & nursing home charges" 414 "other medical expenses " 419 "medical – institutional: s.t. (410-414)"; label values state state; label values B1_v04 sample; label values B1_v05 sector; label values B9_v02 B9_v02; sort ID B9_v02; save "$pathout\NSS68_Sch1-T1_bk_9", replace; ***************************************************************; * SCHEDULE 1.0 - LEVEL 8 (Block 10) ; ***************************************************************; drop _all; infix str B1_v00 1 - 3 str B1_v01 4 - 8 str B1_v02 9 - 10 str B1_v03 11 - 13 str B1_v04 14 - 14 str B1_v05 15 - 15 str B1_v06 16 - 18 str B1_v07 19 - 20 str B1_v08 21 - 22 str B1_v09 23 - 24 str B1_v20 25 - 25 str B1_v10 26 - 26 str B1_v11 27 - 27 str B1_v12 28 - 31 str B1_v13 32 - 32 str B1_v14 33 - 33 str B1_v15 34 - 35 str Level 36 - 37 str B10_v02 40 - 42 str B10_v03 43 - 50 str NSS 127 - 129 str NSC 130 - 132 str MLT 133 - 142 using "$pathin\R6801T1L08.TXT"; gen state=substr(B1_v06,1,2); compress; gen ID= B1_v01+B1_v13+B1_v14+B1_v15; isid ID B10_v02; destring *, replace; format ID %12.0g; order ID state B1_v00 B1_v01 B1_v02 B1_v03 B1_v04 B1_v05 B1_v06 B1_v07 B1_v08 B1_v09 B1_v10 B1_v11 B1_v12 B1_v13 B1_v14 B1_v15 B1_v20 Level B10_v02 B10_v03 NSS NSC MLT; gen hhwt=MLT/100 if NSS==NSC; replace hhwt=MLT/200 if NSS!=NSC; label variable ID "ID number"; label variable state "State" ; label variable B1_v00 "Round and Centre code"; label variable B1_v01 "LOT/FSU number"; label variable B1_v02 "Round"; label variable B1_v03 "Schedule Number"; label variable B1_v04 "Sample"; label variable B1_v05 "Sector"; label variable B1_v06 "State-Region"; label variable B1_v07 "District"; label variable B1_v08 "Stratum Number"; label variable B1_v09 "Sub-Stratum"; label variable B1_v20 "Schedule type"; label variable B1_v10 "Sub-Round"; label variable B1_v11 "Sub-Sample"; label variable B1_v12 "FOD Sub-Region"; label variable B1_v13 "Hamlet-Group/Sub-Block no."; label variable B1_v14 "Second Stage Stratum"; label variable B1_v15 "HHS No."; label variable Level "Level"; label variable B10_v02 "Item Code "; label variable B10_v03 "Value"; label variable NSS "NSS"; label variable NSC "NSC"; label variable MLT "MLT"; label variable hhwt "Weighting coefficient"; la def B10_v02 420 "medicine " 421 "X-ray, ECG, pathological test, etc. " 422 "doctor’s/ surgeon’s fee " 423 "family planning devices " 424 "other medical expenses " 429 "medical – non-institutional: sub-total (420-424)" 430 "cinema, theatre " 431 "mela, fair, picnic " 432 "sports goods, toys, etc. " 433 "club fees " 434 "goods for recreation and hobbies " 435 "photography " 436 "VCD/ DVD hire (incl. instrument) " 437 "cable TV " 438 "other entertainment " 439 "entertainment: sub-total (430-438)" 440 "spectacles " 441 "torch " 442 "lock " 443 "umbrella, raincoat " 444 "lighter (bidi/ cigarette/ gas stove) " 445 "other minor durable-type goods " 449 "minor durable-type goods: sub-total (440-445)" 450 "toilet soap" 451 "toothpaste, toothbrush, comb, etc." 452 "powder, snow, cream, lotion and perfume" 453 "hair oil, shampoo, hair cream" 454 "shaving blades, shaving stick, razor" 455 "shaving cream, aftershave lotion" 456 "sanitary napkins " 457 "other toilet articles" 459 "toilet articles: sub-total (450-457)" 460 "electric bulb, tubelight" 461 "electric batteries" 462 "other non-durable electric goods" 463 "earthenware" 464 "glassware" 465 "bucket, water bottle/ feeding bottle & other plastic goods" 466 "coir, rope, etc." 467 "washing soap/soda/powder" 468 "other washing requisites" 470 "incense (agarbatti), room freshener" 471 "flower (fresh): all purposes" 472 "mosquito repellent, insecticide, acid etc." 473 "other petty articles" 479 "other household consumables: sub-total (460-473)" 480 "domestic servant/cook " 481 "attendant " 482 "sweeper " 483 "barber, beautician, etc. " 484 "washerman, laundry, ironing " 485 "tailor " 486 "grinding charges " 487 "telephone charges: landline" 488 "telephone charges: mobile " 490 "postage & telegram " 491 "miscellaneous expenses " 492 "priest " 493 "legal expenses " 494 "repair charges for non-durables " 495 "pet animals (incl. birds, fish) " 496 "internet expenses " 497 "other consumer services excluding conveyance" 499 "consumer services excluding conveyance: sub-total (480-497)" 500 "air fare" 501 "railway fare" 502 "bus/tram fare" 503 "taxi, auto-rickshaw fare" 504 "steamer, boat fare" 505 "rickshaw (hand drawn & cycle) fare" 506 "horse cart fare" 507 "porter charges" 508 "petrol for vehicle" 510 "diesel for vehicle" 511 "lubricants & other fuels for vehicle" 512 "school bus, van, etc." 513 "other conveyance expenses" 519 "conveyance: sub-total (500-513)" 520 "house rent, garage rent (actual)" 521 "hotel lodging charges" 522 "residential land rent" 523 "other consumer rent" 529 "rent: sub-total (520-523)" 539 "house rent, garage rent (imputed-urban only)" 540 "water charges " 541 "other consumer taxes & cesses " 549 "consumer taxes and cesses: sub-total (540-541)"; label values state state; label values B1_v04 sample; label values B1_v05 sector; label values B10_v02 B10_v02; sort ID B10_v02; save "$pathout\NSS68_Sch1-T1_bk_10", replace; ***************************************************************; * SCHEDULE 1.0 - LEVEL 9 (Block 11) ; ***************************************************************; drop _all; infix str B1_v00 1 - 3 str B1_v01 4 - 8 str B1_v02 9 - 10 str B1_v03 11 - 13 str B1_v04 14 - 14 str B1_v05 15 - 15 str B1_v06 16 - 18 str B1_v07 19 - 20 str B1_v08 21 - 22 str B1_v09 23 - 24 str B1_v20 25 - 25 str B1_v10 26 - 26 str B1_v11 27 - 27 str B1_v12 28 - 31 str B1_v13 32 - 32 str B1_v14 33 - 33 str B1_v15 34 - 35 str Level 36 - 37 str B11_v02 40 - 42 str B11_v03 43 - 43 str B11_v04 44 - 46 str B11_v05 47 - 47 str B11_v06 48 - 55 str B11_v07 56 - 63 str B11_v08 64 - 71 str B11_v09 72 - 79 str B11_v10 80 - 82 str B11_v11 83 - 83 str B11_v12 84 - 91 str B11_v13 92 - 99 str B11_v14 100 - 102 str B11_v15 103 - 110 str B11_v16 111 - 118 str NSS 127 - 129 str NSC 130 - 132 str MLT 133 - 142 using "$pathin\R6801T1L09.TXT"; gen state=substr(B1_v06,1,2); compress; gen ID= B1_v01+B1_v13+B1_v14+B1_v15; isid ID B11_v02; destring *, replace; format ID %12.0g; order ID state B1_v00 B1_v01 B1_v02 B1_v03 B1_v04 B1_v05 B1_v06 B1_v07 B1_v08 B1_v09 B1_v10 B1_v11 B1_v12 B1_v13 B1_v14 B1_v15 B1_v20 Level B11_v02 B11_v03 B11_v04 B11_v05 B11_v06 B11_v07 B11_v08 B11_v09 B11_v10 B11_v11 B11_v12 B11_v13 B11_v14 B11_v15 B11_v16 NSS NSC MLT; gen hhwt=MLT/100 if NSS==NSC; replace hhwt=MLT/200 if NSS!=NSC; label variable ID "ID number"; label variable state "State" ; label variable B1_v00 "Round and Centre code"; label variable B1_v01 "LOT/FSU number"; label variable B1_v02 "Round"; label variable B1_v03 "Schedule Number"; label variable B1_v04 "Sample"; label variable B1_v05 "Sector"; label variable B1_v06 "State-Region"; label variable B1_v07 "District"; label variable B1_v08 "Stratum Number"; label variable B1_v09 "Sub-Stratum"; label variable B1_v20 "Schedule type"; label variable B1_v10 "Sub-Round"; label variable B1_v11 "Sub-Sample"; label variable B1_v12 "FOD Sub-Region"; label variable B1_v13 "Hamlet-Group/Sub-Block no."; label variable B1_v14 "Second Stage Stratum"; label variable B1_v15 "HHS No."; label variable Level "Level"; label variable B11_v02 "Item Code"; label variable B11_v03 "Whether possesses?"; label variable B11_v04 "First-hand purchase:number(30 days)"; label variable B11_v05 "Whether hire-purchased(30 days)"; label variable B11_v06 "First-hand purchase:Value(30 days)"; label variable B11_v07 "Cost-raw material,service & repair(30 days)"; label variable B11_v08 "Second-hand purchase:Value(30 days)"; label variable B11_v09 "Total expenditure(30 days)"; label variable B11_v10 "First-hand purchase:Number(365 days)"; label variable B11_v11 "Whether hire-purchased(365 days)"; label variable B11_v12 "First-hand purchase:Value(365 days)"; label variable B11_v13 "Cost-raw material,service & repair(365 days)"; label variable B11_v14 "2nd-hand purchase:Number(365 days)"; label variable B11_v15 "2nd-hand purchase:Value(365 days)"; label variable B11_v16 "Total expenditure(365 days)"; label variable NSS "NSS"; label variable NSC "NSC"; label variable MLT "MLT"; label variable hhwt "Weighting coefficient"; la def B11_v02 550 "bedstead" 551 "almirah, dressing table" 552 "chair, stool, bench, table" 553 "suitcase, trunk, box, handbag and other travel goods" 554 "foam, rubber cushion" 555 "carpet, daree & other floor mattings" 556 "paintings, drawings, engravings, etc." 557 "other furniture & fixtures (couch, sofa, etc.)" 559 "furniture & fixtures: sub-total (550-557)" 560 "radio, tape recorder, 2-in-1" 561 "television" 562 "VCR/VCD/DVD player" 563 "camera & photographic equipment" 564 "CD, DVD, etc" 565 "musical instruments" 566 "other goods for recreation" 569 "goods for recreation: sub-total (560-566)" 570 "stainless steel utensils" 571 "other metal utensils" 572 "casseroles, thermos, thermoware" 573 "other crockery & utensils" 579 "crockery & utensils: sub-total (570-573)" 580 "electric fan" 581 "air conditioner, air cooler" 582 "inverter" 583 "lantern, lamp, electric lampshade" 584 "sewing machine" 585 "washing machine" 586 "stove, gas burner" 587 "pressure cooker/ pressure pan" 588 "refrigerator" 590 "water purifier" 591 "electric iron, heater, toaster, oven & other electric heating appliances" 592 "other cooking/ household appliances" 599 "cooking & other household appliances: sub-total (580-592)" 600 "bicycle" 601 "motor cycle, scooter" 602 "motor car, jeep" 603 "tyres & tubes" 604 "other transport equipment" 609 "personal transport equipment: sub-total (600-604)" 610 "contact lenses, hearing aids & orthopaedic equipment" 611 "other medical equipment" 619 "therapeutic appliances: sub-total (610-611)" 620 "clock, watch" 621 "other machines for household work" 622 "PC/ Laptop/ other peripherals incl. software" 623 "mobile handset" 624 "telephone instrument (landline)" 625 "any other personal goods " 629 "other personal goods: sub-total (620-629)" 630 "bathroom and sanitary equipment" 631 "plugs, switches & other electrical fittings" 632 "residential building & land (cost of repairs only)" 633 "other durables (specify)" 639 "residential building, land and other durables: sub-total (630-633)" 640 "gold ornaments" 641 "silver ornaments" 642 "jewels, pearls" 643 "other ornaments" 649 "jewellery & ornaments: sub-total (640-643)" 659 "durable goods: total (559+569+579+599+609+619+629+639+649)"; label values state state; label values B1_v04 sample; label values B1_v05 sector; label values B11_v02 B11_v02; label values B11_v03 B11_v05 B11_v11 yesno; sort ID B11_v02; save "$pathout\NSS68_Sch1-T1_bk_11", replace; ***************************************************************; * SCHEDULE 1.0 - LEVEL 10 (Block 13) ; ***************************************************************; drop _all; infix str B1_v00 1 - 3 str B1_v01 4 - 8 str B1_v02 9 - 10 str B1_v03 11 - 13 str B1_v04 14 - 14 str B1_v05 15 - 15 str B1_v06 16 - 18 str B1_v07 19 - 20 str B1_v08 21 - 22 str B1_v09 23 - 24 str B1_v20 25 - 25 str B1_v10 26 - 26 str B1_v11 27 - 27 str B1_v12 28 - 31 str B1_v13 32 - 32 str B1_v14 33 - 33 str B1_v15 34 - 35 str Level 36 - 37 str B13_v01 43 - 43 str B13_v02 44 - 44 str B13_v03 45 - 45 str B13_v04_1 46 - 46 str B13_v04_2 47 - 47 str B13_v04_3 48 - 48 str B13_v05 49 - 49 str B13_v06 50 - 50 str B13_v07 51 - 51 str B13_v08 52 - 52 str B13_v09_1 53 - 53 str B13_v09_2 54 - 54 str B13_v10_1 55 - 55 str B13_v10_2 56 - 56 str B13_v10_3 57 - 57 str NSS 127 - 129 str NSC 130 - 132 str MLT 133 - 142 using "$pathin\R6801T1L10.TXT"; gen state=substr(B1_v06,1,2); compress; gen ID= B1_v01+B1_v13+B1_v14+B1_v15; isid ID; destring *, replace; format ID %12.0g; order ID state B1_v00 B1_v01 B1_v02 B1_v03 B1_v04 B1_v05 B1_v06 B1_v07 B1_v08 B1_v09 B1_v10 B1_v11 B1_v12 B1_v13 B1_v14 B1_v15 B1_v20 Level B13_v01 B13_v02 B13_v03 B13_v04_1 B13_v04_2 B13_v04_3 B13_v05 B13_v06 B13_v07 B13_v08 B13_v09_1 B13_v09_2 B13_v10_1 B13_v10_2 B13_v10_3 NSS NSC MLT; gen hhwt=MLT/100 if NSS==NSC; replace hhwt=MLT/200 if NSS!=NSC; label variable ID "ID number"; label variable state "State" ; label variable B1_v00 "Round and Centre code"; label variable B1_v01 "LOT/FSU number"; label variable B1_v02 "Round"; label variable B1_v03 "Schedule Number"; label variable B1_v04 "Sample"; label variable B1_v05 "Sector"; label variable B1_v06 "State-Region"; label variable B1_v07 "District"; label variable B1_v08 "Stratum Number"; label variable B1_v09 "Sub-Stratum"; label variable B1_v20 "Schedule type"; label variable B1_v10 "Sub-Round"; label variable B1_v11 "Sub-Sample"; label variable B1_v12 "FOD Sub-Region"; label variable B1_v13 "Hamlet-Group/Sub-Block no."; label variable B1_v14 "Second Stage Stratum"; label variable B1_v15 "HHS No."; label variable Level "Level"; label variable B13_v01 "Whether any member used AYUSH"; label variable B13_v02 "If no in item 1, most important reason"; label variable B13_v03 "If yes in item 1, most important reason"; label variable B13_v04_1 "System of medicines used- Indian system"; label variable B13_v04_2 "System of medicines used- Homoeopathy"; label variable B13_v04_3 "System of medicines used- Yoga & Naturopathy"; label variable B13_v05 "Where did you usually get Indian system of medicines"; label variable B13_v06 "Where did you usually get Homoeopathic medicines"; label variable B13_v07 "How often do you visit AYUSH hospital"; label variable B13_v08 "How often during your visits did you find doctors"; label variable B13_v09_1 "What is your assessment about the AYUSH medicines from hospital- on availability"; label variable B13_v09_2 "What is your assessment about the AYUSH medicines from hospital- on effectiveness"; label variable B13_v10_1 "Who advised to take- Indian system of medicine"; label variable B13_v10_2 "Who advised to take- Homoeopathy"; label variable B13_v10_3 "Who advised to take- Yoga & Naturopathy"; label variable NSS "NSS"; label variable NSC "NSC"; label variable MLT "MLT"; label variable hhwt "Weighting coefficient"; la def B13_v02 1 "Need did not arise" 2 "Not aware about any system under AYUSH" 3 "Medicines/treatments are not effective" 4 "Hospital/dispensary/PHCs/CHCs are not available" 5 "Doctors/Vaidya/Hakim/Siddh Vaidya/Homoeopaths are not available" 6 "Medicines are not available" 9 "Any other reason"; la def B13_v03 1 "AYUSH medicines are effective" 2 "Side effects are negligible" 3 "AYUSH medicines are inexpensive" 4 "Well-known to local people, family members and friends etc." 9 "Others"; la def B13_v05 1 "Home-made from home produce, free collection, etc." 2 "Home-made from purchased ingredients" 3 "Government Hospital/Dispensary/PHCs/CHCs" 4 "Private hospital/Dispensary/Private practitioners(Doctors/Vaidya/Hakim/Siddh Vaidya)" 5 "Local shops/Medical stores/Other sellers"; la def B13_v06 1 "Government hospital/dispensary/PHCs/CHCs" 2 "Private hospital/Dispensary/Private practitioners (Doctors/ Homoeopaths)" 3 "Local shops/Medical stores" 9 "Others"; la def B13_v07 1 "once" 2 "2-3 times" 3 "> 3 times" 4 "nil"; la def freqcode 1 "on every occasion" 2 "on the majority of occasions" 3 "on a few occasions (not the majority)" 4 "never"; la def B13_v10 1 "On your own" 2 "Family members & relatives" 3 "Friends & neighbours" 4 "Private practitioners (Doctor/Vaidya/Hakim/Homoeopath)" 5 "Doctors/ practitioners of Government hospital/dispensary" 6 "Media (TV,radio,hoardings,newspapers & magazines)"; label values state state; label values B1_v04 sample; label values B1_v05 sector; label values B13_v01 B13_v04_1 B13_v04_2 B13_v04_3 yesno; label values B13_v02 B13_v02; label values B13_v03 B13_v03; label values B13_v05 B13_v05; label values B13_v06 B13_v06; label values B13_v07 B13_v07; label values B13_v08 B13_v09_1 B13_v09_2 freqcode; label values B13_v10_1 B13_v10_2 B13_v10_3 B13_v10; sort ID; save "$pathout\NSS68_Sch1-T1_bk_13", replace; ***************************************************************; * SCHEDULE 1.0 - LEVEL 11 (Block 12) ; ***************************************************************; drop _all; infix str B1_v00 1 - 3 str B1_v01 4 - 8 str B1_v02 9 - 10 str B1_v03 11 - 13 str B1_v04 14 - 14 str B1_v05 15 - 15 str B1_v06 16 - 18 str B1_v07 19 - 20 str B1_v08 21 - 22 str B1_v09 23 - 24 str B1_v20 25 - 25 str B1_v10 26 - 26 str B1_v11 27 - 27 str B1_v12 28 - 31 str B1_v13 32 - 32 str B1_v14 33 - 33 str B1_v15 34 - 35 str Level 36 - 37 str B12_v01 41 - 42 str B12_v06 43 - 52 str NSS 127 - 129 str NSC 130 - 132 str MLT 133 - 142 using "$pathin\R6801T1L11.TXT"; gen state=substr(B1_v06,1,2); compress; gen ID= B1_v01+B1_v13+B1_v14+B1_v15; isid ID B12_v01; destring *, replace; format ID %12.0g; order ID state B1_v00 B1_v01 B1_v02 B1_v03 B1_v04 B1_v05 B1_v06 B1_v07 B1_v08 B1_v09 B1_v10 B1_v11 B1_v12 B1_v13 B1_v14 B1_v15 B1_v20 Level B12_v01 B12_v06 NSS NSC MLT; gen hhwt=MLT/100 if NSS==NSC; replace hhwt=MLT/200 if NSS!=NSC; replace B12_v06=B12_v06/100 if inrange(B12_v01,48,49); label variable ID "ID number"; label variable state "State" ; label variable B1_v00 "Round and Centre code"; label variable B1_v01 "LOT/FSU number"; label variable B1_v02 "Round"; label variable B1_v03 "Schedule Number"; label variable B1_v04 "Sample"; label variable B1_v05 "Sector"; label variable B1_v06 "State-Region"; label variable B1_v07 "District"; label variable B1_v08 "Stratum Number"; label variable B1_v09 "Sub-Stratum"; label variable B1_v20 "Schedule type"; label variable B1_v10 "Sub-Round"; label variable B1_v11 "Sub-Sample"; label variable B1_v12 "FOD Sub-Region"; label variable B1_v13 "Hamlet-Group/Sub-Block no."; label variable B1_v14 "Second Stage Stratum"; label variable B1_v15 "HHS No."; label variable Level "Level"; label variable B12_v01 "Srl. No."; label variable B12_v06 "Value"; label variable NSS "NSS"; label variable NSC "NSC"; label variable MLT "MLT"; label variable hhwt "Weighting coefficient"; la def B12_v01 1 "cereals" 2 "cereal substitute " 3 "pulses & products " 4 "milk & milk products " 5 "salt & sugar " 6 "edible oil" 7 "egg, fish & meat " 8 "vegetables " 9 "fruits (fresh) " 10 "fruits (dry) " 11 "spices " 12 "beverages " 13 "served processed food " 14 "packaged processed food " 15 "pan " 16 "tobacco" 17 "intoxicants " 18 "fuel and light" 19 "medical (non-institutional)" 20 "entertainment " 21 "minor durable-type goods" 22 "toilet articles" 23 "other household consumables" 24 "consumer services excl. conveyance" 25 "conveyance" 26 "rent" 27 "consumer taxes & cesses" 28 "sub-total (1 – 27)" 29 "clothing " 30 "bedding etc. " 31 "footwear " 32 "education" 33 "medical (institutional)" 34 "durable goods" 35 "sub-total (29 – 34)" 36 "clothing" 37 "bedding etc. " 38 "footwear" 39 "education" 40 "medical (institutional)" 41 "durable goods" 42 "s.t. for 365 days’ data (36 -41)" 43 "(30÷365) × srl. no. 42" 44 "srl. nos.(28 + 35) [monthly household consumption expenditure] [URP]" 45 "srl. nos.(28 + 43) [monthly household consumption expenditure] [MRP]" 46 "household size" 47 "imputed rent" 48 "monthly per capita expenditure (Rs. 0.00) [srl. no. 44 ÷ srl. no. 46] [URP]" 49 "monthly per capita expenditure (Rs. 0.00) [srl. no. 45 ÷ srl. no. 46] [MRP]"; label values state state; label values B1_v04 sample; label values B1_v05 sector; label values B12_v01 B12_v01; sort ID B12_v01; save "$pathout\NSS68_Sch1-T1_bk_12", replace;