Analysing NSSO Data
The India manufacturing sector has been divided into Organised and Un-Organised Manufacturing sector. India's organised manufacturing sector consists of units which have formally registered with governments of India. The data of these registered entities are formally collected through Annual Survey of Industries (ASI). It covers all factories registered under Sections 2m(i) and 2m(ii) of the Factories Act, 1948 i.e. those factories employing 10 or more workers using power; and those employing 20 or more workers without using power. The survey also covers bidi and cigar manufacturing establishments registered under the Bidi & Cigar Workers (Conditions of Employment) Act, 1966 with coverage as above. All electricity undertakings engaged in the generation, transmission and distribution of electricity registered with the Central Electricity Authority (CEA) were covered under ASI irrespective of their employment size (Mospi, 2016).
Un-Organised Manufacturing sector: The unorganised sector is not regulated, and little data exist for these enterprises. The unorganised sector refers to those enterprises whose activities or collection of data is not regulated under any legal provision or does not maintain any regular accounts. For instance, the units that are not registered under the Factories Act, 1948 the unorganised composition of the manufacturing sector. The data related to Un-Organised manufacturing sector is collected through National Sample Survey-Enterprise Survey or Un-organised manufacturing survey`s which are conducted every 5 years once (MSME, 2016).
This Blog will provide Comprehensive understanding on the extraction of National Sample Survey-Enterprises Level (NSSO) and Annual Survey of Industries (ASI) data set.
In this blog we will help you to generate multipliers or sample weights, data extraction, merging two different blocks of given data set and further, how this can be used for econometric analysis.Extraction of NSSO
Step 1: Understanding the Unit Level (which are provided in CD)
In this blog, we will use NSSO 67th round enterprise level data set (2010-11). In order to understand the unit level data, you should look into the folder called 'supporting documents', the contents of the folder are as below.
 |
| Supporting document folder image Extracting NSSO-enterprises level data manually |
Extracting NSSO-enterprises level data manually
The readme file in supporting documents will explain the unit level data, the readme file has been divided into two parts,
1. What it contains - number of blocks and number of observations in each block (as shown below picture)
2. Multipliers- will explain multipliers assigned to each enterprise, which is also known as sample weights (which will explain in the later posts)
Next, most important files of the supporting documents folder are schedule or questionnaire ‘Schedule_67_2.34’. This document will give you a basic idea on method of data collection and detailed information on variables which are considered for the data collection (the important suggestion is to have printed out of schedule before starting your extraction),
Block 1: identification of sample enterprise
Block 2: particulars of operation and background information
Block 2.1: activities pursued by the enterprise
Block 3: principal operating expenses
Block 4: other operating expenses
Block 5: other receipts
Block 6: calculation of gross value added
Block 7: employment particulars of the enterprise
Block 8: compensation to workers
Block 9: fixed assets owned and hired
Block 10: loan outstanding
Block 11:factor incomes of the enterprise
Block 12: particulars of use of information and communication technology
But, the most important file is ‘Layout_67_2.34.XLS’ (see below figure), this file will explain detail method to extract different blocks which are mentioned above (it is better to go thoroughly before starting your data extraction).
Step 2: Method of Extraction
We use Stata to extract our data which are given in the ‘r67s234L01.TXT’ format (Text document format) and the data related to this enterprise level is provided in “Data” folder in the unit level data CD.
Block 1: Identification of sample enterprise- Infix is code, which will read text data in fixed format.
**all these codes written below should be either copied or type it to do-file editor in Stata**
in order to extract the data for this block we have to use following codes,
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_v10 25 - 25
str B1_v11 26 - 26
str B1_v12 27 - 30
str B1_v13 31 - 31
str B1_v14 32 - 33
str B1_v15 34 - 35
str B1_v16 43 - 43
str B1_v17 44 - 44
str B1_v18 45 - 45
str B1_v19 46 - 46
NSS 127 - 129
NSC 130 - 132
MLT 133 - 142
using "r67s234L01.TXT"; (you need to provide the path were your TXT format file has been saved in the computer)
using "r67s234L01.TXT"; (you need to provide the path were your TXT format file has been saved in the computer)
gen state=substr(B1_v06,1,2); {what is substr()? it is string function}
compress;
generating identification number for each enterprise
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;
before moving on to labelling the variables, one should check for duplication of the identification number, check the number of enterprises records in a data-set count and calculate the estimated number of enterprises.
label variable ID "ID number";
label variable state "State" ;
label variable B1_v00 "Round and Centre code";
label variable B1_v01 "FSU number";
label variable B1_v02 "Round Number";
label variable B1_v03 "Schedule Number";
label variable B1_v04 "Sample";
label variable B1_v05 "Sector";
label variable B1_v06 "NSS-Region";
label variable B1_v07 "District";
label variable B1_v08 "Stratum ";
label variable B1_v09 "Sub-Stratum ";
label variable B1_v10 "Sub-Round";
label variable B1_v11 "Sub-Sample";
label variable B1_v12 "FOD Sub-Region";
label variable B1_v13 "Segment";
label variable B1_v14 "SSS";
label variable B1_v15 "Enterprise Number";
label variable B1_v16 "Response Code";
label variable B1_v17 "Informant Code";
label variable B1_v18 "Survey Code";
label variable B1_v19 "Substitution Code";
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 but responded" 4 "Informant reluctant" 9 "Others";
la def inforcod 1 "Owner" 2 "Manager" 9 "Others";
la def survcode 1 "Original enterprise surveyed" 2 "Substitute surveyed" 3 "Casualty";
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";
save "NSS67_Sch2-34_bk_1", replace; (save the file in required name (Suggested way: Block1).
Block 2: particulars of operation and background information- provide basic information on each enterprise. this block will also provide NIC code for major activity performed by the enterprise.
in order to extract the data for this block we have to use following codes,
drop _all;
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_v10 25 - 25
str B1_v11 26 - 26
str B1_v12 27 - 30
str B1_v13 31 - 31
str B1_v14 32 - 33
str B1_v15 34 - 35
str B2_v201 43 - 43
str B2_v202 44 - 48
str B2_v203 49 - 53
str B2_v204 54 - 54
str B2_v205 55 - 55
str B2_v206 56 - 56
str B2_v207 57 - 57
str B2_v208 58 - 59
str B2_v209 60 - 60
str B2_v210 61 - 61
str B2_v211 62 - 65
str B2_v212 66 - 66
str B2_v213 67 - 68
str B2_v214 69 - 70
str B2_v215 71 - 71
str B2_v216 72 - 72
str B2_v217 73 - 73
str B2_v218 74 - 75
str B2_v219 76 - 77
str B2_v220 78 - 78
str B2_v221 79 - 79
str B2_v222 80 - 80
str B2_v223 81 - 81
str B2_v224 82 - 82
str B2_v225 83 - 83
str B2_v226 84 - 84
str B2_v227 85 - 85
str B2_v228 86 - 86
str B2_v229 87 - 87
str B2_v230 88 - 89
str B2_v231 90 - 91
str B2_v232 92 - 93
str B2_v233 94 - 94
str B2_v234 95 - 95
str B2_v235 96 - 96
str B2_v236 97 - 97
str B2_v237 98 - 100
str B2_v238 101 - 101
str B2_v239 102 - 102
NSS 127 - 129
NSC 130 - 132
MLT 133 - 142
using "r67s234L02.TXT";
using "r67s234L02.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 "FSU number";
label variable B1_v02 "Round Number";
label variable B1_v03 "Schedule Number";
label variable B1_v04 "Sample";
label variable B1_v05 "Sector";
label variable B1_v06 "NSS-Region";
label variable B1_v07 "District";
label variable B1_v08 "Stratum ";
label variable B1_v09 "Sub-Stratum ";
label variable B1_v10 "Sub-Round";
label variable B1_v11 "Sub-Sample";
label variable B1_v12 "FOD Sub-Region";
label variable B1_v13 "Segment";
label variable B1_v14 "SSS";
label variable B1_v15 "Enterprise Number";
label variable B2_v201 "Was pursuing mixed activity?";
label variable B2_v202 "Major Activity NIC Code 2008";
label variable B2_v203 "NIC Code 2004-Minor Activity ";
label variable B2_v204 "Type of ownership";
label variable B2_v205 "Whether private non-profit institution?";
label variable B2_v206 "Whether NPISH";
label variable B2_v207 "Social group of owner";
label variable B2_v208 "Undertook any other economic activity?";
label variable B2_v209 "Location of enterprise";
label variable B2_v210 "Enterprise Type during last 365 days";
label variable B2_v211 "Year of initial operation";
label variable B2_v212 "Nature of operation";
label variable B2_v213 "No. of months operated-last 365 day";
label variable B2_v214 "No. of hours worked-last 30 days";
label variable B2_v215 "Whether accounts maintained?";
label variable B2_v216 "Whether cllected from books of a/c";
label variable B2_v217 "Whether problems faced last 365 day";
label variable B2_v218 "Nature of problems faced Most severe";
label variable B2_v219 "Nature of problems faced next severe";
label variable B2_v220 "Whether assistance recd last 365 day";
label variable B2_v221 "Nature of assistance recd Most imp";
label variable B2_v222 "Nature of assistance recd next imp";
label variable B2_v223 "Status of enterprise";
label variable B2_v224 "Whether regd. under any act/ authority";
label variable B2_v225 "Whether regd. under shop & Establishment";
label variable B2_v226 "Whether regd. under MC/Panchayet/Local body";
label variable B2_v227 "Whether regd. under VAT/Sales Tax";
label variable B2_v228 "Whether regd. under Provident Fund Act";
label variable B2_v229 "Whether regd. under ESI Corporaction Act";
label variable B2_v230 "Industry Specific Act/Authority (i)";
label variable B2_v231 "Industry Specific Act/Authority (ii)";
label variable B2_v232 "Industry Specific Act/Authority (iii)";
label variable B2_v233 "Marketing Agreement";
label variable B2_v234 "Supply out of procedure covered in agreement";
label variable B2_v235 "Coverage agrrement with other units";
label variable B2_v236 "Cover post agrrement input price escalation";
label variable B2_v237 "% of payments recd";
label variable B2_v238 "Whether supplying to single unit";
label variable B2_v239 "Wherther parent unit remained same";
save "NSS67_Sch2-34_bk_2", replace; (can be saved as Block 2)
Block 2.1: activities pursued by the enterprise- provides information related to activities pursued by each enterprise and each enterprise may perform one or more activities.
in order to extract the data for this block we have to use following codes,
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_v10 25 - 25
str B1_v11 26 - 26
str B1_v12 27 - 30
str B1_v13 31 - 31
str B1_v14 32 - 33
str B1_v15 34 - 35
str B2_v241 43 - 43
str B2_v242 44 - 44
str B2_v243 45 - 45
str B2_v244 46 - 46
str B2_v245 47 - 47
str B2_v246 48 - 48
str B2_v247 49 - 49
str B2_v248 50 - 50
str B2_v249 51 - 51
str B2_v250 52 - 52
str B2_v251 53 - 53
NSS 127 - 129
NSC 130 - 132
MLT 133 - 142
using "r67s234L03.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 "FSU number";
label variable B1_v02 "Round Number";
label variable B1_v03 "Schedule Number";
label variable B1_v04 "Sample";
label variable B1_v05 "Sector";
label variable B1_v06 "NSS-Region";
label variable B1_v07 "District";
label variable B1_v08 "Stratum ";
label variable B1_v09 "Sub-Stratum ";
label variable B1_v10 "Sub-Round";
label variable B1_v11 "Sub-Sample";
label variable B1_v12 "FOD Sub-Region";
label variable B1_v13 "Segment";
label variable B1_v14 "SSS";
label variable B1_v15 "Enterprise Number";
label variable B2_v241 "Whether persued-manufacturing"; (for Eg: NIC Div 08 and Div 10-33)
label variable B2_v242 "Whether persued-trading";
label variable B2_v243 "Whether persued-transport&storage";
label variable B2_v244 "Whether persued-postal&courier";
label variable B2_v245 "Whether persued-accomodation & food";
label variable B2_v246 "Whether persued-inform&communication";
label variable B2_v247 "Whether persued-financial & insurance";
label variable B2_v248 "Whether persued-real estate";
label variable B2_v249 "Whether persued-educational";
label variable B2_v250 "Whether persued-health&social work";
label variable B2_v251 "Whether persued-other activities";
save "NSS67_Sch2-34_bk_2-1", replace; (can be saved as Block 2.1)
Block 3: principal operating expenses- provides information on operating expenses such as raw materials, insurance charges, local fees, petrol & other fuels consumed etc.,
in order to extract the data for this block we have to use following codes,
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_v10 25 - 25
str B1_v11 26 - 26
str B1_v12 27 - 30
str B1_v13 31 - 31
str B1_v14 32 - 33
str B1_v15 34 - 35
str B3_v02 40 - 42
str B3_v03s 43 - 43
str B3_v03 44 - 55
NSS 127 - 129
NSC 130 - 132
MLT 133 - 142
using "r67s234L04.TXT";
gen state=substr(B1_v06,1,2);
compress;
gen ID= B1_v01+B1_v13+B1_v14+B1_v15;
isid ID B3_v02;
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 "FSU number";
label variable B1_v02 "Round Number";
label variable B1_v03 "Schedule Number";
label variable B1_v04 "Sample";
label variable B1_v05 "Sector";
label variable B1_v06 "NSS-Region";
label variable B1_v07 "District";
label variable B1_v08 "Stratum ";
label variable B1_v09 "Sub-Stratum ";
label variable B1_v10 "Sub-Round";
label variable B1_v11 "Sub-Sample";
label variable B1_v12 "FOD Sub-Region";
label variable B1_v13 "Segment";
label variable B1_v14 "SSS";
label variable B1_v15 "Enterprise Number";
label variable B3_v02 "Item Code(301-409)";
label variable B3_v03 "Value(Rs.)";
label define itmblk3
301 "Manufacturing activity - main raw materials consumed"
302 "Manufacturing activity - main raw materials consumed"
303 "Manufacturing activity - main raw materials consumed"
304 "Manufacturing activity - main raw materials consumed"
305 "Manufacturing activity - other raw materials"
306 "Manufacturing activity - purchase value of the goods sold in the same condition as purchased"
309 "Manufacturing activity - total (items 301 to 306)"
311 "Trading activity - main commodities purchased"
312 "Trading activity - main commodities purchased"
313 "Trading activity - main commodities purchased"
314 "Trading activity - main commodities purchased"
315 "Trading activity - other commodities purchased"
319 "Trading activity - total (items 311 to 315)"
321 "Transportation activities - petrol, diesel, lubricants, etc."
322 "Transportation activities - tyres , tubes, batteries etc."
323 "Transportation activities - repair and maintenance of transport equipment"
324 "Transportation activities - toll tax, octroi, local fees, insurance charges etc."
325 "Transportation activities - charges paid towards storage of goods, parking of vehicles etc."
329 "Transportation activities - total (items 321 to 325)"
331 "Warehousing and support activities for transportation - consumable stores used in the warehouse"
332 "Warehousing and support activities for transportation - insurance charges"
333 "Warehousing and support activities for transportation - expenses incurred for support activities for transportation"
339 "Warehousing and support activities for transportation - total (items 331 to 333)"
341 "Postal and courier activities - charges for stationeries, postal articles etc."
342 "Postal and courier activities - insurance charges"
343 "Postal and courier activities - others"
349 "Postal and courier activities - total (items 341 to 343)"
351 "Accommodation and food service activities - articles consumed for food & drink preparation"
352 "Accommodation and food service activities - purchase value of goods traded"
353 "Accommodation and food service activities - crockery, glassware, bedding and other consumables"
354 "Accommodation and food service activities - fuels consumed"
359 "Accommodation and food service activities - total (items 351 to 354)"
361 "Information and communications - call charges and rent payable (local call/ STD / ISD, cyber car radio paging, cellular etc.)"
362 "Information and communications - other expenses"
369 "Information and communications - total (items 361 to 362)"
371 "Financial and insurance activities - interest payments"
372 "Financial and insurance activities - commission & brokerage"
373 "Financial and insurance activities - insurance claims paid"
374 "Financial and insurance activities - net changes in life insurance technical reserves"
375 "Financial and insurance activities - service charges for work done by other concerns (contract, sub-contract, legal, audit, accounting services, etc.)"
376 "Financial and insurance activities - others (e.g., electricity, communication, travelling, printing etc.)"
379 "Financial and insurance activities - total (items 371 to 376)"
381 "Real estate activities - maintenance of building, machinery and equipment"
382 "Real estate activities - other expenses (travelling, hospitality, legal etc.)"
389 "Real estate activities - total (items 381 to 382)"
391 "Educational activity - recurring expenses on laboratory and library"
392 "Educational activity - recurring expenses on newspaper, journals, paper, printing, stationery etc."
393 "Educational activity - expenses on festivals like the annual day, teachersҠday, health check-up, etc."
394 "Educational activity - expenses on consumables used in computer, Xerox, cyclostyle, etc."
399 "Educational activity - total (items 391 to 394)"
401 "Human health and social work activity - diet of patients"
402 "Human health and social work activity - medicine and drugs"
403 "Human health and social work activity - consumables used in operation theatre, sophisticated equipment, pathological, radiological and other diagnostic tests"
404 "Human health and social work activity - syringes, into veins drip sets, cotton bandages, plastering materials and other disposables"
405 "Human health and social work activity - uniforms, linen and laundry materials"
406 "Human health and social work activity - health camps, seminar, workshop, awareness programmes and other social activities"
407 "Human health and social work activity - training, meeting, documentation, publication, nutritional expenses"
409 "Human health and social work activity - total (items 401 to 407)";
save "NSS67_Sch2-34_bk_3", replace (can be saved as Block 3)
Block 4: other operating expenses- provides information on fuel expenses (electricity, petrol, diesel etc.), minor repair expenses, communication expenses, insurance expenses, paper, printing and stationary expenses etc (detail information has been provided schedule .doc 2.34)
in order to extract the data for this block we have to use following codes,
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_v10 25 - 25
str B1_v11 26 - 26
str B1_v12 27 - 30
str B1_v13 31 - 31
str B1_v14 32 - 33
str B1_v15 34 - 35
str B4_v02 40 - 42
str B4_v03 43 - 54
NSS 127 - 129
NSC 130 - 132
MLT 133 - 142
using "r67s234L05.TXT";
gen state=substr(B1_v06,1,2);
compress;
gen ID= B1_v01+B1_v13+B1_v14+B1_v15;
isid ID B4_v02;
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 "FSU number";
label variable B1_v02 "Round Number";
label variable B1_v03 "Schedule Number";
label variable B1_v04 "Sample";
label variable B1_v05 "Sector";
label variable B1_v06 "NSS-Region";
label variable B1_v07 "District";
label variable B1_v08 "Stratum ";
label variable B1_v09 "Sub-Stratum ";
label variable B1_v10 "Sub-Round";
label variable B1_v11 "Sub-Sample";
label variable B1_v12 "FOD Sub-Region";
label variable B1_v13 "Segment";
label variable B1_v14 "SSS";
label variable B1_v15 "Enterprise Number";
label variable B4_v02 "Item Code(411-431)";
label variable B4_v03 "Value(Rs.)";
label define itmblk4
411 "Electricity charges"
412 "Fuel and lubricant"
413 "Raw materials consumed for own construction of building, furniture and fixtures (including labour charges)"
414 "Minor repair and maintenance of building"
415 "Plant and machinery"
416 "Transport equipment"
417 "Tools and other fixed assets"
418 "Information, computer and telecommunication equipment (ICT)"
421 "Rental payable on fixed assets (other than land and building)"
422 "Service charges for work done by other concerns"
423 "Travelling, freight and cartage (transport) expenses"
424 "Communication expenses (telephone, telegram, fax , postal, courier , e-mail etc.)"
425 "Purchase of consumable stores, packing materials, etc."
426 "Paper, printing and stationery expenses"
427 "Insurance charges"
428 "Other expenses"
429 "Total (items 411 to 428)"
431 "Taxes on production";
label values state state;
label values B1_v04 sample;
label values B1_v05 sector;
label values B4_v02 itmblk4;
save "NSS67_Sch2-34_bk_3", replace; (can be saved as Block 4)
Block 5: Principal Receipts- provides information main products and by-products manufactured, other products, the sale value of the goods sold in the same condition as purchased, opening stock of semi-finished goods and closing stock of semi-finished goods.
in order to extract the data for this block we have to use following codes,
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_v10 25 - 25
str B1_v11 26 - 26
str B1_v12 27 - 30
str B1_v13 31 - 31
str B1_v14 32 - 33
str B1_v15 34 - 35
str B5_v02 40 - 42
str B5_v03s 43 - 43
str B5_v03 44 - 55
NSS 127 - 129
NSC 130 - 132
MLT 133 - 142
using "r67s234L06.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 *;
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 "FSU number";
label variable B1_v02 "Round Number";
label variable B1_v03 "Schedule Number";
label variable B1_v04 "Sample";
label variable B1_v05 "Sector";
label variable B1_v06 "NSS-Region";
label variable B1_v07 "District";
label variable B1_v08 "Stratum ";
label variable B1_v09 "Sub-Stratum ";
label variable B1_v10 "Sub-Round";
label variable B1_v11 "Sub-Sample";
label variable B1_v12 "FOD Sub-Region";
label variable B1_v13 "Segment";
label variable B1_v14 "SSS";
label variable B1_v15 "Enterprise Number";
label variable B5_v02 "Item Code(501-639)";
label variable B5_v03 "Value(Rs.)";
label define itmblk5
501 "Manufacturing activity - main products and by-products manufactured"
502 "Manufacturing activity - main products and by-products manufactured"
503 "Manufacturing activity - main products and by-products manufactured"
504 "Manufacturing activity - main products and by-products manufactured"
505 "Manufacturing activity - other products/ by-products"
506 "Manufacturing activity - sale value of the goods sold in the same condition as purchased"
509 "Manufacturing activity - sub-total (items 501 to 506)"
511 "Manufacturing activity - opening stock of semi-finished goods"
512 "Manufacturing activity - closing stock of semi-finished goods"
513 "Manufacturing activity - changes in stock of semi-finished goods (item 512 - item 511)"
519 "Manufacturing activity - total (item 509 + item 513)"
521 "Trading activity - main commodities sold"
522 "Trading activity - main commodities sold"
523 "Trading activity - main commodities sold"
524 "Trading activity - main commodities sold"
525 "Trading activity - other commodities sold"
529 "Trading activity - sub-total (items 521 to 525)"
531 "Trading activity - opening stock of trading goods"
532 "Trading activity - closing stock of trading goods"
533 "Trading activity - changes in stock of trading goods (item 532 - item 531)"
539 "Trading activity - total (item 529 +item 533)"
541 "Transportation activities - earnings from passenger traffic"
542 "Transportation activities - earnings from goods traffic"
549 "Transportation activities - total (items 541 to 542)"
551 "Warehousing and support activities for transportation - storage charges received"
552 "Warehousing and support activities for transportation - service charges received for support activities for transportation"
559 "Warehousing and support activities for transportation - total (items 551 to 552)"
561 "Postal and courier activities - charges received from customers for postal and courier activities"
562 "Postal and courier activities - others"
569 "Postal and courier activities - total (items 561 to 562)"
571 "Accommodation and food service activities - lodging charges, rent receivable for hiring out rooms and halls, receipts from services provided"
572 "Accommodation and food service activities - receipts from sale of prepared food, refreshment and drinks"
573 "Accommodation and food service activities - receipts from trading of purchased food, refreshment, drinks, etc."
574 "Accommodation and food service activities - receipts from catering services outside"
579 "Accommodation and food service activities - total (items 571 to 574)"
581 "Information and communications - charges receivable from customers (STD / ISD / courier/ fax / internet etc.)"
582 "Information and communications - other receipts"
589 "Information and communications - total (items 581 to 582)"
591 "Financial and insurance activities -interest receipts (cash and kind)"
592 "Financial and insurance activities -dividend receipts"
593 "Financial and insurance activities -lease income"
594 "Financial and insurance activities -brokerage and commission"
595 "Financial and insurance activities -net profit in share dealing"
596 "Financial and insurance activities -income earned on chit funds"
597 "Financial and insurance activities -net earnings from hire purchase finance"
598 "Financial and insurance activities -premium received"
601 "Financial and insurance activities -supplementary premium received"
602 "Financial and insurance activities -others (e.g. consultancy, receipts from non-financial activities, if any)"
609 "Financial and insurance activities -total (items 591 to 602)"
611 "Real estate activities - receipts from services provided (including rent on land and building)"
612 "Real estate activities - brokerage and commission charges"
619 "Real estate activities - total (items 611 to 612)"
621 "Educational activity - tuition fees"
622 "Educational activity - other fees"
623 "Educational activity - funding/ donations from individuals and non-govt. institutions"
629 "Educational activity - total (items 621 to 623)"
631 "Human health and social work activity - consultation fees and charges for medicines"
632 "Human health and social work activity - charges for operation theatre, and other special procedures"
633 "Human health and social work activity - charges for ward, cabin, pathological, radiological and other diagnostic tests, diet, nursing, physiotherapy and rehabilitation, etc"
634 "Human health and social work activity - fees for training"
635 "Human health and social work activity - donations/ grants from individuals and institutions"
639 "Human health and social work activity - total (items 631 to 635)";
label values state state;
label values B1_v04 sample;
label values B1_v05 sector;
label values B5_v02 itmblk5;
replace B5_v03=0-B5_v03 if B5_v03s==1;
drop B5_v03s;
save "NSS67_Sch2-34_bk_5", replace; (can be saved as Block 5)
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_v10 25 - 25
str B1_v11 26 - 26
str B1_v12 27 - 30
str B1_v13 31 - 31
str B1_v14 32 - 33
str B1_v15 34 - 35
str B5_v02 40 - 42
str B5_v03s 43 - 43
str B5_v03 44 - 55
NSS 127 - 129
NSC 130 - 132
MLT 133 - 142
using "r67s234L06.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 *;
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 "FSU number";
label variable B1_v02 "Round Number";
label variable B1_v03 "Schedule Number";
label variable B1_v04 "Sample";
label variable B1_v05 "Sector";
label variable B1_v06 "NSS-Region";
label variable B1_v07 "District";
label variable B1_v08 "Stratum ";
label variable B1_v09 "Sub-Stratum ";
label variable B1_v10 "Sub-Round";
label variable B1_v11 "Sub-Sample";
label variable B1_v12 "FOD Sub-Region";
label variable B1_v13 "Segment";
label variable B1_v14 "SSS";
label variable B1_v15 "Enterprise Number";
label variable B5_v02 "Item Code(501-639)";
label variable B5_v03 "Value(Rs.)";
label define itmblk5
501 "Manufacturing activity - main products and by-products manufactured"
502 "Manufacturing activity - main products and by-products manufactured"
503 "Manufacturing activity - main products and by-products manufactured"
504 "Manufacturing activity - main products and by-products manufactured"
505 "Manufacturing activity - other products/ by-products"
506 "Manufacturing activity - sale value of the goods sold in the same condition as purchased"
509 "Manufacturing activity - sub-total (items 501 to 506)"
511 "Manufacturing activity - opening stock of semi-finished goods"
512 "Manufacturing activity - closing stock of semi-finished goods"
513 "Manufacturing activity - changes in stock of semi-finished goods (item 512 - item 511)"
519 "Manufacturing activity - total (item 509 + item 513)"
521 "Trading activity - main commodities sold"
522 "Trading activity - main commodities sold"
523 "Trading activity - main commodities sold"
524 "Trading activity - main commodities sold"
525 "Trading activity - other commodities sold"
529 "Trading activity - sub-total (items 521 to 525)"
531 "Trading activity - opening stock of trading goods"
532 "Trading activity - closing stock of trading goods"
533 "Trading activity - changes in stock of trading goods (item 532 - item 531)"
539 "Trading activity - total (item 529 +item 533)"
541 "Transportation activities - earnings from passenger traffic"
542 "Transportation activities - earnings from goods traffic"
549 "Transportation activities - total (items 541 to 542)"
551 "Warehousing and support activities for transportation - storage charges received"
552 "Warehousing and support activities for transportation - service charges received for support activities for transportation"
559 "Warehousing and support activities for transportation - total (items 551 to 552)"
561 "Postal and courier activities - charges received from customers for postal and courier activities"
562 "Postal and courier activities - others"
569 "Postal and courier activities - total (items 561 to 562)"
571 "Accommodation and food service activities - lodging charges, rent receivable for hiring out rooms and halls, receipts from services provided"
572 "Accommodation and food service activities - receipts from sale of prepared food, refreshment and drinks"
573 "Accommodation and food service activities - receipts from trading of purchased food, refreshment, drinks, etc."
574 "Accommodation and food service activities - receipts from catering services outside"
579 "Accommodation and food service activities - total (items 571 to 574)"
581 "Information and communications - charges receivable from customers (STD / ISD / courier/ fax / internet etc.)"
582 "Information and communications - other receipts"
589 "Information and communications - total (items 581 to 582)"
591 "Financial and insurance activities -interest receipts (cash and kind)"
592 "Financial and insurance activities -dividend receipts"
593 "Financial and insurance activities -lease income"
594 "Financial and insurance activities -brokerage and commission"
595 "Financial and insurance activities -net profit in share dealing"
596 "Financial and insurance activities -income earned on chit funds"
597 "Financial and insurance activities -net earnings from hire purchase finance"
598 "Financial and insurance activities -premium received"
601 "Financial and insurance activities -supplementary premium received"
602 "Financial and insurance activities -others (e.g. consultancy, receipts from non-financial activities, if any)"
609 "Financial and insurance activities -total (items 591 to 602)"
611 "Real estate activities - receipts from services provided (including rent on land and building)"
612 "Real estate activities - brokerage and commission charges"
619 "Real estate activities - total (items 611 to 612)"
621 "Educational activity - tuition fees"
622 "Educational activity - other fees"
623 "Educational activity - funding/ donations from individuals and non-govt. institutions"
629 "Educational activity - total (items 621 to 623)"
631 "Human health and social work activity - consultation fees and charges for medicines"
632 "Human health and social work activity - charges for operation theatre, and other special procedures"
633 "Human health and social work activity - charges for ward, cabin, pathological, radiological and other diagnostic tests, diet, nursing, physiotherapy and rehabilitation, etc"
634 "Human health and social work activity - fees for training"
635 "Human health and social work activity - donations/ grants from individuals and institutions"
639 "Human health and social work activity - total (items 631 to 635)";
label values state state;
label values B1_v04 sample;
label values B1_v05 sector;
label values B5_v02 itmblk5;
replace B5_v03=0-B5_v03 if B5_v03s==1;
drop B5_v03s;
save "NSS67_Sch2-34_bk_5", replace; (can be saved as Block 5)
Block 6: Other receipts- Provides information receipts from services provided to others including commission charges
change-in-stock of semi-finished goods, the value of own construction of the building, furniture and fixtures, rental receivable on fixed assets (other than land and building), funding/ donations from individuals and non-govt. institutions and Govt. grants (excluding capital transfers like building fund, etc.)
Block 7: calculation of gross value added- Provides information total receipts, total operating expenses, distributive expenses and gross value added (GVA)
in order to extract the data for this block we have to use following codes,
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_v10 25 - 25
str B1_v11 26 - 26
str B1_v12 27 - 30
str B1_v13 31 - 31
str B1_v14 32 - 33
str B1_v15 34 - 35
str B67_v02 40 - 42
str B67_v03s 43 - 43
str B67_v03 44 - 55
NSS 127 - 129
NSC 130 - 132
MLT 133 - 142
using "r67s234L07.TXT";
gen state=substr(B1_v06,1,2);
compress;
gen ID= B1_v01+B1_v13+B1_v14+B1_v15;
isid ID B67_v02;
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 "FSU number";
label variable B1_v02 "Round Number";
label variable B1_v03 "Schedule Number";
label variable B1_v04 "Sample";
label variable B1_v05 "Sector";
label variable B1_v06 "NSS-Region";
label variable B1_v07 "District";
label variable B1_v08 "Stratum ";
label variable B1_v09 "Sub-Stratum ";
label variable B1_v10 "Sub-Round";
label variable B1_v11 "Sub-Sample";
label variable B1_v12 "FOD Sub-Region";
label variable B1_v13 "Segment";
label variable B1_v14 "SSS";
label variable B1_v15 "Enterprise Number";
label variable B67_v02 "Item Code(641-709)";
label variable B67_v03 "Value(Rs. in whole no.)";
label define itmblk67
641 "Receipts from services provided to others including commission charges"
642 "Change-in-stock of semi-finished goods (applicable for servicing enterprises engaged in software generation, motion picture production etc.)"
643 "Value of own construction of building, furniture and fixtures"
644 "Rental receivable on fixed assets (other than land and building)"
645 "Funding/ donations from individuals and non-govt. institutions"
646 "Govt. grants (excluding capital transfers like building fund, etc.)"
647 "Other receipts"
649 "Total (items 641 to 647)"
651 "Production subsidy/ interest subsidy"
701 "Total receipts [items( 519+539+549+559+569+579+589+609+619+629+639+ 649)]"
702 "Total operating expenses [items 309+319+329+339+349+359+369+379+389+399+409+429]"
703 "Distributive expenses, if any"
709 "Gross value added (item 701 - item 702 - 703)";
label values state state;
label values B1_v04 sample;
label values B1_v05 sector;
label values B67_v02 itmblk67;
replace B67_v03=0-B67_v03 if B67_v03s==1;
drop B67_v03s;
save "NSS67_Sch2-34_bk_6_7", replace; (can be saved as Block 6 and 7 respectively)
Block 8: employment particulars of the enterprise- Provides information working owner,
formal hired worker, informal hired worker and total worker.
in order to extract the data for this block we have to use following codes,
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_v10 25 - 25
str B1_v11 26 - 26
str B1_v12 27 - 30
str B1_v13 31 - 31
str B1_v14 32 - 33
str B1_v15 34 - 35
str B8_v02 40 - 42
str B8_v03 43 - 47
str B8_v04 48 - 52
str B8_v05 53 - 57
str B8_v06 58 - 62
str B8_v07 63 - 67
NSS 127 - 129
NSC 130 - 132
MLT 133 - 142
using "r67s234L08.TXT";
gen state=substr(B1_v06,1,2);
compress;
gen ID= B1_v01+B1_v13+B1_v14+B1_v15;
*//7obs are missing B8_v02 (Item code);
*isid ID B8_v02;
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 "FSU number";
label variable B1_v02 "Round Number";
label variable B1_v03 "Schedule Number";
label variable B1_v04 "Sample";
label variable B1_v05 "Sector";
label variable B1_v06 "NSS-Region";
label variable B1_v07 "District";
label variable B1_v08 "Stratum ";
label variable B1_v09 "Sub-Stratum ";
label variable B1_v10 "Sub-Round";
label variable B1_v11 "Sub-Sample";
label variable B1_v12 "FOD Sub-Region";
label variable B1_v13 "Segment";
label variable B1_v14 "SSS";
label variable B1_v15 "Enterprise Number";
label variable B8_v02 "Item Code(801-809)";
label variable B8_v03 "Full time-female";
label variable B8_v04 "Full time-male";
label variable B8_v05 "Part time-female";
label variable B8_v06 "Part time-male";
label variable B8_v07 "Total";
label define itmblk8
801 "Working owner"
802 "Formal hired worker"
803 "Informal hired worker"
804 "Other worker/helper"
809 "Total (items 801 to 804)";
label values state state;
label values B1_v04 sample;
label values B1_v05 sector;
label values B8_v02 itmblk8;
save "NSS67_Sch2-34_bk_8", replace; (can be saved as Block 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_v10 25 - 25
str B1_v11 26 - 26
str B1_v12 27 - 30
str B1_v13 31 - 31
str B1_v14 32 - 33
str B1_v15 34 - 35
str B8_v02 40 - 42
str B8_v03 43 - 47
str B8_v04 48 - 52
str B8_v05 53 - 57
str B8_v06 58 - 62
str B8_v07 63 - 67
NSS 127 - 129
NSC 130 - 132
MLT 133 - 142
using "r67s234L08.TXT";
gen state=substr(B1_v06,1,2);
compress;
gen ID= B1_v01+B1_v13+B1_v14+B1_v15;
*//7obs are missing B8_v02 (Item code);
*isid ID B8_v02;
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 "FSU number";
label variable B1_v02 "Round Number";
label variable B1_v03 "Schedule Number";
label variable B1_v04 "Sample";
label variable B1_v05 "Sector";
label variable B1_v06 "NSS-Region";
label variable B1_v07 "District";
label variable B1_v08 "Stratum ";
label variable B1_v09 "Sub-Stratum ";
label variable B1_v10 "Sub-Round";
label variable B1_v11 "Sub-Sample";
label variable B1_v12 "FOD Sub-Region";
label variable B1_v13 "Segment";
label variable B1_v14 "SSS";
label variable B1_v15 "Enterprise Number";
label variable B8_v02 "Item Code(801-809)";
label variable B8_v03 "Full time-female";
label variable B8_v04 "Full time-male";
label variable B8_v05 "Part time-female";
label variable B8_v06 "Part time-male";
label variable B8_v07 "Total";
label define itmblk8
801 "Working owner"
802 "Formal hired worker"
803 "Informal hired worker"
804 "Other worker/helper"
809 "Total (items 801 to 804)";
label values state state;
label values B1_v04 sample;
label values B1_v05 sector;
label values B8_v02 itmblk8;
save "NSS67_Sch2-34_bk_8", replace; (can be saved as Block 8)
Block 9: compensation to workers- provides information on salary / wages, house rent allowances, transport allowance, bonus and other individual benefits, contribution to insurance, provident fund and other social security schemes and Employer’s contribution to canteen, health clinic, child care centre, etc
in order to extract the data for this block we have to use following codes,
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_v10 25 - 25
str B1_v11 26 - 26
str B1_v12 27 - 30
str B1_v13 31 - 31
str B1_v14 32 - 33
str B1_v15 34 - 35
str B9_v02 40 - 42
str B9_v03 43 - 54
NSS 127 - 129
NSC 130 - 132
MLT 133 - 142
using "r67s234L09.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 *;
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 "FSU number";
label variable B1_v02 "Round Number";
label variable B1_v03 "Schedule Number";
label variable B1_v04 "Sample";
label variable B1_v05 "Sector";
label variable B1_v06 "NSS-Region";
label variable B1_v07 "District";
label variable B1_v08 "Stratum ";
label variable B1_v09 "Sub-Stratum ";
label variable B1_v10 "Sub-Round";
label variable B1_v11 "Sub-Sample";
label variable B1_v12 "FOD Sub-Region";
label variable B1_v13 "Segment";
label variable B1_v14 "SSS";
label variable B1_v15 "Enterprise Number";
label variable B9_v02 "Item Code(901-939)";
label variable B9_v03 "Value(Rs. in whole no.)";
label define itmblk9
901 "Salary / wages, house rent allowances, transport allowance, bonus and other individual benefits directly payable to the worker - working owner"
902 "Salary / wages, house rent allowances, transport allowance, bonus and other individual benefits directly payable to the worker - formally hired worker"
903 "Salary / wages, house rent allowances, transport allowance, bonus and other individual benefits directly payable to the worker - informally hired worker"
909 "Salary / wages, house rent allowances, transport allowance, bonus and other individual benefits directly payable to the worker - sub-total (items 901 to 903)"
911 "Contribution to insurance, provident fund and other social security schemes - working owner"
912 "Contribution to insurance, provident fund and other social security schemes - formally hired worker"
919 "Contribution to insurance, provident fund and other social security schemes - sub-total (items 911 to 912)"
921 "Employerӳ contribution to canteen, health clinic, child care centre, etc. (average for a month) - working owner"
922 "Employerӳ contribution to canteen, health clinic, child care centre, etc. (average for a month) - formally hired worker"
923 "Employerӳ contribution to canteen, health clinic, child care centre, etc. (average for a month) - informally hired worker"
924 "Employerӳ contribution to canteen, health clinic, child care centre, etc. (average for a month) - other worker / helper"
929 "Employerӳ contribution to canteen, health clinic, child care centre, etc. (average for a month) - sub-total (items 921 to 924)"
939 "Total emoluments (items 909 + 919 + 929)";
label values state state;
label values B1_v04 sample;
label values B1_v05 sector;
label values B9_v02 itmblk9;
save "NSS67_Sch2-34_bk_9", replace; (can be saved as Block 9)
Block 10: fixed assets owned and hired- provides information land and building, plant and machinery, transport equipment, software and database and capital work in progress
in order to extract the data for this block we have to use following codes,
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_v10 25 - 25
str B1_v11 26 - 26
str B1_v12 27 - 30
str B1_v13 31 - 31
str B1_v14 32 - 33
str B1_v15 34 - 35
str B10_v02 39 - 42
str B10_v03 43 - 54
str B10_v04 55 - 66
str B10_v05s 67 - 67
str B10_v05 68 - 79
str B10_v06 80 - 91
NSS 127 - 129
NSC 130 - 132
MLT 133 - 142
using "r67s234L10.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 *;
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 "FSU number";
label variable B1_v02 "Round Number";
label variable B1_v03 "Schedule Number";
label variable B1_v04 "Sample";
label variable B1_v05 "Sector";
label variable B1_v06 "NSS-Region";
label variable B1_v07 "District";
label variable B1_v08 "Stratum ";
label variable B1_v09 "Sub-Stratum ";
label variable B1_v10 "Sub-Round";
label variable B1_v11 "Sub-Sample";
label variable B1_v12 "FOD Sub-Region";
label variable B1_v13 "Segment";
label variable B1_v14 "SSS";
label variable B1_v15 "Enterprise Number";
label variable B10_v02 "Item Code(1001-1009)";
label variable B10_v03 "Market Value of Assets - Owned(Rs)";
label variable B10_v04 "Market Value of Assets - hired(Rs)";
label variable B10_v05 "Net Addition(Rs)";
label variable B10_v06 "Monthly Rental payable(Rs)";
label define itmblk10
1001 "Land and Building"
1002 "Plant and Machinery"
1003 "Transport Equipment"
1004 "Tools and Other Fixed Assets"
1005 "Software and Database"
1006 "Information, Computer and Telecommunications Equipment"
1007 "Capital Work in Progress"
1009 "Total (1001 To 1007)";
label values state state;
label values B1_v04 sample;
label values B1_v05 sector;
label values B10_v02 itmblk10;
replace B10_v05=0-B10_v05 if B10_v05s==1;
drop B10_v05s;
save "NSS67_Sch2-34_bk_10", replace; (can be saved as Block 10)
in order to extract the data for this block we have to use following codes,
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_v10 25 - 25
str B1_v11 26 - 26
str B1_v12 27 - 30
str B1_v13 31 - 31
str B1_v14 32 - 33
str B1_v15 34 - 35
str B11_v02 39 - 42
str B11_v03 43 - 54
str B11_v04 55 - 66
NSS 127 - 129
NSC 130 - 132
MLT 133 - 142
using "r67s234L11.TXT";
gen state=substr(B1_v06,1,2);
compress;
gen ID= B1_v01+B1_v13+B1_v14+B1_v15;
//one obs missing B11_v02;
*isid ID B11_v02;
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 "FSU number";
label variable B1_v02 "Round Number";
label variable B1_v03 "Schedule Number";
label variable B1_v04 "Sample";
label variable B1_v05 "Sector";
label variable B1_v06 "NSS-Region";
label variable B1_v07 "District";
label variable B1_v08 "Stratum ";
label variable B1_v09 "Sub-Stratum ";
label variable B1_v10 "Sub-Round";
label variable B1_v11 "Sub-Sample";
label variable B1_v12 "FOD Sub-Region";
label variable B1_v13 "Segment";
label variable B1_v14 "SSS";
label variable B1_v15 "Enterprise Number";
label variable B11_v02 "Item Code(1101-1119)";
label variable B11_v03 "Amount(Rs)";
label variable B11_v04 "Interest Payable(Rs)";
label define itmblk11
1101 "Central and state level term lending institutions"
1102 "Government (central, state, local bodies)"
1103 "Commercial banks"
1104 "Co-operative banks and societies"
1105 "Micro-finance institutions"
1106 "Other institutional agencies"
1107 "Money lenders"
1108 "Business partner(s)"
1109 "Suppliers / contractors"
1110 "Friends and relatives"
1111 "Others"
1119 "Total (1101 to 1111)";
label values state state;
label values B1_v04 sample;
label values B1_v05 sector;
label values B11_v02 itmblk11;
save "NSS67_Sch2-34_bk_11", replace; (can be saved as Block 11)
Block 12: factor incomes-provide information on as emolument, rent payable, interest payable and net surplus.
in order to extract the data for this block we have to use following codes,
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_v10 25 - 25
str B1_v11 26 - 26
str B1_v12 27 - 30
str B1_v13 31 - 31
str B1_v14 32 - 33
str B1_v15 34 - 35
str B12_v02 39 - 42
str B12_v03s 43 - 43
str B12_v03 44 - 55
NSS 127 - 129
NSC 130 - 132
MLT 133 - 142
using "r67s234L12.TXT";
gen state=substr(B1_v06,1,2);
compress;
gen ID= B1_v01+B1_v13+B1_v14+B1_v15;
*//one obs missing B12_v02;
*isid ID B12_v02;
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 "FSU number";
label variable B1_v02 "Round Number";
label variable B1_v03 "Schedule Number";
label variable B1_v04 "Sample";
label variable B1_v05 "Sector";
label variable B1_v06 "NSS-Region";
label variable B1_v07 "District";
label variable B1_v08 "Stratum ";
label variable B1_v09 "Sub-Stratum ";
label variable B1_v10 "Sub-Round";
label variable B1_v11 "Sub-Sample";
label variable B1_v12 "FOD Sub-Region";
label variable B1_v13 "Segment";
label variable B1_v14 "SSS";
label variable B1_v15 "Enterprise Number";
label variable B12_v02 "Item Code(1201-1209)";
label variable B12_v03 "Value (Rs)";
label define itmblk12
1201 "Emoluments (item 939, col.3 of block 9)"
1202 "Rent payable (item 1001, col.6 of block 10)"
1203 "Interest payable (item 1119, col. 4 of block 11)"
1204 "Net surplus"
1209 "Total (items 1201 to 1204 )";
label values state state;
label values B1_v04 sample;
label values B1_v05 sector;
label values B12_v02 itmblk12;
replace B12_v03=0-B12_v03 if B12_v03s==1;
drop B12_v03s;
save "NSS67_Sch2-34_bk_12", replace; (can be saved as Block 12).
Before moving on, one should check for duplication of the identification number, check the number of enterprises records in dataset count and calculate the estimated number of enterprises. the number of observation in each block should tally with the Read me file.
