1 The SAS System 16:28 Wednesday, November 8, 1995 NOTE: Copyright(c) 1989 by SAS Institute Inc., Cary, NC USA. NOTE: SAS (r) Proprietary Software Release 6.09 TS027 Licensed to UNIVERSITY OF MD-DEPARTMENT OF ECONOMICS, Site 0002318035. This message is contained in the SAS news file, and is presented upon initialization. Edit the files "news" in the "misc/base" directory to display site-specific news and information in the program log. The command line option "-nonews" will prevent this display. NOTE: AUTOEXEC processing beginning; file is /:/software/sas609/sas609/autoexec.sas. NOTE: SAS initialization used: real time 0.44 seconds cpu time 0.34 seconds NOTE: AUTOEXEC processing completed. 1 options pagesize=59 linesize=132 nocenter; 2 3 /*******************************************************/ 4 5 title 'Example SAS job reads India panel data.'; 6 7 /*******************************************************/ 8 9 filename inpanel '/var/spool/ftp/pub/india/panel.dat'; 10 11 data temp; 12 13 length DLABEL $ 30; 14 15 infile inpanel; 16 input 17 /* this version of data file has 360 records per district */ 18 #1 STATEID $ 1-2 DISTID $ 3-4 RECID 5-7 YEAR 8-9 VERSION 10 DLABEL $ & 19 20 /* Record ID# 100: total population */ 21 #4 POP6 11-19 RURAL6 20-28 MALE6 29-37 RMALE6 38-46 22 #5 POP7 11-19 RURAL7 20-28 MALE7 29-37 RMALE7 38-46 23 #6 POP8 11-19 RURAL8 20-28 MALE8 29-37 RMALE8 38-46 24 25 /* Record ID# 111: main workers */ 26 #7 /* no main only labor force data for 1961 */ 27 #8 WRKp7 11-19 WRKm7 29-37 28 #9 WRKp8 11-19 WRKm8 29-37 29 30 /* Record ID# 126: total main and marginal workers */ 31 #52 TWRKp6 11-19 TWRKm6 29-37 32 #53 /* no main and marginal data for 1971 */ 33 #54 TWRKp8 11-19 TWRKm8 29-37 34 2 The SAS System 16:28 Wednesday, November 8, 1995 35 /* Record ID# 127: main and marginal farm workers */ 36 #55 TFARMp6 11-19 37 #56 /* no main and marginal data for 1971 */ 38 #57 TFARMp8 11-19 39 40 /* Record ID# 134: main and marginal manufacturing workers */ 41 #76 TMANFp6 11-19 42 #77 /* no main and marginal data for 1971 */ 43 #78 TMANFp8 11-19 44 45 /* Record ID# 143: literates, 15-19 */ 46 #103 LIT15p6 11-19 47 #104 LIT15p7 11-19 48 #105 LIT15p8 11-19 49 50 /* Record ID# 163: totals, 15-19 */ 51 #142 AGE15p6 11-19 52 #143 AGE15p7 11-19 53 #144 AGE15p8 11-19 54 55 /* Record ID# 300: total migrants */ 56 #160 MIGp6 11-19 57 #161 /* migration data not yet available for 1971 */ 58 #162 MIGp8 11-19 59 60 /* Record ID# 580: 33-crop area and production totals */ 61 #316 CR33a6 11-19 CR33p6 20-28 62 #317 CR33a7 11-19 CR33p7 20-28 63 #318 CR33a8 11-19 CR33p8 20-28 64 65 /* Last record in current panel version */ 66 #360 67 ; 68 69 70 71 /* create missing values for all data = -1 */ 72 array M {*} POP6 -- CR33p8; 73 do I=1 to dim (M); 74 if M (I) = -1 then M (I)=.; 75 end; 76 77 /* create state labels */ 78 if STATEID = '01' then STATE = 'Andaman and Nicobar'; 79 if STATEID = '02' then STATE = 'Andhra Pradesh'; 80 if STATEID = '03' then STATE = 'Arunachal Pradesh'; 81 if STATEID = '04' then STATE = 'Assam'; 82 if STATEID = '05' then STATE = 'Bihar'; 83 if STATEID = '06' then STATE = 'Chandigarh'; 84 if STATEID = '07' then STATE = 'Dadra and Nagar Haveli'; 85 if STATEID = '08' then STATE = 'Delhi'; 86 if STATEID = '09' then STATE = 'Goa, Daman and Diu'; 87 if STATEID = '10' then STATE = 'Gujarat'; 88 if STATEID = '11' then STATE = 'Haryana'; 89 if STATEID = '12' then STATE = 'Himachal Pradesh'; 90 if STATEID = '13' then STATE = 'Jammu and Kashmir'; 91 if STATEID = '14' then STATE = 'Kerala'; 3 The SAS System 16:28 Wednesday, November 8, 1995 92 if STATEID = '15' then STATE = 'Lakshadweep'; 93 if STATEID = '16' then STATE = 'Madhya Pradesh'; 94 if STATEID = '17' then STATE = 'Maharashtra'; 95 if STATEID = '18' then STATE = 'Manipur'; 96 if STATEID = '19' then STATE = 'Meghalaya'; 97 if STATEID = '20' then STATE = 'Karnataka'; 98 if STATEID = '21' then STATE = 'Nagaland'; 99 if STATEID = '22' then STATE = 'Orissa'; 100 if STATEID = '23' then STATE = 'Pondicherry'; 101 if STATEID = '24' then STATE = 'Punjab'; 102 if STATEID = '25' then STATE = 'Rajasthan'; 103 if STATEID = '26' then STATE = 'Tamil Nadu'; 104 if STATEID = '27' then STATE = 'Tripura'; 105 if STATEID = '28' then STATE = 'Uttar Pradesh'; 106 if STATEID = '29' then STATE = 'West Bengal'; 107 if STATEID = '30' then STATE = 'Sikkim'; 108 if STATEID = '31' then STATE = 'Mizoram'; 109 if STATEID = '32' then STATE = 'NE Hill states'; 110 if STATEID = '33' then STATE = 'others'; 111 112 label 113 STATEID = 'State ID' 114 STATE = 'State labels' 115 DISTID = 'District ID' 116 RECID = 'Record ID' 117 YEAR = 'Year' 118 VERSION = 'Version number'; 119 120 /* Sex */ 121 label MALE6 = 'Total men 1961'; 122 label MALE7 = 'Total men 1971'; 123 label MALE8 = 'Total men 1981'; 124 125 FEM6 = POP6 - MALE6; 126 FEM7 = POP7 - MALE7; 127 FEM8 = POP8 - MALE8; 128 label FEM6 = 'Total women 1961'; 129 label FEM7 = 'Total women 1971'; 130 label FEM8 = 'Total women 1981'; 131 132 label RMALE6 = 'Rural men 1961'; 133 label RMALE7 = 'Rural men 1971'; 134 label RMALE8 = 'Rural men 1981'; 135 136 FEMR6 = RURAL6 - RMALE6; 137 FEMR7 = RURAL7 - RMALE7; 138 FEMR8 = RURAL8 - RMALE8; 139 label FEMR6 = 'Rural women 1961'; 140 label FEMR7 = 'Rural women 1971'; 141 label FEMR8 = 'Rural women 1981'; 142 143 144 /* Labor force: totals workers */ 145 label WRKp7 = 'Main (only) workers, persons 1971'; 146 label WRKp8 = 'Main (only) workers, persons 1981'; 147 148 label WRKm7 = 'Main (only) workers, male 1971'; 4 The SAS System 16:28 Wednesday, November 8, 1995 149 label WRKm8 = 'Main (only) workers, male 1981'; 150 151 WRKf7 = WRKp7 - WRKm7; 152 WRKf8 = WRKp8 - WRKm8; 153 label WRKf7 = 'Main (only) workers, female 1971'; 154 label WRKf8 = 'Main (only) workers, female 1981'; 155 156 157 label TWRKp6 = 'Main & marginal workers, persons 1961'; 158 label TWRKp8 = 'Main & marginal workers, persons 1981'; 159 160 label TWRKm6 = 'Main & marginal workers, male 1961'; 161 label TWRKm8 = 'Main & marginal workers, male 1981'; 162 163 TWRKf6 = TWRKp6 - TWRKm6; 164 TWRKf8 = TWRKp8 - TWRKm8; 165 label TWRKf6 = 'Main & marginal workers, female 1961'; 166 label TWRKf8 = 'Main & marginal workers, female 1981'; 167 168 /* Labor force participation rates by gender */ 169 pWRKm7 = WRKm7 / MALE7; 170 pWRKm8 = WRKm8 / MALE8; 171 label pWRKm7 = 'Male LF (main) participation, 1971'; 172 label pWRKm8 = 'Male LF (main) participation, 1981'; 173 174 pWRKf7 = WRKf7 / FEM7; 175 pWRKf8 = WRKf8 / FEM8; 176 label pWRKf7 = 'Female LF (main) participation, 1971'; 177 label pWRKf8 = 'Female LF (main) participation, 1981'; 178 179 pTWRKm6 = TWRKm6 / MALE6; 180 pTWRKm8 = TWRKm8 / MALE8; 181 label pTWRKm6 = 'Male LF (m&m) participation, 1961'; 182 label pTWRKm8 = 'Male LF (m&m) participation, 1981'; 183 184 pTWRKf6 = TWRKf6 / FEM6; 185 pTWRKf8 = TWRKf8 / FEM8; 186 label pTWRKf6 = 'Female LF (m&m) participation, 1961'; 187 label pTWRKf8 = 'Female LF (m&m) participation, 1981'; 188 189 190 /* Female share of labor force */ 191 FSHR6 = TWRKf6/TWRKp6; 192 FSHR8 = TWRKf8/TWRKp8; 193 label FSHR6 = 'Female share of m&m workers 1961'; 194 label FSHR8 = 'Female share of m&m workers 1981'; 195 196 FSHCP2 = FSHR8 - FSHR6; 197 label FSHCP2 = 'Change fem share of m&m workers 1961-81'; 198 199 200 /* Manufacturing */ 201 pTMANFp6 = TMANFp6 / TWRKp6; 202 pTMANFp8 = TMANFp8 / TWRKp8; 203 label pTMANFp6 = '% of m&m lf in manufacturing, 1961'; 204 label pTMANFp8 = '% of m&m lf in manufacturing, 1981'; 205 5 The SAS System 16:28 Wednesday, November 8, 1995 206 207 /* Literacy rates (15-19) */ 208 pLIT15p6 = LIT15p6 / AGE15p6 ; 209 pLIT15p7 = LIT15p7 / AGE15p7 ; 210 pLIT15p8 = LIT15p8 / AGE15p8 ; 211 label pLIT15p6 = '% Literate 15-19, 1961'; 212 label pLIT15p7 = '% Literate 15-19, 1971'; 213 label pLIT15p8 = '% Literate 15-19, 1981'; 214 215 /* (In) Migration rates */ 216 pMIGp6 = MIGp6 / POP6 ; 217 pMIGp8 = MIGp8 / POP8 ; 218 label pMIGp6 = 'In-migration percent, 1961'; 219 label pMIGp8 = 'In-migration percent, 1981'; 220 221 222 223 /* Ag yields */ 224 if (CR33p6>0 and CR33a6>0) then CR33ly6 = log (1000 * CR33p6 / CR33a6); 225 if (CR33p7>0 and CR33a7>0) then CR33ly7 = log (1000 * CR33p7 / CR33a7); 226 if (CR33p8>0 and CR33a8>0) then CR33ly8 = log (1000 * CR33p8 / CR33a8); 227 label CR33ly6 = 'Ag yields logged (33crops), 1961'; 228 label CR33ly7 = 'Ag yields logged (33crops), 1971'; 229 label CR33ly8 = 'Ag yields logged (33crops), 1981'; 230 231 NOTE: The infile INPANEL is: File Name=/var/spool/ftp/pub/india/panel.dat, Owner Name=reeve,Group Name=33536, Access Permission=rw-r--r--, File Size (bytes)=5026977 NOTE: 122040 records were read from the infile INPANEL. The minimum record length was 13. The maximum record length was 46. NOTE: Missing values were generated as a result of performing an operation on missing values. Each place is given by: (Number of times) at (Line):(Column). 8 at 127:22 8 at 138:25 8 at 152:19 1 at 163:21 8 at 164:21 8 at 170:20 8 at 175:20 1 at 179:22 8 at 180:22 1 at 184:22 8 at 185:22 1 at 191:15 8 at 192:15 9 at 196:16 1 at 201:20 8 at 202:20 1 at 208:20 8 at 210:20 2 at 216:16 8 at 217:16 NOTE: The data set WORK.TEMP has 339 observations and 77 variables. NOTE: DATA statement used: real time 6.22 seconds cpu time 5.82 seconds 232 proc print uniform; 233 var STATEID DISTID DLABEL pLIT15p6 pLIT15p7 pLIT15p8 pTMANFp8 pWRKm8 pWRKf8 pMIGp8 CR33a8 ; 234 NOTE: The PROCEDURE PRINT printed pages 1-7. NOTE: PROCEDURE PRINT used: real time 0.19 seconds cpu time 0.17 seconds 6 The SAS System 16:28 Wednesday, November 8, 1995 235 proc freq; 236 tables STATEID DISTID RECID YEAR VERSION STATE ; 237 WARNING: The formatted values of one or more variables are truncated to 16 characters. NOTE: For table location in print file, see page 8 for STATEID page 9 for DISTID page 10 for RECID page 10 for YEAR page 10 for VERSION page 11 for STATE NOTE: The PROCEDURE FREQ printed pages 8-11. NOTE: PROCEDURE FREQ used: real time 0.21 seconds cpu time 0.10 seconds 238 proc univariate plot ; 239 var pWRKm7 -- CR33ly8; 240 id DLABEL; 241 NOTE: Formatted values of ID variable DLABEL truncated to 8 characters in printed output. NOTE: The PROCEDURE UNIVARIATE printed pages 12-32. NOTE: PROCEDURE UNIVARIATE used: real time 0.50 seconds cpu time 0.50 seconds 242 proc means; 243 NOTE: The PROCEDURE MEANS printed pages 33-34. NOTE: PROCEDURE MEANS used: real time 0.29 seconds cpu time 0.29 seconds NOTE: The SAS System used: real time 7.98 seconds cpu time 7.32 seconds NOTE: SAS Institute Inc., SAS Campus Drive, Cary, NC USA 27513-2414