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

3    
4    libname dsdata
4  ! "C:\Users\yl2269\Dropbox\Yao_Backup\ChicagoBooth_DB\Research_Project\Bank_liquidity\Journal\J
4  ! AR\CodeAndData\01_Build\bd_data";
NOTE: Libref DSDATA 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
5    
6    data network;
7    set dsdata.network;
8    if y>2009;
9    run;

NOTE: There were 1031494 observations read from the data set DSDATA.NETWORK.
NOTE: The data set WORK.NETWORK has 420460 observations and 53 variables.
NOTE: DATA statement used (Total process time):
      real time           0.50 seconds
      cpu time            0.07 seconds
      

10   
11   PROC IMPORT OUT=ds2rssd
12               DATAFILE=
12 ! "C:\Users\yl2269\Dropbox\Yao_Backup\ChicagoBooth_DB\Research_Project\Bank_liquidity\Journal\J
12 ! AR\CodeAndData\01_Build\bd_data\ds_rssd_link20181023AddMS.xlsx"
13               DBMS=xlsx REPLACE;
14   RUN;

NOTE: The import data set has 476 observations and 4 variables.
NOTE: WORK.DS2RSSD data set was successfully created.
NOTE: PROCEDURE IMPORT used (Total process time):
      real time           0.01 seconds
      cpu time            0.00 seconds
      

15   
16   /*Dictionary for fr y-9c*/
17   data ds2rssd;
18   set ds2rssd;
19   keep LenderUltiParentID RSSD9001_final isBHC;
20   run;

NOTE: There were 476 observations read from the data set WORK.DS2RSSD.
NOTE: The data set WORK.DS2RSSD has 476 observations and 3 variables.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      cpu time            0.01 seconds
      

21   
22   data lender_dic_bhc;
23   set ds2rssd;
24   if isBHC=1;
25   drop isBHC;
26   run;

NOTE: There were 476 observations read from the data set WORK.DS2RSSD.
NOTE: The data set WORK.LENDER_DIC_BHC has 419 observations and 2 variables.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
      

27   
28   
29   /*Import bank regulatory data*/
30   data BHCdata;
31   set dsdata.bhcdata;
32   yy=substr(RSSD9999,5,4)*1;
33   y=input(yy,best12.);
34   m=substr(RSSD9999,9,2);
35   if m=03 then q=1;
36   else if m=06 then q=2;
37   else if m=09 then q=3;
38   else if m=12 then q=4;
39   drop m yy;
40   run;

NOTE: Numeric values have been converted to character values at the places given by: 
      (Line):(Column).
      32:11   33:9    34:10   
NOTE: Character values have been converted to numeric values at the places given by: 
      (Line):(Column).
      32:4   34:3   
NOTE: There were 106419 observations read from the data set DSDATA.BHCDATA.
NOTE: The data set WORK.BHCDATA has 106419 observations and 103 variables.
NOTE: DATA statement used (Total process time):
      real time           0.08 seconds
      cpu time            0.00 seconds
      

41   
42   /*Merge info with dictionary*/
43   proc sort data = lender_dic_bhc; by RSSD9001_final;run;

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

44   proc sort data=bhcdata;by rssd9001 rssd9999;run;

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

45   proc sql;
46     create table lender_info_bhc(drop=tmpid) as
47     select  *
48     from lender_dic_bhc (rename=(RSSD9001_final=tmpid)), bhcdata
49     where lender_dic_bhc.tmpid=bhcdata.rssd9001
50     order by rssd9001;
NOTE: Table WORK.LENDER_INFO_BHC created, with 12367 rows and 104 columns.

51   quit;
NOTE: PROCEDURE SQL used (Total process time):
      real time           0.05 seconds
      cpu time            0.00 seconds
      

52   run;
53   
54   
55   
56   /*lender financials*/
57   data lender_financials_bhc;
58   set lender_info_bhc;
59   RegID=rssd9001;
60   Type_BHC=1;
61   keep LenderUltiParentID regid y q type_bhc;
62   run;

NOTE: There were 12367 observations read from the data set WORK.LENDER_INFO_BHC.
NOTE: The data set WORK.LENDER_FINANCIALS_BHC has 12367 observations and 5 variables.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
      

63   
64   data lender_financials;
65   retain LenderUltiParentID regid y q type_bhc;
66   set lender_financials_bhc;
67   run;

NOTE: There were 12367 observations read from the data set WORK.LENDER_FINANCIALS_BHC.
NOTE: The data set WORK.LENDER_FINANCIALS has 12367 observations and 5 variables.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
      

68   
69   proc sort data=lender_financials; by LenderUltiParentID y q ;run;

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

70   
71   
72   
73   /*network lenders' financials*/
74   
75   data nwlender_financials;
76   retain NWlenderid NWregid y q NWloan NWasset NWType_BHC;
77   set lender_financials;
78   NWLenderUltiParentID=LenderUltiParentID;
79   NWregid=regid;
80   NWType_BHC=type_BHC;
81   keep NWLenderUltiParentID NWregid y q NWType_BHC;
82   run;

NOTE: Variable NWlenderid is uninitialized.
NOTE: Variable NWloan is uninitialized.
NOTE: Variable NWasset is uninitialized.
NOTE: There were 12367 observations read from the data set WORK.LENDER_FINANCIALS.
NOTE: The data set WORK.NWLENDER_FINANCIALS has 12367 observations and 5 variables.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
      

83   
84   proc sort data=nwlender_financials; by NWLenderUltiParentID y q ;run;

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

85   
86   
87   /*Add lenders' and network lenders' financials to the Network*/
88   
89   proc sort data=network;by LenderUltiParentID y q;run;

NOTE: There were 420460 observations read from the data set WORK.NETWORK.
NOTE: The data set WORK.NETWORK has 420460 observations and 53 variables.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.49 seconds
      cpu time            0.23 seconds
      

90   proc sort data=lender_financials;by LenderUltiParentID y q;run;

NOTE: Input data set is already sorted, no sorting done.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
      

91   
92   data Network_fin;
93   merge network (in=a) lender_financials;
94   by LenderUltiParentID y q;
95   if a;
96   run;

NOTE: There were 420460 observations read from the data set WORK.NETWORK.
NOTE: There were 12367 observations read from the data set WORK.LENDER_FINANCIALS.
NOTE: The data set WORK.NETWORK_FIN has 420460 observations and 55 variables.
NOTE: DATA statement used (Total process time):
      real time           0.40 seconds
      cpu time            0.04 seconds
      

97   
98   
99   data Network_fin; set Network_fin; if regid~=.;run;

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

100  proc sort data=Network_fin; by regid y q;run;

NOTE: There were 363521 observations read from the data set WORK.NETWORK_FIN.
NOTE: The data set WORK.NETWORK_FIN has 363521 observations and 55 variables.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.45 seconds
      cpu time            0.18 seconds
      

101  
102  
103  proc sort data=network_fin;by NWLenderUltiParentID y q;run;

NOTE: There were 363521 observations read from the data set WORK.NETWORK_FIN.
NOTE: The data set WORK.NETWORK_FIN has 363521 observations and 55 variables.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.48 seconds
      cpu time            0.01 seconds
      

104  proc sort data=NWlender_financials;by NWLenderUltiParentID y q;run;

NOTE: Input data set is already sorted, no sorting done.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
      

105  
106  data Network_fin;
107  merge network_fin (in=a) NWlender_financials;
108  by NWLenderUltiParentID y q;
109  if a;
110  run;

NOTE: There were 363521 observations read from the data set WORK.NETWORK_FIN.
NOTE: There were 12367 observations read from the data set WORK.NWLENDER_FINANCIALS.
NOTE: The data set WORK.NETWORK_FIN has 363521 observations and 57 variables.
NOTE: DATA statement used (Total process time):
      real time           0.40 seconds
      cpu time            0.00 seconds
      

111  
112  
113  data Network_fin; set Network_fin; if nwregid~=.;run;

NOTE: There were 363521 observations read from the data set WORK.NETWORK_FIN.
NOTE: The data set WORK.NETWORK_FIN has 349156 observations and 57 variables.
NOTE: DATA statement used (Total process time):
      real time           0.37 seconds
      cpu time            0.03 seconds
      

114  proc sort data=network_fin; by regid y q borrowerid nwregid;run;

NOTE: There were 349156 observations read from the data set WORK.NETWORK_FIN.
NOTE: The data set WORK.NETWORK_FIN has 349156 observations and 57 variables.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.59 seconds
      cpu time            0.10 seconds
      

115  data network_fin;set network_fin; by regid y q borrowerid nwregid; if first.nwregid; run;

NOTE: There were 349156 observations read from the data set WORK.NETWORK_FIN.
NOTE: The data set WORK.NETWORK_FIN has 348581 observations and 57 variables.
NOTE: DATA statement used (Total process time):
      real time           0.43 seconds
      cpu time            0.00 seconds
      

116  data network_fin;set network_fin; if regid~=nwregid;run;

NOTE: There were 348581 observations read from the data set WORK.NETWORK_FIN.
NOTE: The data set WORK.NETWORK_FIN has 348532 observations and 57 variables.
NOTE: DATA statement used (Total process time):
      real time           0.40 seconds
      cpu time            0.00 seconds
      

117  
118  
119  data network_weight_raw;
120  set network_fin;
121  weight=1;
122  LeadArranger=0;
123  NWLeadArranger=0;
124  if LeadArrangerCredit="Yes" then LeadArranger=1;
125  if NWLeadCredit="Yes" then NWLeadArranger=1;
126  weight_NWLeadArranger=weight*NWLeadArranger;
127  keep regid NWregid weight type_bhc NWtype_bhc weight_NWLeadArranger y q;
128  run;

NOTE: There were 348532 observations read from the data set WORK.NETWORK_FIN.
NOTE: The data set WORK.NETWORK_WEIGHT_RAW has 348532 observations and 8 variables.
NOTE: DATA statement used (Total process time):
      real time           0.17 seconds
      cpu time            0.00 seconds
      

129  
130  proc sort data=network_weight_raw; by regid nwregid y q;run;

NOTE: There were 348532 observations read from the data set WORK.NETWORK_WEIGHT_RAW.
NOTE: The data set WORK.NETWORK_WEIGHT_RAW has 348532 observations and 8 variables.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.08 seconds
      cpu time            0.09 seconds
      

131  
132  data network_weight_raw_main;
133  set network_weight_raw;
134  if y<2018;
135  run;

NOTE: There were 348532 observations read from the data set WORK.NETWORK_WEIGHT_RAW.
NOTE: The data set WORK.NETWORK_WEIGHT_RAW_MAIN has 338096 observations and 8 variables.
NOTE: DATA statement used (Total process time):
      real time           0.03 seconds
      cpu time            0.00 seconds
      

136  
137  proc means data=network_weight_raw_main noprint;by regid nwregid;var weight; output
137! out=network_weight1 sum=weight;run;

NOTE: There were 338096 observations read from the data set WORK.NETWORK_WEIGHT_RAW_MAIN.
NOTE: The data set WORK.NETWORK_WEIGHT1 has 6014 observations and 5 variables.
NOTE: PROCEDURE MEANS used (Total process time):
      real time           0.06 seconds
      cpu time            0.00 seconds
      

138  data network_weight1; set network_weight1; drop _freq_ _type_; run;

NOTE: There were 6014 observations read from the data set WORK.NETWORK_WEIGHT1.
NOTE: The data set WORK.NETWORK_WEIGHT1 has 6014 observations and 3 variables.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
      

139  
140  proc means data=network_weight_raw_main noprint;by regid nwregid;var weight_NWLeadArranger;
140! output out=network_weight2 sum=weight_NWLeadArranger;run;

NOTE: There were 338096 observations read from the data set WORK.NETWORK_WEIGHT_RAW_MAIN.
NOTE: The data set WORK.NETWORK_WEIGHT2 has 6014 observations and 5 variables.
NOTE: PROCEDURE MEANS used (Total process time):
      real time           0.06 seconds
      cpu time            0.01 seconds
      

141  data network_weight2; set network_weight2; drop _freq_ _type_; run;

NOTE: There were 6014 observations read from the data set WORK.NETWORK_WEIGHT2.
NOTE: The data set WORK.NETWORK_WEIGHT2 has 6014 observations and 3 variables.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
      

142  
143  data network_weight;
144  merge network_weight1 (in=a) network_weight2;
145  by regid NWregid;
146  if a;
147  run;

NOTE: There were 6014 observations read from the data set WORK.NETWORK_WEIGHT1.
NOTE: There were 6014 observations read from the data set WORK.NETWORK_WEIGHT2.
NOTE: The data set WORK.NETWORK_WEIGHT has 6014 observations and 4 variables.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
      

148  
149  
150  
151  proc means data=network_weight_raw noprint;by regid nwregid y q;var weight; output
151! out=network_weight1_yq sum=weight_yq;run;

NOTE: There were 348532 observations read from the data set WORK.NETWORK_WEIGHT_RAW.
NOTE: The data set WORK.NETWORK_WEIGHT1_YQ has 34034 observations and 7 variables.
NOTE: PROCEDURE MEANS used (Total process time):
      real time           0.10 seconds
      cpu time            0.07 seconds
      

152  data network_weight1_yq; set network_weight1_yq; drop _freq_ _type_; run;

NOTE: There were 34034 observations read from the data set WORK.NETWORK_WEIGHT1_YQ.
NOTE: The data set WORK.NETWORK_WEIGHT1_YQ has 34034 observations and 5 variables.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      cpu time            0.01 seconds
      

153  
154  proc means data=network_weight_raw noprint;by regid nwregid y q;var weight_NWLeadArranger;
154! output out=network_weight2_yq sum=weight_NWLeadArranger_yq;run;

NOTE: There were 348532 observations read from the data set WORK.NETWORK_WEIGHT_RAW.
NOTE: The data set WORK.NETWORK_WEIGHT2_YQ has 34034 observations and 7 variables.
NOTE: PROCEDURE MEANS used (Total process time):
      real time           0.10 seconds
      cpu time            0.04 seconds
      

155  data network_weight2_yq; set network_weight2_yq; drop _freq_ _type_; run;

NOTE: There were 34034 observations read from the data set WORK.NETWORK_WEIGHT2_YQ.
NOTE: The data set WORK.NETWORK_WEIGHT2_YQ has 34034 observations and 5 variables.
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      cpu time            0.00 seconds
      

156  
157  
158  data network_weight_yq;
159  merge network_weight1_yq (in=a) network_weight2_yq;
160  by regid NWregid;
161  if a;
162  run;

NOTE: MERGE statement has more than one data set with repeats of BY values.
NOTE: There were 34034 observations read from the data set WORK.NETWORK_WEIGHT1_YQ.
NOTE: There were 34034 observations read from the data set WORK.NETWORK_WEIGHT2_YQ.
NOTE: The data set WORK.NETWORK_WEIGHT_YQ has 34034 observations and 6 variables.
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds
      

163  
164  
165  
166  data nameidlist;
167  set Network_fin;
168  by regid;
169  if last. regid;
170  keep LenderUltiParent regid;
171  run;

NOTE: There were 348532 observations read from the data set WORK.NETWORK_FIN.
NOTE: The data set WORK.NAMEIDLIST has 295 observations and 2 variables.
NOTE: DATA statement used (Total process time):
      real time           0.13 seconds
      cpu time            0.09 seconds
      

172  
173  data network_weight;
174  merge network_weight (in=a) nameidlist;
175  by regid;
176  if a;
177  run;

NOTE: There were 6014 observations read from the data set WORK.NETWORK_WEIGHT.
NOTE: There were 295 observations read from the data set WORK.NAMEIDLIST.
NOTE: The data set WORK.NETWORK_WEIGHT has 6014 observations and 5 variables.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
      

178  
179  
180  data network_location; set network_fin; keep regid NWregid LUPcity LUPstate NWLUPCity
180! NWLUPState;run;

NOTE: There were 348532 observations read from the data set WORK.NETWORK_FIN.
NOTE: The data set WORK.NETWORK_LOCATION has 348532 observations and 6 variables.
NOTE: DATA statement used (Total process time):
      real time           0.18 seconds
      cpu time            0.09 seconds
      

181  proc sort data=network_location; by regid nwregid;run;

NOTE: There were 348532 observations read from the data set WORK.NETWORK_LOCATION.
NOTE: The data set WORK.NETWORK_LOCATION has 348532 observations and 6 variables.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.22 seconds
      cpu time            0.21 seconds
      

182  data network_location; set network_location; by regid nwregid; if first. nwregid;run;

NOTE: There were 348532 observations read from the data set WORK.NETWORK_LOCATION.
NOTE: The data set WORK.NETWORK_LOCATION has 6102 observations and 6 variables.
NOTE: DATA statement used (Total process time):
      real time           0.07 seconds
      cpu time            0.04 seconds
      

183  
184  
185  
186  libname dsdata
186! "C:\Users\yl2269\Dropbox\Yao_Backup\ChicagoBooth_DB\Research_Project\Bank_liquidity\Journal\J
186! AR\CodeAndData\01_Build\bd_data";
NOTE: Libref DSDATA 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
187  
188  data dsdata.network_weight;
189  set network_weight;
190  run;

NOTE: There were 6014 observations read from the data set WORK.NETWORK_WEIGHT.
NOTE: The data set DSDATA.NETWORK_WEIGHT has 6014 observations and 5 variables.
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds
      

191  
192  data dsdata.network_weight_yq;
193  set network_weight_yq;
194  run;

NOTE: There were 34034 observations read from the data set WORK.NETWORK_WEIGHT_YQ.
NOTE: The data set DSDATA.NETWORK_WEIGHT_YQ has 34034 observations and 6 variables.
NOTE: DATA statement used (Total process time):
      real time           0.02 seconds
      cpu time            0.01 seconds
      

195  
196  
197  data dsdata.network_location;
198  set network_location;
199  run;

NOTE: There were 6102 observations read from the data set WORK.NETWORK_LOCATION.
NOTE: The data set DSDATA.NETWORK_LOCATION has 6102 observations and 6 variables.
NOTE: DATA statement used (Total process time):
      real time           0.02 seconds
      cpu time            0.00 seconds
      

200  
201  
202  data dsdata.NameRegIDList;
203  set nameidlist;
204  run;

NOTE: There were 295 observations read from the data set WORK.NAMEIDLIST.
NOTE: The data set DSDATA.NAMEREGIDLIST has 295 observations and 2 variables.
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      cpu time            0.00 seconds
      

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