NOTE: PROCEDURE PRINTTO used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
      

3    
4    libname Bankdata
4  ! "C:\Users\yl2269\Dropbox\Yao_Backup\ChicagoBooth_DB\Research_Project\Bank_liquidity\Journal\J
4  ! AR\CodeAndData\00_DataCollection\dc_data\FRY9Csas";
NOTE: Libref BANKDATA was successfully assigned as follows: 
      Engine:        V9 
      Physical Name: 
      C:\Users\yl2269\Dropbox\Yao_Backup\ChicagoBooth_DB\Research_Project\Bank_liquidity\Journal\J
      AR\CodeAndData\00_DataCollection\dc_data\FRY9Csas
5    
6    data bhc_var_list;
7       input Name $20.;
8       datalines;

NOTE: The data set WORK.BHC_VAR_LIST has 97 observations and 1 variables.
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      cpu time            0.00 seconds
      

106  ;
107  run;
108  
109  %macro buildtable;
110  
111  proc sql noprint; select Name into :bhc_list separated by ' ' from bhc_var_list quit;
112  
113  %do i=11 %to 19;
114  data %sysfunc(cats(NAL,&i,0,3)); set %sysfunc(cats(bankdata.bhcf,&i,0,3));
115      keep
116      rssd9999
117      rssd9001
118      RSSD9017
119      RSSD9054
120      BHCK0081
121      BHCK0395
122      BHCK0397
123      BHDMB987
124      BHCKB989
125      BHCK1754
126      BHCK1773
127      BHCKG300
128      BHCKG304
129      BHCKG308
130      BHCKG312
131      BHCKG316
132      BHCKG320
133      BHCKK142
134      BHCKK146
135      BHCKK150
136      BHCKK154
137      BHCKG303
138      BHCKG307
139      BHCKG311
140      BHCKG315
141      BHCKG319
142      BHCKG323
143      BHCKK145
144      BHCKK149
145      BHCKK153
146      BHCKK157
147      BHCKC026
148      BHCKG336
149      BHCKG340
150      BHCKG344
151      BHCKHT58
152      BHCKC027
153      BHCKG339
154      BHCKG343
155      BHCKG347
156      BHCKHT61
157      BHCK2170
158      BHCK2122
159      BHCKB529
160      BHCB2210
161      BHCB3187
162      BHCB2389
163      BHOD3189
164      BHOD3187
165      BHOD2389
166      BHCB6648
167      BHOD6648
168      BHCBHK29
169      BHODHK29
170      BHCK3210
171      BHCK3814
172      BHCK3816
173      BHCK3817
174      BHCKJ457
175      BHCKJ458
176      BHCKJ459
177      BHCK6550
178      BHCK3411
179      BHCK1407
180      BHCK1403
181      BHCK5525
182      BHCK5526
183      BHCK3506
184      BHCK3507
185      BHCK4230
186      BHCK4107
187      BHCK4340
188      BHCK4635
189      BHCK4605
190      BHCK3123
191      BHCK8274
192      BHCA8274
193      BHCKA223
194      BHCAA223
195      BHCK4460
196      RSSD9032
197      RSSD9200
198      RSSD9210
199      BHDM6631
200      BHDM6636
201      BHFN6631
202      BHFN6636
203      BHDMB993
204      BHCKB995
205      BHCK3548
206      BHCK4073
207      BHCK4079
208      BHCK3521
209      BHCK3196
210      BHCK4093
211      BHCK4301
212  
213      ; run;
214  
215  
216  data %sysfunc(cats(NAL,&i,0,6)); set %sysfunc(cats(bankdata.bhcf,&i,0,6));keep  &bhc_list;
216! run;
217  data %sysfunc(cats(NAL,&i,0,9)); set %sysfunc(cats(bankdata.bhcf,&i,0,9));keep  &bhc_list;
217! run;
218  data %sysfunc(cats(NAL,&i,1,2)); set %sysfunc(cats(bankdata.bhcf,&i,1,2));keep  &bhc_list;
218! run;
219  %end;
220  
221  %mend buildtable;
222  %buildtable;
NOTE: PROCEDURE SQL used (Total process time):
      real time           0.01 seconds
      cpu time            0.00 seconds
      


WARNING: The variable BHCKHT58 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCKHT61 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCBHK29 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHODHK29 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCK1407 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCK1403 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCA8274 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCAA223 in the DROP, KEEP, or RENAME list has never been referenced.
NOTE: There were 1260 observations read from the data set BANKDATA.BHCF1103.
NOTE: The data set WORK.NAL1103 has 1260 observations and 88 variables.
NOTE: DATA statement used (Total process time):
      real time           0.02 seconds
      cpu time            0.01 seconds
      


WARNING: The variable BHCKHT58 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCKHT61 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCBHK29 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHODHK29 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCK1407 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCK1403 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCA8274 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCAA223 in the DROP, KEEP, or RENAME list has never been referenced.
NOTE: There were 5200 observations read from the data set BANKDATA.BHCF1106.
NOTE: The data set WORK.NAL1106 has 5200 observations and 88 variables.
NOTE: DATA statement used (Total process time):
      real time           0.07 seconds
      cpu time            0.03 seconds
      


WARNING: The variable BHCKHT58 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCKHT61 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCBHK29 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHODHK29 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCK1407 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCK1403 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCA8274 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCAA223 in the DROP, KEEP, or RENAME list has never been referenced.
NOTE: There were 1240 observations read from the data set BANKDATA.BHCF1109.
NOTE: The data set WORK.NAL1109 has 1240 observations and 88 variables.
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      cpu time            0.00 seconds
      


WARNING: The variable BHCKHT58 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCKHT61 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCBHK29 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHODHK29 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCK1407 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCK1403 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCA8274 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCAA223 in the DROP, KEEP, or RENAME list has never been referenced.
NOTE: There were 5147 observations read from the data set BANKDATA.BHCF1112.
NOTE: The data set WORK.NAL1112 has 5147 observations and 88 variables.
NOTE: DATA statement used (Total process time):
      real time           0.03 seconds
      cpu time            0.03 seconds
      


WARNING: The variable BHCKHT58 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCKHT61 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCBHK29 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHODHK29 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCK1407 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCK1403 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCA8274 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCAA223 in the DROP, KEEP, or RENAME list has never been referenced.
NOTE: There were 1417 observations read from the data set BANKDATA.BHCF1203.
NOTE: The data set WORK.NAL1203 has 1417 observations and 88 variables.
NOTE: DATA statement used (Total process time):
      real time           0.02 seconds
      cpu time            0.00 seconds
      


WARNING: The variable BHCKHT58 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCKHT61 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCBHK29 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHODHK29 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCK1407 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCK1403 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCA8274 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCAA223 in the DROP, KEEP, or RENAME list has never been referenced.
NOTE: There were 5588 observations read from the data set BANKDATA.BHCF1206.
NOTE: The data set WORK.NAL1206 has 5588 observations and 88 variables.
NOTE: DATA statement used (Total process time):
      real time           0.07 seconds
      cpu time            0.01 seconds
      


WARNING: The variable BHCKHT58 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCKHT61 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCBHK29 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHODHK29 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCK1407 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCK1403 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCA8274 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCAA223 in the DROP, KEEP, or RENAME list has never been referenced.
NOTE: There were 1405 observations read from the data set BANKDATA.BHCF1209.
NOTE: The data set WORK.NAL1209 has 1405 observations and 88 variables.
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds
      


WARNING: The variable BHCKHT58 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCKHT61 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCBHK29 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHODHK29 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCK1407 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCK1403 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCA8274 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCAA223 in the DROP, KEEP, or RENAME list has never been referenced.
NOTE: There were 5479 observations read from the data set BANKDATA.BHCF1212.
NOTE: The data set WORK.NAL1212 has 5479 observations and 88 variables.
NOTE: DATA statement used (Total process time):
      real time           0.04 seconds
      cpu time            0.03 seconds
      


WARNING: The variable BHCKHT58 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCKHT61 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCBHK29 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHODHK29 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCK1407 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCK1403 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCA8274 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCAA223 in the DROP, KEEP, or RENAME list has never been referenced.
NOTE: There were 1432 observations read from the data set BANKDATA.BHCF1303.
NOTE: The data set WORK.NAL1303 has 1432 observations and 88 variables.
NOTE: DATA statement used (Total process time):
      real time           0.02 seconds
      cpu time            0.01 seconds
      


WARNING: The variable BHCKHT58 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCKHT61 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCBHK29 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHODHK29 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCK1407 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCK1403 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCA8274 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCAA223 in the DROP, KEEP, or RENAME list has never been referenced.
NOTE: There were 5411 observations read from the data set BANKDATA.BHCF1306.
NOTE: The data set WORK.NAL1306 has 5411 observations and 88 variables.
NOTE: DATA statement used (Total process time):
      real time           0.08 seconds
      cpu time            0.04 seconds
      


WARNING: The variable BHCKHT58 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCKHT61 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCBHK29 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHODHK29 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCK1407 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCK1403 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCA8274 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCAA223 in the DROP, KEEP, or RENAME list has never been referenced.
NOTE: There were 1406 observations read from the data set BANKDATA.BHCF1309.
NOTE: The data set WORK.NAL1309 has 1406 observations and 88 variables.
NOTE: DATA statement used (Total process time):
      real time           0.02 seconds
      cpu time            0.03 seconds
      


WARNING: The variable BHCKHT58 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCKHT61 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCBHK29 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHODHK29 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCK1407 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCK1403 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCA8274 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCAA223 in the DROP, KEEP, or RENAME list has never been referenced.
NOTE: There were 5319 observations read from the data set BANKDATA.BHCF1312.
NOTE: The data set WORK.NAL1312 has 5319 observations and 88 variables.
NOTE: DATA statement used (Total process time):
      real time           0.08 seconds
      cpu time            0.04 seconds
      


WARNING: The variable BHCKHT58 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCKHT61 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCBHK29 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHODHK29 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCK1407 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCK1403 in the DROP, KEEP, or RENAME list has never been referenced.
NOTE: There were 1388 observations read from the data set BANKDATA.BHCF1403.
NOTE: The data set WORK.NAL1403 has 1388 observations and 90 variables.
NOTE: DATA statement used (Total process time):
      real time           0.03 seconds
      cpu time            0.01 seconds
      


WARNING: The variable BHCKHT58 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCKHT61 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCBHK29 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHODHK29 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCK1407 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCK1403 in the DROP, KEEP, or RENAME list has never been referenced.
NOTE: There were 5216 observations read from the data set BANKDATA.BHCF1406.
NOTE: The data set WORK.NAL1406 has 5216 observations and 90 variables.
NOTE: DATA statement used (Total process time):
      real time           0.10 seconds
      cpu time            0.07 seconds
      


WARNING: The variable BHCKHT58 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCKHT61 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCBHK29 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHODHK29 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCK1407 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCK1403 in the DROP, KEEP, or RENAME list has never been referenced.
NOTE: There were 1352 observations read from the data set BANKDATA.BHCF1409.
NOTE: The data set WORK.NAL1409 has 1352 observations and 90 variables.
NOTE: DATA statement used (Total process time):
      real time           0.03 seconds
      cpu time            0.01 seconds
      


WARNING: The variable BHCKHT58 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCKHT61 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCBHK29 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHODHK29 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCK1407 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCK1403 in the DROP, KEEP, or RENAME list has never been referenced.
NOTE: There were 5112 observations read from the data set BANKDATA.BHCF1412.
NOTE: The data set WORK.NAL1412 has 5112 observations and 90 variables.
NOTE: DATA statement used (Total process time):
      real time           0.04 seconds
      cpu time            0.01 seconds
      


WARNING: The variable BHCKHT58 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCKHT61 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCBHK29 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHODHK29 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCK1407 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCK1403 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCK8274 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCKA223 in the DROP, KEEP, or RENAME list has never been referenced.
NOTE: There were 818 observations read from the data set BANKDATA.BHCF1503.
NOTE: The data set WORK.NAL1503 has 818 observations and 88 variables.
NOTE: DATA statement used (Total process time):
      real time           0.02 seconds
      cpu time            0.00 seconds
      


WARNING: The variable BHCKHT58 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCKHT61 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCBHK29 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHODHK29 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCK1407 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCK1403 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCK8274 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCKA223 in the DROP, KEEP, or RENAME list has never been referenced.
NOTE: There were 4998 observations read from the data set BANKDATA.BHCF1506.
NOTE: The data set WORK.NAL1506 has 4998 observations and 88 variables.
NOTE: DATA statement used (Total process time):
      real time           0.05 seconds
      cpu time            0.04 seconds
      


WARNING: The variable BHCKHT58 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCKHT61 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCBHK29 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHODHK29 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCK1407 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCK1403 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCK8274 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCKA223 in the DROP, KEEP, or RENAME list has never been referenced.
NOTE: There were 789 observations read from the data set BANKDATA.BHCF1509.
NOTE: The data set WORK.NAL1509 has 789 observations and 88 variables.
NOTE: DATA statement used (Total process time):
      real time           0.02 seconds
      cpu time            0.01 seconds
      


WARNING: The variable BHCKHT58 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCKHT61 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCBHK29 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHODHK29 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCK1407 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCK1403 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCK8274 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCKA223 in the DROP, KEEP, or RENAME list has never been referenced.
NOTE: There were 4895 observations read from the data set BANKDATA.BHCF1512.
NOTE: The data set WORK.NAL1512 has 4895 observations and 88 variables.
NOTE: DATA statement used (Total process time):
      real time           0.05 seconds
      cpu time            0.01 seconds
      


WARNING: The variable BHCKHT58 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCKHT61 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCBHK29 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHODHK29 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCK1407 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCK1403 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCK8274 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCKA223 in the DROP, KEEP, or RENAME list has never been referenced.
NOTE: There were 785 observations read from the data set BANKDATA.BHCF1603.
NOTE: The data set WORK.NAL1603 has 785 observations and 88 variables.
NOTE: DATA statement used (Total process time):
      real time           0.02 seconds
      cpu time            0.01 seconds
      


WARNING: The variable BHCKHT58 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCKHT61 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCBHK29 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHODHK29 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCK1407 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCK1403 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCK8274 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCKA223 in the DROP, KEEP, or RENAME list has never been referenced.
NOTE: There were 4816 observations read from the data set BANKDATA.BHCF1606.
NOTE: The data set WORK.NAL1606 has 4816 observations and 88 variables.
NOTE: DATA statement used (Total process time):
      real time           0.14 seconds
      cpu time            0.04 seconds
      


WARNING: The variable BHCKHT58 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCKHT61 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCBHK29 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHODHK29 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCK8274 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCKA223 in the DROP, KEEP, or RENAME list has never been referenced.
NOTE: There were 779 observations read from the data set BANKDATA.BHCF1609.
NOTE: The data set WORK.NAL1609 has 779 observations and 90 variables.
NOTE: DATA statement used (Total process time):
      real time           0.03 seconds
      cpu time            0.00 seconds
      


WARNING: The variable BHCKHT58 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCKHT61 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCBHK29 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHODHK29 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCK8274 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCKA223 in the DROP, KEEP, or RENAME list has never been referenced.
NOTE: There were 4750 observations read from the data set BANKDATA.BHCF1612.
NOTE: The data set WORK.NAL1612 has 4750 observations and 90 variables.
NOTE: DATA statement used (Total process time):
      real time           0.10 seconds
      cpu time            0.07 seconds
      


WARNING: The variable BHCKHT58 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCKHT61 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCB6648 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHOD6648 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCK8274 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCKA223 in the DROP, KEEP, or RENAME list has never been referenced.
NOTE: There were 802 observations read from the data set BANKDATA.BHCF1703.
NOTE: The data set WORK.NAL1703 has 802 observations and 90 variables.
NOTE: DATA statement used (Total process time):
      real time           0.03 seconds
      cpu time            0.00 seconds
      


WARNING: The variable BHCKHT58 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCKHT61 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCB6648 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHOD6648 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCK8274 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCKA223 in the DROP, KEEP, or RENAME list has never been referenced.
NOTE: There were 4672 observations read from the data set BANKDATA.BHCF1706.
NOTE: The data set WORK.NAL1706 has 4672 observations and 90 variables.
NOTE: DATA statement used (Total process time):
      real time           0.11 seconds
      cpu time            0.04 seconds
      


WARNING: The variable BHCKHT58 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCKHT61 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCB6648 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHOD6648 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCK8274 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCKA223 in the DROP, KEEP, or RENAME list has never been referenced.
NOTE: There were 778 observations read from the data set BANKDATA.BHCF1709.
NOTE: The data set WORK.NAL1709 has 778 observations and 90 variables.
NOTE: DATA statement used (Total process time):
      real time           0.02 seconds
      cpu time            0.00 seconds
      


WARNING: The variable BHCKHT58 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCKHT61 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCB6648 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHOD6648 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCK8274 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCKA223 in the DROP, KEEP, or RENAME list has never been referenced.
NOTE: There were 4594 observations read from the data set BANKDATA.BHCF1712.
NOTE: The data set WORK.NAL1712 has 4594 observations and 90 variables.
NOTE: DATA statement used (Total process time):
      real time           0.10 seconds
      cpu time            0.06 seconds
      


WARNING: The variable BHCKHT58 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCKHT61 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCB6648 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHOD6648 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCK5525 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCK5526 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCK8274 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCKA223 in the DROP, KEEP, or RENAME list has never been referenced.
NOTE: There were 775 observations read from the data set BANKDATA.BHCF1803.
NOTE: The data set WORK.NAL1803 has 775 observations and 88 variables.
NOTE: DATA statement used (Total process time):
      real time           0.02 seconds
      cpu time            0.03 seconds
      


WARNING: The variable BHCKG336 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCKG340 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCKG344 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCKG339 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCKG343 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCKG347 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCB6648 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHOD6648 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCK5525 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCK5526 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCK8274 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCKA223 in the DROP, KEEP, or RENAME list has never been referenced.
NOTE: There were 4508 observations read from the data set BANKDATA.BHCF1806.
NOTE: The data set WORK.NAL1806 has 4508 observations and 84 variables.
NOTE: DATA statement used (Total process time):
      real time           0.08 seconds
      cpu time            0.03 seconds
      


WARNING: The variable BHCKG336 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCKG340 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCKG344 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCKG339 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCKG343 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCKG347 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCB6648 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHOD6648 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCK5525 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCK5526 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCK8274 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCKA223 in the DROP, KEEP, or RENAME list has never been referenced.
NOTE: There were 445 observations read from the data set BANKDATA.BHCF1809.
NOTE: The data set WORK.NAL1809 has 445 observations and 84 variables.
NOTE: DATA statement used (Total process time):
      real time           0.02 seconds
      cpu time            0.00 seconds
      


WARNING: The variable BHCKG336 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCKG340 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCKG344 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCKG339 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCKG343 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCKG347 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCB6648 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHOD6648 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCK5525 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCK5526 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCK8274 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCKA223 in the DROP, KEEP, or RENAME list has never been referenced.
NOTE: There were 4409 observations read from the data set BANKDATA.BHCF1812.
NOTE: The data set WORK.NAL1812 has 4409 observations and 84 variables.
NOTE: DATA statement used (Total process time):
      real time           0.08 seconds
      cpu time            0.03 seconds
      


WARNING: The variable BHCKG336 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCKG340 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCKG344 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCKG339 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCKG343 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCKG347 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCB6648 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHOD6648 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCK5525 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCK5526 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCK8274 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCKA223 in the DROP, KEEP, or RENAME list has never been referenced.
NOTE: There were 436 observations read from the data set BANKDATA.BHCF1903.
NOTE: The data set WORK.NAL1903 has 436 observations and 84 variables.
NOTE: DATA statement used (Total process time):
      real time           0.02 seconds
      cpu time            0.03 seconds
      


WARNING: The variable BHCKG336 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCKG340 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCKG344 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCKG339 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCKG343 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCKG347 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCB6648 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHOD6648 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCK5525 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCK5526 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCK8274 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCKA223 in the DROP, KEEP, or RENAME list has never been referenced.
NOTE: There were 4336 observations read from the data set BANKDATA.BHCF1906.
NOTE: The data set WORK.NAL1906 has 4336 observations and 84 variables.
NOTE: DATA statement used (Total process time):
      real time           0.14 seconds
      cpu time            0.10 seconds
      


WARNING: The variable BHCKG336 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCKG340 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCKG344 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCKG339 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCKG343 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCKG347 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCB6648 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHOD6648 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCK5525 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCK5526 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCK8274 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCKA223 in the DROP, KEEP, or RENAME list has never been referenced.
NOTE: There were 428 observations read from the data set BANKDATA.BHCF1909.
NOTE: The data set WORK.NAL1909 has 428 observations and 84 variables.
NOTE: DATA statement used (Total process time):
      real time           0.03 seconds
      cpu time            0.00 seconds
      


WARNING: The variable BHCKG336 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCKG340 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCKG344 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCKG339 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCKG343 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCKG347 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCB6648 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHOD6648 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCK5525 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCK5526 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCK8274 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BHCKA223 in the DROP, KEEP, or RENAME list has never been referenced.
NOTE: There were 4234 observations read from the data set BANKDATA.BHCF1912.
NOTE: The data set WORK.NAL1912 has 4234 observations and 84 variables.
NOTE: DATA statement used (Total process time):
      real time           0.18 seconds
      cpu time            0.06 seconds
      

223  
224  
225  
226  data Y9craw; length rssd9017 $150. ; set NAL1103 NAL1106 NAL1109 NAL1112;run;

NOTE: There were 1260 observations read from the data set WORK.NAL1103.
NOTE: There were 5200 observations read from the data set WORK.NAL1106.
NOTE: There were 1240 observations read from the data set WORK.NAL1109.
NOTE: There were 5147 observations read from the data set WORK.NAL1112.
NOTE: The data set WORK.Y9CRAW has 12847 observations and 88 variables.
NOTE: DATA statement used (Total process time):
      real time           0.04 seconds
      cpu time            0.03 seconds
      

227  
228  %macro buildtable2;
229  
230  %do i=12 %to 17;
231  data Y9craw;length rssd9017 $150. ;  set Y9craw %sysfunc(cats(NAL,&i,0,3));run;
232  data Y9craw;length rssd9017 $150. ;  set Y9craw %sysfunc(cats(NAL,&i,0,6));run;
233  data Y9craw;length rssd9017 $150. ;  set Y9craw %sysfunc(cats(NAL,&i,0,9));run;
234  data Y9craw;length rssd9017 $150. ;  set Y9craw %sysfunc(cats(NAL,&i,1,2));run;
235  %end;
236  %mend buildtable2;
237  %buildtable2;

NOTE: There were 12847 observations read from the data set WORK.Y9CRAW.
NOTE: There were 1417 observations read from the data set WORK.NAL1203.
NOTE: The data set WORK.Y9CRAW has 14264 observations and 88 variables.
NOTE: DATA statement used (Total process time):
      real time           0.04 seconds
      cpu time            0.00 seconds
      


NOTE: There were 14264 observations read from the data set WORK.Y9CRAW.
NOTE: There were 5588 observations read from the data set WORK.NAL1206.
NOTE: The data set WORK.Y9CRAW has 19852 observations and 88 variables.
NOTE: DATA statement used (Total process time):
      real time           0.07 seconds
      cpu time            0.04 seconds
      


NOTE: There were 19852 observations read from the data set WORK.Y9CRAW.
NOTE: There were 1405 observations read from the data set WORK.NAL1209.
NOTE: The data set WORK.Y9CRAW has 21257 observations and 88 variables.
NOTE: DATA statement used (Total process time):
      real time           0.06 seconds
      cpu time            0.01 seconds
      


NOTE: There were 21257 observations read from the data set WORK.Y9CRAW.
NOTE: There were 5479 observations read from the data set WORK.NAL1212.
NOTE: The data set WORK.Y9CRAW has 26736 observations and 88 variables.
NOTE: DATA statement used (Total process time):
      real time           0.07 seconds
      cpu time            0.04 seconds
      


NOTE: There were 26736 observations read from the data set WORK.Y9CRAW.
NOTE: There were 1432 observations read from the data set WORK.NAL1303.
NOTE: The data set WORK.Y9CRAW has 28168 observations and 88 variables.
NOTE: DATA statement used (Total process time):
      real time           0.06 seconds
      cpu time            0.03 seconds
      


NOTE: There were 28168 observations read from the data set WORK.Y9CRAW.
NOTE: There were 5411 observations read from the data set WORK.NAL1306.
NOTE: The data set WORK.Y9CRAW has 33579 observations and 88 variables.
NOTE: DATA statement used (Total process time):
      real time           0.07 seconds
      cpu time            0.04 seconds
      


NOTE: There were 33579 observations read from the data set WORK.Y9CRAW.
NOTE: There were 1406 observations read from the data set WORK.NAL1309.
NOTE: The data set WORK.Y9CRAW has 34985 observations and 88 variables.
NOTE: DATA statement used (Total process time):
      real time           0.05 seconds
      cpu time            0.01 seconds
      


NOTE: There were 34985 observations read from the data set WORK.Y9CRAW.
NOTE: There were 5319 observations read from the data set WORK.NAL1312.
NOTE: The data set WORK.Y9CRAW has 40304 observations and 88 variables.
NOTE: DATA statement used (Total process time):
      real time           0.09 seconds
      cpu time            0.04 seconds
      


NOTE: There were 40304 observations read from the data set WORK.Y9CRAW.
NOTE: There were 1388 observations read from the data set WORK.NAL1403.
NOTE: The data set WORK.Y9CRAW has 41692 observations and 90 variables.
NOTE: DATA statement used (Total process time):
      real time           0.09 seconds
      cpu time            0.06 seconds
      


NOTE: There were 41692 observations read from the data set WORK.Y9CRAW.
NOTE: There were 5216 observations read from the data set WORK.NAL1406.
NOTE: The data set WORK.Y9CRAW has 46908 observations and 90 variables.
NOTE: DATA statement used (Total process time):
      real time           0.12 seconds
      cpu time            0.06 seconds
      


NOTE: There were 46908 observations read from the data set WORK.Y9CRAW.
NOTE: There were 1352 observations read from the data set WORK.NAL1409.
NOTE: The data set WORK.Y9CRAW has 48260 observations and 90 variables.
NOTE: DATA statement used (Total process time):
      real time           0.11 seconds
      cpu time            0.07 seconds
      


NOTE: There were 48260 observations read from the data set WORK.Y9CRAW.
NOTE: There were 5112 observations read from the data set WORK.NAL1412.
NOTE: The data set WORK.Y9CRAW has 53372 observations and 90 variables.
NOTE: DATA statement used (Total process time):
      real time           0.25 seconds
      cpu time            0.06 seconds
      


NOTE: There were 53372 observations read from the data set WORK.Y9CRAW.
NOTE: There were 818 observations read from the data set WORK.NAL1503.
NOTE: The data set WORK.Y9CRAW has 54190 observations and 90 variables.
NOTE: DATA statement used (Total process time):
      real time           0.22 seconds
      cpu time            0.11 seconds
      


NOTE: There were 54190 observations read from the data set WORK.Y9CRAW.
NOTE: There were 4998 observations read from the data set WORK.NAL1506.
NOTE: The data set WORK.Y9CRAW has 59188 observations and 90 variables.
NOTE: DATA statement used (Total process time):
      real time           0.20 seconds
      cpu time            0.07 seconds
      


NOTE: There were 59188 observations read from the data set WORK.Y9CRAW.
NOTE: There were 789 observations read from the data set WORK.NAL1509.
NOTE: The data set WORK.Y9CRAW has 59977 observations and 90 variables.
NOTE: DATA statement used (Total process time):
      real time           0.25 seconds
      cpu time            0.03 seconds
      


NOTE: There were 59977 observations read from the data set WORK.Y9CRAW.
NOTE: There were 4895 observations read from the data set WORK.NAL1512.
NOTE: The data set WORK.Y9CRAW has 64872 observations and 90 variables.
NOTE: DATA statement used (Total process time):
      real time           0.11 seconds
      cpu time            0.09 seconds
      


NOTE: There were 64872 observations read from the data set WORK.Y9CRAW.
NOTE: There were 785 observations read from the data set WORK.NAL1603.
NOTE: The data set WORK.Y9CRAW has 65657 observations and 90 variables.
NOTE: DATA statement used (Total process time):
      real time           0.10 seconds
      cpu time            0.04 seconds
      


NOTE: There were 65657 observations read from the data set WORK.Y9CRAW.
NOTE: There were 4816 observations read from the data set WORK.NAL1606.
NOTE: The data set WORK.Y9CRAW has 70473 observations and 90 variables.
NOTE: DATA statement used (Total process time):
      real time           0.12 seconds
      cpu time            0.07 seconds
      


NOTE: There were 70473 observations read from the data set WORK.Y9CRAW.
NOTE: There were 779 observations read from the data set WORK.NAL1609.
NOTE: The data set WORK.Y9CRAW has 71252 observations and 92 variables.
NOTE: DATA statement used (Total process time):
      real time           0.18 seconds
      cpu time            0.07 seconds
      


NOTE: There were 71252 observations read from the data set WORK.Y9CRAW.
NOTE: There were 4750 observations read from the data set WORK.NAL1612.
NOTE: The data set WORK.Y9CRAW has 76002 observations and 92 variables.
NOTE: DATA statement used (Total process time):
      real time           0.36 seconds
      cpu time            0.06 seconds
      


NOTE: There were 76002 observations read from the data set WORK.Y9CRAW.
NOTE: There were 802 observations read from the data set WORK.NAL1703.
NOTE: The data set WORK.Y9CRAW has 76804 observations and 94 variables.
NOTE: DATA statement used (Total process time):
      real time           0.29 seconds
      cpu time            0.06 seconds
      


NOTE: There were 76804 observations read from the data set WORK.Y9CRAW.
NOTE: There were 4672 observations read from the data set WORK.NAL1706.
NOTE: The data set WORK.Y9CRAW has 81476 observations and 94 variables.
NOTE: DATA statement used (Total process time):
      real time           0.14 seconds
      cpu time            0.01 seconds
      


NOTE: There were 81476 observations read from the data set WORK.Y9CRAW.
NOTE: There were 778 observations read from the data set WORK.NAL1709.
NOTE: The data set WORK.Y9CRAW has 82254 observations and 94 variables.
NOTE: DATA statement used (Total process time):
      real time           0.14 seconds
      cpu time            0.01 seconds
      


NOTE: There were 82254 observations read from the data set WORK.Y9CRAW.
NOTE: There were 4594 observations read from the data set WORK.NAL1712.
NOTE: The data set WORK.Y9CRAW has 86848 observations and 94 variables.
NOTE: DATA statement used (Total process time):
      real time           0.16 seconds
      cpu time            0.01 seconds
      

238  
239  data y9craw;
240  set y9craw (rename=(BHCK1403=BHCK1403temp BHCK1407=BHCK1407temp));
240! BHCK1403=input(BHCK1403temp,best12.); BHCK1407=input(BHCK1407temp,best12.);drop BHCK1403temp
240! BHCK1407temp;
241  run;

NOTE: There were 86848 observations read from the data set WORK.Y9CRAW.
NOTE: The data set WORK.Y9CRAW has 86848 observations and 94 variables.
NOTE: DATA statement used (Total process time):
      real time           0.19 seconds
      cpu time            0.06 seconds
      

242  
243  data y9craw ;
244  set y9craw NAL1803 NAL1806 NAL1809 NAL1812 NAL1903 NAL1906 NAL1909 NAL1912;
245  run;

NOTE: There were 86848 observations read from the data set WORK.Y9CRAW.
NOTE: There were 775 observations read from the data set WORK.NAL1803.
NOTE: There were 4508 observations read from the data set WORK.NAL1806.
NOTE: There were 445 observations read from the data set WORK.NAL1809.
NOTE: There were 4409 observations read from the data set WORK.NAL1812.
NOTE: There were 436 observations read from the data set WORK.NAL1903.
NOTE: There were 4336 observations read from the data set WORK.NAL1906.
NOTE: There were 428 observations read from the data set WORK.NAL1909.
NOTE: There were 4234 observations read from the data set WORK.NAL1912.
NOTE: The data set WORK.Y9CRAW has 106419 observations and 96 variables.
NOTE: DATA statement used (Total process time):
      real time           0.26 seconds
      cpu time            0.09 seconds
      

246  
247  data test;
248  set y9craw;
249  keep rssd9001 rssd9999 BHCK1403 BHCK1407;
250  run;

NOTE: There were 106419 observations read from the data set WORK.Y9CRAW.
NOTE: The data set WORK.TEST has 106419 observations and 4 variables.
NOTE: DATA statement used (Total process time):
      real time           0.13 seconds
      cpu time            0.06 seconds
      

251  
252  
253  data y9craw;
254  set y9craw;
255  m_FYE=int(rssd9054/100);
256  y=int(rssd9999/10000);
257  m=int(mod(rssd9999,10000)/100);
258  q=.;
259  if m>0 and m<4 then q=1;
260  if m>3 and m<7 then q=2;
261  if m>6 and m<10 then q=3;
262  if m>9 and m<13 then q=4;
263  
264  m_F=0;
265  if m=<m_FYE then m_F=m+12-m_FYE;
266  if m>m_FYE then m_F=m-m_FYE;
267  y_F=y;
268  if m_F<m then y_F=y+1;
269  run;

NOTE: There were 106419 observations read from the data set WORK.Y9CRAW.
NOTE: The data set WORK.Y9CRAW has 106419 observations and 102 variables.
NOTE: DATA statement used (Total process time):
      real time           0.32 seconds
      cpu time            0.01 seconds
      

270  
271  proc sort data= y9craw; by RSSD9001 RSSD9999;run;

NOTE: There were 106419 observations read from the data set WORK.Y9CRAW.
NOTE: The data set WORK.Y9CRAW has 106419 observations and 102 variables.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.40 seconds
      cpu time            0.20 seconds
      

272  
273  
274  data y9craw;
275  set y9craw;
276  by RSSD9001;
277  y_F_lag1=ifn(not(first. RSSD9001), lag(y_F),.);
278  m_F_lag1=ifn(not(first. RSSD9001), lag(m_F),.);
279  run;

NOTE: There were 106419 observations read from the data set WORK.Y9CRAW.
NOTE: The data set WORK.Y9CRAW has 106419 observations and 104 variables.
NOTE: DATA statement used (Total process time):
      real time           0.25 seconds
      cpu time            0.21 seconds
      

280  
281  
282  data y9craw;
283  set y9craw;
284  if m_fye=0 then m_fye=.;
285  run;

NOTE: There were 106419 observations read from the data set WORK.Y9CRAW.
NOTE: The data set WORK.Y9CRAW has 106419 observations and 104 variables.
NOTE: DATA statement used (Total process time):
      real time           0.24 seconds
      cpu time            0.10 seconds
      

286  
287  data fyebhc;
288  set y9craw;
289  if m_fye~=.;
290  keep rssd9001 m_fye;
291  run;

NOTE: There were 106419 observations read from the data set WORK.Y9CRAW.
NOTE: The data set WORK.FYEBHC has 106407 observations and 2 variables.
NOTE: DATA statement used (Total process time):
      real time           0.05 seconds
      cpu time            0.03 seconds
      

292  
293  proc sort data=fyebhc;by rssd9001 m_fye;run;

NOTE: There were 106407 observations read from the data set WORK.FYEBHC.
NOTE: The data set WORK.FYEBHC has 106407 observations and 2 variables.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.03 seconds
      cpu time            0.03 seconds
      

294  
295  data fyebhc;
296  set fyebhc;
297  by rssd9001;
298  if first. rssd9001;
299  rename m_fye=m_fye_temp;
300  run;

NOTE: There were 106407 observations read from the data set WORK.FYEBHC.
NOTE: The data set WORK.FYEBHC has 6209 observations and 2 variables.
NOTE: DATA statement used (Total process time):
      real time           0.02 seconds
      cpu time            0.00 seconds
      

301  
302  proc sort data=y9craw; by rssd9001;run;

NOTE: There were 106419 observations read from the data set WORK.Y9CRAW.
NOTE: The data set WORK.Y9CRAW has 106419 observations and 104 variables.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.19 seconds
      cpu time            0.04 seconds
      

303  
304  data y9craw;
305  merge y9craw(in=a) fyebhc(in=b);
306  by rssd9001;
307  if a;
308  run;

NOTE: There were 106419 observations read from the data set WORK.Y9CRAW.
NOTE: There were 6209 observations read from the data set WORK.FYEBHC.
NOTE: The data set WORK.Y9CRAW has 106419 observations and 105 variables.
NOTE: DATA statement used (Total process time):
      real time           0.14 seconds
      cpu time            0.11 seconds
      

309  
310  data y9craw;
311  set y9craw;
312  if m_fye=. then m_fye=m_fye_temp;
313  drop m_fye_temp;
314  run;

NOTE: There were 106419 observations read from the data set WORK.Y9CRAW.
NOTE: The data set WORK.Y9CRAW has 106419 observations and 104 variables.
NOTE: DATA statement used (Total process time):
      real time           0.12 seconds
      cpu time            0.06 seconds
      

315  
316  
317  data y9craw;
318  set y9craw;
319  if m_fye=. then m_fye=12;
320  if m_fye=1 or m_fye=2 then m_fye=3;
321  if m_fye=4 or m_fye=5 then m_fye=6;
322  if m_fye=7 or m_fye=8 then m_fye=9;
323  if m_fye=10 or m_fye=11 then m_fye=12;
324  if m_fye>12 then m_fye=12;
325  run;

NOTE: There were 106419 observations read from the data set WORK.Y9CRAW.
NOTE: The data set WORK.Y9CRAW has 106419 observations and 104 variables.
NOTE: DATA statement used (Total process time):
      real time           0.11 seconds
      cpu time            0.07 seconds
      

326  
327  
328  libname Bankdata
328! "C:\Users\yl2269\Dropbox\Yao_Backup\ChicagoBooth_DB\Research_Project\Bank_liquidity\Journal\J
328! AR\CodeAndData\01_Build\bd_data";
NOTE: Libref BANKDATA was successfully assigned as follows: 
      Engine:        V9 
      Physical Name: 
      C:\Users\yl2269\Dropbox\Yao_Backup\ChicagoBooth_DB\Research_Project\Bank_liquidity\Journal\J
      AR\CodeAndData\01_Build\bd_data
329  
330  proc sort data=y9craw; by rssd9001 rssd9999;run;

NOTE: There were 106419 observations read from the data set WORK.Y9CRAW.
NOTE: The data set WORK.Y9CRAW has 106419 observations and 104 variables.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.16 seconds
      cpu time            0.00 seconds
      

331  
332  data bankdata.bhcdata;set y9craw;run;

NOTE: There were 106419 observations read from the data set WORK.Y9CRAW.
NOTE: The data set BANKDATA.BHCDATA has 106419 observations and 104 variables.
NOTE: DATA statement used (Total process time):
      real time           0.10 seconds
      cpu time            0.03 seconds
      

NOTE: SAS Institute Inc., SAS Campus Drive, Cary, NC USA 27513-2414
NOTE: The SAS System used:
      real time           16.39 seconds
      cpu time            4.43 seconds
      
