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

3    
4    libname build
4  ! "C:\Users\yl2269\Dropbox\Yao_Backup\ChicagoBooth_DB\Research_Project\Bank_liquidity\Journal\J
4  ! AR\CodeAndData\01_Build\bd_data";
NOTE: Libref BUILD 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 nwstructure;
7    set build.network_weight;
8    run;

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

9    
10   data nwstructure_yq;
11   set build.network_weight_yq;
12   run;

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

13   
14   data nameidlist;
15   set build.NameRegIDList;
16   run;

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

17   
18   data bhc;
19   set build.bhc_var;
20   run;

NOTE: There were 106419 observations read from the data set BUILD.BHC_VAR.
NOTE: The data set WORK.BHC has 106419 observations and 184 variables.
NOTE: DATA statement used (Total process time):
      real time           0.10 seconds
      cpu time            0.01 seconds
      

21   
22   data nwstructure;set nwstructure; connection=1;
22 ! connection_la=ifn(weight_NWLeadArranger>0,1,0);run;

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

23   
24   data regidlist; set nwstructure; keep regid; run;

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

25   proc sort data=regidlist noduprecs;by _all_ ; Run;

NOTE: There were 6014 observations read from the data set WORK.REGIDLIST.
NOTE: 5720 duplicate observations were deleted.
NOTE: The data set WORK.REGIDLIST has 294 observations and 1 variables.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
      

26   
27   data NWregidlist; set nwstructure; keep NWregid; run;

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

28   proc sort data=NWregidlist noduprecs;by _all_ ; Run;

NOTE: There were 6014 observations read from the data set WORK.NWREGIDLIST.
NOTE: 5720 duplicate observations were deleted.
NOTE: The data set WORK.NWREGIDLIST has 294 observations and 1 variables.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
      

29   
30   proc sql;
31     create table regid_info_bhc as
32     select  *
33     from regidlist left join bhc
34     on regidlist.regid=bhc.RSSD9001
35     order by regidlist.regid, bhc.RSSD9999;
NOTE: Table WORK.REGID_INFO_BHC created, with 8643 rows and 185 columns.

36   quit;
NOTE: PROCEDURE SQL used (Total process time):
      real time           0.26 seconds
      cpu time            0.03 seconds
      

37   run;
38   
39   data regid_info_bhc;
40   set regid_info_bhc;
41   if RSSD9001~=.;
42   run;

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

43   
44   data regid_info; set regid_info_bhc; run;

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

45   
46   /*flag banks with complete sample period, i.e. banks with obs during 20180630-20150330*/
47   proc sort data=regid_info out=countbanks1; by regid rssd9999;run;

NOTE: There were 8643 observations read from the data set WORK.REGID_INFO.
NOTE: The data set WORK.COUNTBANKS1 has 8643 observations and 185 variables.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.01 seconds
      cpu time            0.00 seconds
      

48   data countbanks1; set countbanks1; by regid; if last. regid;run;

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

49   data countbanks1;set countbanks1;complete1=ifn(RSSD9999>=20180630,1,0);keep regid complete1;
49 ! run;

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

50   
51   proc sort data=regid_info out=countbanks2; by regid rssd9999;run;

NOTE: There were 8643 observations read from the data set WORK.REGID_INFO.
NOTE: The data set WORK.COUNTBANKS2 has 8643 observations and 185 variables.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds
      

52   data countbanks2; set countbanks2; by regid; if first. regid;run;

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

53   data countbanks2;set countbanks2;complete2=ifn(RSSD9999<20150630,1,0);keep regid complete2;
53 ! run;

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

54   
55   data countbanks;
56   merge countbanks1 countbanks2;
57   by regid;
58   run;

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

59   
60   data countbanks;
61   set countbanks;
62   complete=ifn(complete1=1 & complete2=1,1,0);
63   drop complete1 complete2;
64   run;

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

65   
66   proc sort data=regid_info;by regid;run;

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

67   data regid_info;
68   merge regid_info countbanks;
69   by regid;
70   run;

NOTE: There were 8643 observations read from the data set WORK.REGID_INFO.
NOTE: There were 294 observations read from the data set WORK.COUNTBANKS.
NOTE: The data set WORK.REGID_INFO has 8643 observations and 186 variables.
NOTE: DATA statement used (Total process time):
      real time           0.02 seconds
      cpu time            0.03 seconds
      

71   proc sort data=regid_info;by regid rssd9999;run;

NOTE: There were 8643 observations read from the data set WORK.REGID_INFO.
NOTE: The data set WORK.REGID_INFO has 8643 observations and 186 variables.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.02 seconds
      cpu time            0.01 seconds
      

72   
73   data regid_info;
74   set regid_info;
75   yy=substr(RSSD9999,5,4)*1;
76   y=input(yy,best12.);
77   m=substr(RSSD9999,9,2);
78   if m=03 then q=1;
79   else if m=06 then q=2;
80   else if m=09 then q=3;
81   else if m=12 then q=4;
82   drop m yy;
83   run;

NOTE: Numeric values have been converted to character values at the places given by: 
      (Line):(Column).
      75:11   76:9    77:10   
NOTE: Character values have been converted to numeric values at the places given by: 
      (Line):(Column).
      75:4   77:3   
NOTE: There were 8643 observations read from the data set WORK.REGID_INFO.
NOTE: The data set WORK.REGID_INFO has 8643 observations and 185 variables.
NOTE: DATA statement used (Total process time):
      real time           0.02 seconds
      cpu time            0.00 seconds
      

84   
85   data NWregid_info;
86   set regid_info;
87   rename regid=NWregid;
88   rename RSSD9001=NWRSSD9001;
89   rename RSSD9999=NWRSSD9999;
90   rename assets=NWassets;
91   rename complete=NWcomplete;
92   keep regid RSSD9001 RSSD9999 assets complete;
93   run;

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

94   
95   data cashvolcal;
96   set regid_info;
97   keep rssd9001 rssd9999 cash_growth;
98   if rssd9999>20120701 and rssd9999<=20170701;
99   run;

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

100  
101  proc means data=cashvolcal noprint;
102  by rssd9001;
103  var cash_growth;
104  output out=cashvol (drop=_type_ _freq_) std=cfvol;
105  run;

NOTE: There were 5084 observations read from the data set WORK.CASHVOLCAL.
NOTE: The data set WORK.CASHVOL has 292 observations and 2 variables.
NOTE: PROCEDURE MEANS used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds
      

106  
107  data cashvol;
108  set cashvol;
109  rename cfvol=NWcfvol;
110  rename RSSD9001=NWRSSD9001;
111  run;

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

112  
113  
114  data cashvolcal_fwd;
115  set regid_info;
116  keep rssd9001 rssd9999 cash_growth;
117  if rssd9999>20171001 and rssd9999<=20200701;
118  run;

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

119  
120  proc means data=cashvolcal_fwd noprint;
121  by rssd9001;
122  var cash_growth;
123  output out=cashvol_fwd (drop=_type_ _freq_) std=cfvol_fwd;
124  run;

NOTE: There were 1829 observations read from the data set WORK.CASHVOLCAL_FWD.
NOTE: The data set WORK.CASHVOL_FWD has 254 observations and 2 variables.
NOTE: PROCEDURE MEANS used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
      

125  
126  data cashvol_fwd;
127  set cashvol_fwd;
128  rename cfvol_fwd=NWcfvol_fwd;
129  rename RSSD9001=NWRSSD9001;
130  run;

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

131  
132  
133  data NWregid_info;
134  merge NWregid_info(in=a) cashvol cashvol_fwd;
135  by NWRSSD9001;
136  if a;
137  run;

NOTE: There were 8643 observations read from the data set WORK.NWREGID_INFO.
NOTE: There were 292 observations read from the data set WORK.CASHVOL.
NOTE: There were 254 observations read from the data set WORK.CASHVOL_FWD.
NOTE: The data set WORK.NWREGID_INFO has 8643 observations and 7 variables.
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds
      

138  
139  
140  data NWregid_info;
141  set NWregid_info;
142  NWLCR=ifn(NWRSSD9001=1039502 | NWRSSD9001=1073757 | NWRSSD9001=1111435 | NWRSSD9001=1120754 |
142!  NWRSSD9001=1951350 | NWRSSD9001=2380443 | NWRSSD9001=3587146 | NWRSSD9001=2162966,1,0);
143  NWLCR_stage2=ifn(NWRSSD9001=1069778 | NWRSSD9001=1119794 | NWRSSD9001=1199611,1,0);
144  NWLCR_stage3=ifn(NWRSSD9001=1037003 | NWRSSD9001=1068025 | NWRSSD9001=1068191 |
144! NWRSSD9001=1070345 | NWRSSD9001=1074156 | NWRSSD9001=1131787 | NWRSSD9001=1132449 |
144! NWRSSD9001=1562859 | NWRSSD9001=3242838,1,0);
145  NWLCR_stage2_3=ifn(NWRSSD9001=1069778 | NWRSSD9001=1119794 | NWRSSD9001=1199611 |
145! NWRSSD9001=1037003 | NWRSSD9001=1068025 | NWRSSD9001=1068191 | NWRSSD9001=1070345 |
145! NWRSSD9001=1074156 | NWRSSD9001=1131787 | NWRSSD9001=1132449 | NWRSSD9001=1562859 |
145! NWRSSD9001=3242838,1,0);
146  
147  
148  post=ifn(NWRSSD9999>20170401,1,0);
149  post_stage2=ifn(NWRSSD9999>20180401,1,0);
150  post_stage3=ifn(NWRSSD9999>20181001,1,0);
151  
152  post_1Q13=ifn(NWRSSD9999>20130101,1,0);
153  post_2Q13=ifn(NWRSSD9999>20130401,1,0);
154  post_4Q13=ifn(NWRSSD9999>20131001,1,0);
155  post_4Q14=ifn(NWRSSD9999>20141001,1,0);
156  
157  post_15=ifn(NWRSSD9999>20150101,1,0);
158  post_16=ifn(NWRSSD9999>20160101,1,0);
159  post_17=ifn(NWRSSD9999>20170101,1,0);
160  
161  in1Q11=ifn(NWRSSD9999>20110101 & NWRSSD9999<20110401,1,0);
162  in2Q11=ifn(NWRSSD9999>20110401 & NWRSSD9999<20110701,1,0);
163  in3Q11=ifn(NWRSSD9999>20110701 & NWRSSD9999<20111001 ,1,0);
164  in4Q11=ifn(NWRSSD9999>20111001 & NWRSSD9999<20120101 ,1,0);
165  
166  
167  in1Q12=ifn(NWRSSD9999>20120101 & NWRSSD9999<20120401,1,0);
168  in2Q12=ifn(NWRSSD9999>20120401 & NWRSSD9999<20120701,1,0);
169  in3Q12=ifn(NWRSSD9999>20120701 & NWRSSD9999<20121001 ,1,0);
170  in4Q12=ifn(NWRSSD9999>20121001 & NWRSSD9999<20130101 ,1,0);
171  
172  in1Q13=ifn(NWRSSD9999>20130101 & NWRSSD9999<20130401,1,0);
173  in2Q13=ifn(NWRSSD9999>20130401 & NWRSSD9999<20130701,1,0);
174  in3Q13=ifn(NWRSSD9999>20130701 & NWRSSD9999<20131001 ,1,0);
175  in4Q13=ifn(NWRSSD9999>20131001 & NWRSSD9999<20140101 ,1,0);
176  
177  in1Q14=ifn(NWRSSD9999>20140101 & NWRSSD9999<20140401,1,0);
178  in2Q14=ifn(NWRSSD9999>20140401 & NWRSSD9999<20140701,1,0);
179  in3Q14=ifn(NWRSSD9999>20140701 & NWRSSD9999<20141001 ,1,0);
180  in4Q14=ifn(NWRSSD9999>20141001 & NWRSSD9999<20150101 ,1,0);
181  in1Q15=ifn(NWRSSD9999>20150101 & NWRSSD9999<20150401 ,1,0);
182  in2Q15=ifn(NWRSSD9999>20150401 & NWRSSD9999<20150701 ,1,0);
183  in3Q15=ifn(NWRSSD9999>20150701 & NWRSSD9999<20151001 ,1,0);
184  in4Q15=ifn(NWRSSD9999>20151001 & NWRSSD9999<20160101 ,1,0);
185  in1Q16=ifn(NWRSSD9999>20160101 & NWRSSD9999<20160401 ,1,0);
186  in2Q16=ifn(NWRSSD9999>20160401 & NWRSSD9999<20160701 ,1,0);
187  in3Q16=ifn(NWRSSD9999>20160701 & NWRSSD9999<20161001 ,1,0);
188  in4Q16=ifn(NWRSSD9999>20161001 & NWRSSD9999<20170101 ,1,0);
189  in1Q17=ifn(NWRSSD9999>20170101 & NWRSSD9999<20170401 ,1,0);
190  in2Q17=ifn(NWRSSD9999>20170401 & NWRSSD9999<20170701 ,1,0);
191  in3Q17=ifn(NWRSSD9999>20170701 & NWRSSD9999<20171001 ,1,0);
192  in4Q17=ifn(NWRSSD9999>20171001 & NWRSSD9999<20180101 ,1,0);
193  in1Q18=ifn(NWRSSD9999>20180101 & NWRSSD9999<20180401 ,1,0);
194  in2Q18=ifn(NWRSSD9999>20180401 & NWRSSD9999<20180701 ,1,0);
195  in3Q18=ifn(NWRSSD9999>20180701 & NWRSSD9999<20181001 ,1,0);
196  in4Q18=ifn(NWRSSD9999>20181001 & NWRSSD9999<20190101 ,1,0);
197  in1Q19=ifn(NWRSSD9999>20190101 & NWRSSD9999<20190401 ,1,0);
198  in2Q19=ifn(NWRSSD9999>20190401 & NWRSSD9999<20190701 ,1,0);
199  in3Q19=ifn(NWRSSD9999>20190701 & NWRSSD9999<20191001 ,1,0);
200  in4Q19=ifn(NWRSSD9999>20191001 & NWRSSD9999<20200101 ,1,0);
201  
202  run;

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

203  
204  
205  proc sql;
206    create table nwdetails as
207    select  *
208    from nwstructure left join regid_info
209    on nwstructure.regid=regid_info.regid
210    order by regid_info.regid, regid_info.RSSD9999;
WARNING: Variable regid already exists on file WORK.NWDETAILS.
NOTE: Table WORK.NWDETAILS created, with 198771 rows and 191 columns.

211  quit;
NOTE: PROCEDURE SQL used (Total process time):
      real time           0.31 seconds
      cpu time            0.14 seconds
      

212  run;
213  
214  proc sql;
215    create table nwdetails2 as
216    select  *
217    from nwdetails left join NWregid_info
218    on nwdetails.NWregid=NWregid_info.NWregid
219      and nwdetails.RSSD9999=NWregid_info.NWRSSD9999
220    order by nwdetails.regid, nwdetails.RSSD9999;
WARNING: Variable NWregid already exists on file WORK.NWDETAILS2.
NOTE: Table WORK.NWDETAILS2 created, with 198771 rows and 247 columns.

221  quit;
NOTE: PROCEDURE SQL used (Total process time):
      real time           0.75 seconds
      cpu time            0.21 seconds
      

222  run;
223  
224  proc sql;
225    create table nwdetails3 as
226    select  *
227    from nwdetails2 left join nwstructure_yq
228    on nwdetails2.regid=nwstructure_yq.regid
229      and nwdetails2.y=nwstructure_yq.y
230      and nwdetails2.q=nwstructure_yq.q
231      and nwdetails2.NWregid=nwstructure_yq.NWregid
232    order by nwdetails2.regid, nwdetails2.RSSD9999;
WARNING: Variable regid already exists on file WORK.NWDETAILS3.
WARNING: Variable NWregid already exists on file WORK.NWDETAILS3.
WARNING: Variable y already exists on file WORK.NWDETAILS3.
WARNING: Variable q already exists on file WORK.NWDETAILS3.
NOTE: Table WORK.NWDETAILS3 created, with 198771 rows and 249 columns.

233  quit;
NOTE: PROCEDURE SQL used (Total process time):
      real time           0.91 seconds
      cpu time            0.20 seconds
      

234  run;
235  
236  data nwdetails;
237  set nwdetails3;
238  if weight_yq=. then weight_yq=0;
239  if weight_NWLeadArranger_yq=. then weight_NWLeadArranger_yq=0;
240  if weight_size=. then weight_size=0;
241  if weight_NWLeadArranger=. then weight_NWLeadArranger=0;
242  if connection=. then connection=0;
243  if connection_la=. then connection_la=0;
244  if NWLCR=. then NWLCR=0;
245  if NWLCR_stage2=. then NWLCR_stage2=0;
246  if NWLCR_stage3=. then NWLCR_stage3=0;
247  if NWLCR_stage2_3=. then NWLCR_stage2_3=0;
248  if complete=1 & NWcomplete=1 & RSSD9999> 20110101;
249  run;

NOTE: There were 198771 observations read from the data set WORK.NWDETAILS3.
NOTE: The data set WORK.NWDETAILS has 161752 observations and 250 variables.
NOTE: DATA statement used (Total process time):
      real time           0.27 seconds
      cpu time            0.03 seconds
      

250  
251  
252  proc sort data=nwdetails; by regid rssd9999 nwregid;run;

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

253  
254  data nwdetails;
255  set nwdetails;
256  weight_size=weight*log(NWassets);
257  run;

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).
      6414 at 256:19   6414 at 256:20   
NOTE: There were 161752 observations read from the data set WORK.NWDETAILS.
NOTE: The data set WORK.NWDETAILS has 161752 observations and 250 variables.
NOTE: DATA statement used (Total process time):
      real time           0.23 seconds
      cpu time            0.00 seconds
      

258  
259  /*export existing pairs*/
260  data existingpairs;
261  set nwdetails;
262  keep rssd9001 rssd9999 nwrssd9001 weight weight_NWLeadArranger;
263  run;

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

264  
265  proc sort data=existingpairs; by rssd9001 nwrssd9001 ;run;

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

266  data existingpairs;set existingpairs;by rssd9001 nwrssd9001; if last. nwrssd9001;run;

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

267  data existingpairs;set existingpairs; drop rssd9999;run;

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

268  
269  data build.existingpairs;set existingpairs;drop valid nwvalid; run;

WARNING: The variable valid in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable nwvalid in the DROP, KEEP, or RENAME list has never been referenced.
NOTE: There were 4920 observations read from the data set WORK.EXISTINGPAIRS.
NOTE: The data set BUILD.EXISTINGPAIRS has 4920 observations and 4 variables.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
      

270  
271  /*Calculate network measures*/
272  data calnw;
273  set nwdetails;
274  keep rssd9001 nwrssd9001 nwlcr nwlcr_stage2 nwlcr_stage3 nwlcr_stage2_3 weight weight_size
274! weight_NWLeadArranger connection connection_la NWcfvol NWcfvol_fwd;
275  run;

NOTE: There were 161752 observations read from the data set WORK.NWDETAILS.
NOTE: The data set WORK.CALNW has 161752 observations and 13 variables.
NOTE: DATA statement used (Total process time):
      real time           0.08 seconds
      cpu time            0.00 seconds
      

276  proc sort data=calnw; by rssd9001 nwrssd9001 ;run;

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

277  data calnw;set calnw;by rssd9001 nwrssd9001; if last. nwrssd9001;run;

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

278  
279  data calnw;
280  set calnw;
281  NWLCR_weight_raw=NWLCR*weight;
282  NWLCR_weight_size_raw=NWLCR*weight_size;
283  NWLCR_weight_LA_raw=NWLCR*weight_NWLeadArranger;
284  
285  NWLCR_stage2_weight_raw=NWLCR_stage2*weight;
286  NWLCR_stage2_weight_size_raw=NWLCR_stage2*weight_size;
287  NWLCR_stage2_weight_LA_raw=NWLCR_stage2*weight_NWLeadArranger;
288  
289  NWLCR_stage3_weight_raw=NWLCR_stage3*weight;
290  NWLCR_stage3_weight_size_raw=NWLCR_stage3*weight_size;
291  NWLCR_stage3_weight_LA_raw=NWLCR_stage3*weight_NWLeadArranger;
292  
293  NWLCR_stage2_3_weight_raw=NWLCR_stage2_3*weight;
294  
295  NWLCR_weight_cfvol_raw=NWLCR*weight*NWcfvol;
296  NWLCR_weight_cfvol_fwd_raw=NWLCR*weight*NWcfvol_fwd;
297  
298  NWLCR_weight_la_cfvol_raw=NWLCR*weight_NWLeadArranger*NWcfvol;
299  run;

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).
      764 at 282:28   764 at 286:42   764 at 290:42   182 at 295:36   315 at 296:40
      182 at 298:54   
NOTE: There were 4920 observations read from the data set WORK.CALNW.
NOTE: The data set WORK.CALNW has 4920 observations and 26 variables.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
      

300  
301  
302  proc means data=calnw noprint;
303  by rssd9001;
304  var weight weight_size weight_NWLeadArranger connection connection_la NWLCR_weight_raw
304! NWLCR_weight_size_raw NWLCR_weight_LA_raw NWLCR_stage2_weight_raw
304! NWLCR_stage2_weight_size_raw NWLCR_stage2_weight_LA_raw NWLCR_stage3_weight_raw
304! NWLCR_stage2_3_weight_raw NWLCR_stage3_weight_size_raw NWLCR_stage3_weight_LA_raw
304! NWLCR_weight_cfvol_raw NWLCR_weight_cfvol_fwd_raw NWLCR_weight_la_cfvol_raw;
305  output out=calnw sum=totalweight totalweight_size totalweight_LA totalconnection
305! totalconnection_la NWLCR_weight_raw NWLCR_weight_size_raw NWLCR_weight_LA_raw
305! NWLCR_stage2_weight_raw NWLCR_stage2_weight_size_raw NWLCR_stage2_weight_LA_raw
305! NWLCR_stage3_weight_raw NWLCR_stage2_3_weight_raw NWLCR_stage3_weight_size_raw
305! NWLCR_stage3_weight_LA_raw NWLCR_weight_cfvol_raw NWLCR_weight_cfvol_fwd_raw
305! NWLCR_weight_la_cfvol_raw;
306  run;

NOTE: There were 4920 observations read from the data set WORK.CALNW.
NOTE: The data set WORK.CALNW has 247 observations and 21 variables.
NOTE: PROCEDURE MEANS used (Total process time):
      real time           0.01 seconds
      cpu time            0.00 seconds
      

307  
308  data calnw ;
309  set calnw ;
310  NWLCR_weight=NWLCR_weight_raw/totalweight;
311  NWLCR_weight_size=NWLCR_weight_size_raw/totalweight_size;
312  NWLCR_weight_LA=NWLCR_weight_LA_raw/totalweight;
313  
314  NWLCR_stage2_weight=NWLCR_stage2_weight_raw/totalweight;
315  NWLCR_stage2_weight_size=NWLCR_stage2_weight_size_raw/totalweight_size;
316  NWLCR_stage2_weight_LA=NWLCR_stage2_weight_LA_raw/totalweight;
317  
318  NWLCR_stage3_weight=NWLCR_stage3_weight_raw/totalweight;
319  NWLCR_stage3_weight_size=NWLCR_stage3_weight_size_raw/totalweight_size;
320  NWLCR_stage3_weight_LA=NWLCR_stage3_weight_LA_raw/totalweight;
321  
322  NWLCR_stage2_3_weight=NWLCR_stage2_3_weight_raw/totalweight;
323  
324  NWLCR_weight_cfvol=ifn(NWLCR_weight_cfvol_raw/NWLCR_weight_raw~=.,NWLCR_weight_cfvol_raw/NWLC
324! R_weight_raw,0);
325  NWLCR_weight_cfvol_fwd=ifn(NWLCR_weight_cfvol_fwd_raw/NWLCR_weight_raw~=.,NWLCR_weight_cfvol_
325! fwd_raw/NWLCR_weight_raw,0);
326  
327  NWLCR_weight_la_cfvol=ifn(NWLCR_weight_la_cfvol_raw/NWLCR_weight_LA_raw~=.,NWLCR_weight_la_cf
327! vol_raw/NWLCR_weight_LA_raw,0);
328  
329  
330  keep rssd9001 NWLCR_weight NWLCR_weight_size NWLCR_weight_LA NWLCR_stage2_weight
330! NWLCR_stage2_weight_size NWLCR_stage2_weight_LA NWLCR_stage3_weight NWLCR_stage2_3_weight
330! NWLCR_stage3_weight_size NWLCR_stage3_weight_LA totalweight totalconnection
330! totalconnection_la totalweight_LA NWLCR_weight_cfvol NWLCR_weight_cfvol_fwd
330! NWLCR_weight_la_cfvol;
331  run;

NOTE: Division by zero detected at line 324 column 46.
NOTE: Division by zero detected at line 324 column 89.
NOTE: Division by zero detected at line 325 column 54.
NOTE: Division by zero detected at line 325 column 101.
NOTE: Division by zero detected at line 327 column 52.
NOTE: Division by zero detected at line 327 column 101.
RSSD9001=1020676 _TYPE_=0 _FREQ_=1 totalweight=1 totalweight_size=. totalweight_LA=0
totalconnection=1 totalconnection_la=0 NWLCR_weight_raw=0 NWLCR_weight_size_raw=.
NWLCR_weight_LA_raw=0 NWLCR_stage2_weight_raw=0 NWLCR_stage2_weight_size_raw=.
NWLCR_stage2_weight_LA_raw=0 NWLCR_stage3_weight_raw=0 NWLCR_stage2_3_weight_raw=0
NWLCR_stage3_weight_size_raw=. NWLCR_stage3_weight_LA_raw=0 NWLCR_weight_cfvol_raw=0
NWLCR_weight_cfvol_fwd_raw=0 NWLCR_weight_la_cfvol_raw=0 NWLCR_weight=0 NWLCR_weight_size=.
NWLCR_weight_LA=0 NWLCR_stage2_weight=0 NWLCR_stage2_weight_size=. NWLCR_stage2_weight_LA=0
NWLCR_stage3_weight=0 NWLCR_stage3_weight_size=. NWLCR_stage3_weight_LA=0 NWLCR_stage2_3_weight=0
NWLCR_weight_cfvol=0 NWLCR_weight_cfvol_fwd=0 NWLCR_weight_la_cfvol=0 _ERROR_=1 _N_=3
NOTE: Division by zero detected at line 324 column 46.
NOTE: Division by zero detected at line 324 column 89.
NOTE: Division by zero detected at line 325 column 54.
NOTE: Division by zero detected at line 325 column 101.
NOTE: Division by zero detected at line 327 column 52.
NOTE: Division by zero detected at line 327 column 101.
RSSD9001=1052220 _TYPE_=0 _FREQ_=6 totalweight=6 totalweight_size=88.47067909 totalweight_LA=0
totalconnection=6 totalconnection_la=0 NWLCR_weight_raw=0 NWLCR_weight_size_raw=0
NWLCR_weight_LA_raw=0 NWLCR_stage2_weight_raw=1 NWLCR_stage2_weight_size_raw=20.020928556
NWLCR_stage2_weight_LA_raw=0 NWLCR_stage3_weight_raw=1 NWLCR_stage2_3_weight_raw=2
NWLCR_stage3_weight_size_raw=18.796165101 NWLCR_stage3_weight_LA_raw=0 NWLCR_weight_cfvol_raw=0
NWLCR_weight_cfvol_fwd_raw=0 NWLCR_weight_la_cfvol_raw=0 NWLCR_weight=0 NWLCR_weight_size=0
NWLCR_weight_LA=0 NWLCR_stage2_weight=0.1666666667 NWLCR_stage2_weight_size=0.2263001569
NWLCR_stage2_weight_LA=0 NWLCR_stage3_weight=0.1666666667 NWLCR_stage3_weight_size=0.2124564352
NWLCR_stage3_weight_LA=0 NWLCR_stage2_3_weight=0.3333333333 NWLCR_weight_cfvol=0
NWLCR_weight_cfvol_fwd=0 NWLCR_weight_la_cfvol=0 _ERROR_=1 _N_=14
NOTE: Division by zero detected at line 327 column 52.
NOTE: Division by zero detected at line 327 column 101.
RSSD9001=1053496 _TYPE_=0 _FREQ_=5 totalweight=8 totalweight_size=152.27588559 totalweight_LA=3
totalconnection=5 totalconnection_la=2 NWLCR_weight_raw=2 NWLCR_weight_size_raw=42.783377759
NWLCR_weight_LA_raw=0 NWLCR_stage2_weight_raw=3 NWLCR_stage2_weight_size_raw=59.874434858
NWLCR_stage2_weight_LA_raw=3 NWLCR_stage3_weight_raw=0 NWLCR_stage2_3_weight_raw=3
NWLCR_stage3_weight_size_raw=0 NWLCR_stage3_weight_LA_raw=0 NWLCR_weight_cfvol_raw=0.2504182873
NWLCR_weight_cfvol_fwd_raw=0.1527550897 NWLCR_weight_la_cfvol_raw=0 NWLCR_weight=0.25
NWLCR_weight_size=0.2809596384 NWLCR_weight_LA=0 NWLCR_stage2_weight=0.375
NWLCR_stage2_weight_size=0.3931970885 NWLCR_stage2_weight_LA=0.375 NWLCR_stage3_weight=0
NWLCR_stage3_weight_size=0 NWLCR_stage3_weight_LA=0 NWLCR_stage2_3_weight=0.375
NWLCR_weight_cfvol=0.1252091436 NWLCR_weight_cfvol_fwd=0.0763775449 NWLCR_weight_la_cfvol=0
_ERROR_=1 _N_=15
NOTE: Division by zero detected at line 327 column 52.
NOTE: Division by zero detected at line 327 column 101.
RSSD9001=1058398 _TYPE_=0 _FREQ_=1 totalweight=1 totalweight_size=21.711832206 totalweight_LA=0
totalconnection=1 totalconnection_la=0 NWLCR_weight_raw=1 NWLCR_weight_size_raw=21.711832206
NWLCR_weight_LA_raw=0 NWLCR_stage2_weight_raw=0 NWLCR_stage2_weight_size_raw=0
NWLCR_stage2_weight_LA_raw=0 NWLCR_stage3_weight_raw=0 NWLCR_stage2_3_weight_raw=0
NWLCR_stage3_weight_size_raw=0 NWLCR_stage3_weight_LA_raw=0 NWLCR_weight_cfvol_raw=0.1864523334
NWLCR_weight_cfvol_fwd_raw=0.1191787169 NWLCR_weight_la_cfvol_raw=0 NWLCR_weight=1
NWLCR_weight_size=1 NWLCR_weight_LA=0 NWLCR_stage2_weight=0 NWLCR_stage2_weight_size=0
NWLCR_stage2_weight_LA=0 NWLCR_stage3_weight=0 NWLCR_stage3_weight_size=0 NWLCR_stage3_weight_LA=0
NWLCR_stage2_3_weight=0 NWLCR_weight_cfvol=0.1864523334 NWLCR_weight_cfvol_fwd=0.1191787169
NWLCR_weight_la_cfvol=0 _ERROR_=1 _N_=19
NOTE: Division by zero detected at line 324 column 46.
NOTE: Division by zero detected at line 324 column 89.
NOTE: Division by zero detected at line 325 column 54.
NOTE: Division by zero detected at line 325 column 101.
NOTE: Division by zero detected at line 327 column 52.
NOTE: Division by zero detected at line 327 column 101.
RSSD9001=1062135 _TYPE_=0 _FREQ_=4 totalweight=4 totalweight_size=47.997069613 totalweight_LA=0
totalconnection=4 totalconnection_la=0 NWLCR_weight_raw=0 NWLCR_weight_size_raw=0
NWLCR_weight_LA_raw=0 NWLCR_stage2_weight_raw=0 NWLCR_stage2_weight_size_raw=0
NWLCR_stage2_weight_LA_raw=0 NWLCR_stage3_weight_raw=0 NWLCR_stage2_3_weight_raw=0
NWLCR_stage3_weight_size_raw=0 NWLCR_stage3_weight_LA_raw=0 NWLCR_weight_cfvol_raw=0
NWLCR_weight_cfvol_fwd_raw=0 NWLCR_weight_la_cfvol_raw=0 NWLCR_weight=0 NWLCR_weight_size=0
NWLCR_weight_LA=0 NWLCR_stage2_weight=0 NWLCR_stage2_weight_size=0 NWLCR_stage2_weight_LA=0
NWLCR_stage3_weight=0 NWLCR_stage3_weight_size=0 NWLCR_stage3_weight_LA=0 NWLCR_stage2_3_weight=0
NWLCR_weight_cfvol=0 NWLCR_weight_cfvol_fwd=0 NWLCR_weight_la_cfvol=0 _ERROR_=1 _N_=22
NOTE: Division by zero detected at line 324 column 46.
NOTE: Division by zero detected at line 324 column 89.
NOTE: Division by zero detected at line 325 column 54.
NOTE: Division by zero detected at line 325 column 101.
NOTE: Division by zero detected at line 327 column 52.
NOTE: Division by zero detected at line 327 column 101.
RSSD9001=1066713 _TYPE_=0 _FREQ_=10 totalweight=15 totalweight_size=275.01316957 totalweight_LA=7
totalconnection=10 totalconnection_la=5 NWLCR_weight_raw=0 NWLCR_weight_size_raw=0
NWLCR_weight_LA_raw=0 NWLCR_stage2_weight_raw=6 NWLCR_stage2_weight_size_raw=117.36383953
NWLCR_stage2_weight_LA_raw=3 NWLCR_stage3_weight_raw=5 NWLCR_stage2_3_weight_raw=11
NWLCR_stage3_weight_size_raw=94.280824724 NWLCR_stage3_weight_LA_raw=4 NWLCR_weight_cfvol_raw=0
NWLCR_weight_cfvol_fwd_raw=0 NWLCR_weight_la_cfvol_raw=0 NWLCR_weight=0 NWLCR_weight_size=0
NWLCR_weight_LA=0 NWLCR_stage2_weight=0.4 NWLCR_stage2_weight_size=0.4267571612
NWLCR_stage2_weight_LA=0.2 NWLCR_stage3_weight=0.3333333333 NWLCR_stage3_weight_size=0.3428229451
NWLCR_stage3_weight_LA=0.2666666667 NWLCR_stage2_3_weight=0.7333333333 NWLCR_weight_cfvol=0
NWLCR_weight_cfvol_fwd=0 NWLCR_weight_la_cfvol=0 _ERROR_=1 _N_=25
NOTE: Division by zero detected at line 327 column 52.
NOTE: Division by zero detected at line 327 column 101.
RSSD9001=1070448 _TYPE_=0 _FREQ_=14 totalweight=44 totalweight_size=822.36273851 totalweight_LA=19
totalconnection=14 totalconnection_la=5 NWLCR_weight_raw=8 NWLCR_weight_size_raw=172.36540161
NWLCR_weight_LA_raw=0 NWLCR_stage2_weight_raw=12 NWLCR_stage2_weight_size_raw=238.17928375
NWLCR_stage2_weight_LA_raw=10 NWLCR_stage3_weight_raw=14 NWLCR_stage2_3_weight_raw=26
NWLCR_stage3_weight_size_raw=260.69412804 NWLCR_stage3_weight_LA_raw=6
NWLCR_weight_cfvol_raw=1.4382655486 NWLCR_weight_cfvol_fwd_raw=0.8579078798
NWLCR_weight_la_cfvol_raw=0 NWLCR_weight=0.1818181818 NWLCR_weight_size=0.2095977767
NWLCR_weight_LA=0 NWLCR_stage2_weight=0.2727272727 NWLCR_stage2_weight_size=0.2896280104
NWLCR_stage2_weight_LA=0.2272727273 NWLCR_stage3_weight=0.3181818182
NWLCR_stage3_weight_size=0.3170062502 NWLCR_stage3_weight_LA=0.1363636364
NWLCR_stage2_3_weight=0.5909090909 NWLCR_weight_cfvol=0.1797831936
NWLCR_weight_cfvol_fwd=0.107238485 NWLCR_weight_la_cfvol=0 _ERROR_=1 _N_=30
NOTE: Division by zero detected at line 327 column 52.
NOTE: Division by zero detected at line 327 column 101.
RSSD9001=1071397 _TYPE_=0 _FREQ_=21 totalweight=53 totalweight_size=908.14038229 totalweight_LA=19
totalconnection=21 totalconnection_la=5 NWLCR_weight_raw=5 NWLCR_weight_size_raw=107.92985327
NWLCR_weight_LA_raw=0 NWLCR_stage2_weight_raw=8 NWLCR_stage2_weight_size_raw=158.84897277
NWLCR_stage2_weight_LA_raw=7 NWLCR_stage3_weight_raw=24 NWLCR_stage2_3_weight_raw=32
NWLCR_stage3_weight_size_raw=450.68064042 NWLCR_stage3_weight_LA_raw=12
NWLCR_weight_cfvol_raw=0.6964028329 NWLCR_weight_cfvol_fwd_raw=0.5801041094
NWLCR_weight_la_cfvol_raw=0 NWLCR_weight=0.0943396226 NWLCR_weight_size=0.1188471027
NWLCR_weight_LA=0 NWLCR_stage2_weight=0.1509433962 NWLCR_stage2_weight_size=0.1749167594
NWLCR_stage2_weight_LA=0.1320754717 NWLCR_stage3_weight=0.4528301887
NWLCR_stage3_weight_size=0.4962675917 NWLCR_stage3_weight_LA=0.2264150943
NWLCR_stage2_3_weight=0.6037735849 NWLCR_weight_cfvol=0.1392805666
NWLCR_weight_cfvol_fwd=0.1160208219 NWLCR_weight_la_cfvol=0 _ERROR_=1 _N_=34
NOTE: Division by zero detected at line 324 column 46.
NOTE: Division by zero detected at line 324 column 89.
NOTE: Division by zero detected at line 325 column 54.
NOTE: Division by zero detected at line 325 column 101.
NOTE: Division by zero detected at line 327 column 52.
NOTE: Division by zero detected at line 327 column 101.
RSSD9001=1074156 _TYPE_=0 _FREQ_=1 totalweight=1 totalweight_size=19.243012524 totalweight_LA=1
totalconnection=1 totalconnection_la=1 NWLCR_weight_raw=0 NWLCR_weight_size_raw=0
NWLCR_weight_LA_raw=0 NWLCR_stage2_weight_raw=0 NWLCR_stage2_weight_size_raw=0
NWLCR_stage2_weight_LA_raw=0 NWLCR_stage3_weight_raw=1 NWLCR_stage2_3_weight_raw=1
NWLCR_stage3_weight_size_raw=19.243012524 NWLCR_stage3_weight_LA_raw=1 NWLCR_weight_cfvol_raw=0
NWLCR_weight_cfvol_fwd_raw=0 NWLCR_weight_la_cfvol_raw=0 NWLCR_weight=0 NWLCR_weight_size=0
NWLCR_weight_LA=0 NWLCR_stage2_weight=0 NWLCR_stage2_weight_size=0 NWLCR_stage2_weight_LA=0
NWLCR_stage3_weight=1 NWLCR_stage3_weight_size=1 NWLCR_stage3_weight_LA=1 NWLCR_stage2_3_weight=1
NWLCR_weight_cfvol=0 NWLCR_weight_cfvol_fwd=0 NWLCR_weight_la_cfvol=0 _ERROR_=1 _N_=36
NOTE: Division by zero detected at line 324 column 46.
NOTE: Division by zero detected at line 324 column 89.
NOTE: Division by zero detected at line 325 column 54.
NOTE: Division by zero detected at line 325 column 101.
NOTE: Division by zero detected at line 327 column 52.
NOTE: Division by zero detected at line 327 column 101.
RSSD9001=1085170 _TYPE_=0 _FREQ_=3 totalweight=3 totalweight_size=54.183762501 totalweight_LA=1
totalconnection=3 totalconnection_la=1 NWLCR_weight_raw=0 NWLCR_weight_size_raw=0
NWLCR_weight_LA_raw=0 NWLCR_stage2_weight_raw=0 NWLCR_stage2_weight_size_raw=0
NWLCR_stage2_weight_LA_raw=0 NWLCR_stage3_weight_raw=1 NWLCR_stage2_3_weight_raw=1
NWLCR_stage3_weight_size_raw=19.220573394 NWLCR_stage3_weight_LA_raw=1 NWLCR_weight_cfvol_raw=0
NWLCR_weight_cfvol_fwd_raw=0 NWLCR_weight_la_cfvol_raw=0 NWLCR_weight=0 NWLCR_weight_size=0
NWLCR_weight_LA=0 NWLCR_stage2_weight=0 NWLCR_stage2_weight_size=0 NWLCR_stage2_weight_LA=0
NWLCR_stage3_weight=0.3333333333 NWLCR_stage3_weight_size=0.3547293969
NWLCR_stage3_weight_LA=0.3333333333 NWLCR_stage2_3_weight=0.3333333333 NWLCR_weight_cfvol=0
NWLCR_weight_cfvol_fwd=0 NWLCR_weight_la_cfvol=0 _ERROR_=1 _N_=43
NOTE: Division by zero detected at line 327 column 52.
NOTE: Division by zero detected at line 327 column 101.
RSSD9001=1098648 _TYPE_=0 _FREQ_=12 totalweight=22 totalweight_size=329.39910141 totalweight_LA=2
totalconnection=12 totalconnection_la=1 NWLCR_weight_raw=2 NWLCR_weight_size_raw=43.225668576
NWLCR_weight_LA_raw=0 NWLCR_stage2_weight_raw=4 NWLCR_stage2_weight_size_raw=79.707012603
NWLCR_stage2_weight_LA_raw=2 NWLCR_stage3_weight_raw=4 NWLCR_stage2_3_weight_raw=8
NWLCR_stage3_weight_size_raw=74.905937596 NWLCR_stage3_weight_LA_raw=0
NWLCR_weight_cfvol_raw=0.2245576305 NWLCR_weight_cfvol_fwd_raw=0.2437514263
NWLCR_weight_la_cfvol_raw=0 NWLCR_weight=0.0909090909 NWLCR_weight_size=0.1312258242
NWLCR_weight_LA=0 NWLCR_stage2_weight=0.1818181818 NWLCR_stage2_weight_size=0.2419770189
NWLCR_stage2_weight_LA=0.0909090909 NWLCR_stage3_weight=0.1818181818
NWLCR_stage3_weight_size=0.2274017667 NWLCR_stage3_weight_LA=0 NWLCR_stage2_3_weight=0.3636363636
NWLCR_weight_cfvol=0.1122788152 NWLCR_weight_cfvol_fwd=0.1218757131 NWLCR_weight_la_cfvol=0
_ERROR_=1 _N_=54
NOTE: Division by zero detected at line 324 column 46.
NOTE: Division by zero detected at line 324 column 89.
NOTE: Division by zero detected at line 325 column 54.
NOTE: Division by zero detected at line 325 column 101.
NOTE: Division by zero detected at line 327 column 52.
NOTE: Division by zero detected at line 327 column 101.
RSSD9001=1106628 _TYPE_=0 _FREQ_=4 totalweight=4 totalweight_size=36.417382725 totalweight_LA=1
totalconnection=4 totalconnection_la=1 NWLCR_weight_raw=0 NWLCR_weight_size_raw=0
NWLCR_weight_LA_raw=0 NWLCR_stage2_weight_raw=1 NWLCR_stage2_weight_size_raw=20.020928556
NWLCR_stage2_weight_LA_raw=1 NWLCR_stage3_weight_raw=0 NWLCR_stage2_3_weight_raw=1
NWLCR_stage3_weight_size_raw=0 NWLCR_stage3_weight_LA_raw=0 NWLCR_weight_cfvol_raw=0
NWLCR_weight_cfvol_fwd_raw=0 NWLCR_weight_la_cfvol_raw=0 NWLCR_weight=0 NWLCR_weight_size=0
NWLCR_weight_LA=0 NWLCR_stage2_weight=0.25 NWLCR_stage2_weight_size=0.5497629719
NWLCR_stage2_weight_LA=0.25 NWLCR_stage3_weight=0 NWLCR_stage3_weight_size=0
NWLCR_stage3_weight_LA=0 NWLCR_stage2_3_weight=0.25 NWLCR_weight_cfvol=0 NWLCR_weight_cfvol_fwd=0
NWLCR_weight_la_cfvol=0 _ERROR_=1 _N_=57
NOTE: Division by zero detected at line 324 column 46.
NOTE: Division by zero detected at line 324 column 89.
NOTE: Division by zero detected at line 325 column 54.
NOTE: Division by zero detected at line 325 column 101.
NOTE: Division by zero detected at line 327 column 52.
NOTE: Division by zero detected at line 327 column 101.
RSSD9001=1108042 _TYPE_=0 _FREQ_=4 totalweight=6 totalweight_size=69.497541639 totalweight_LA=0
totalconnection=4 totalconnection_la=0 NWLCR_weight_raw=0 NWLCR_weight_size_raw=0
NWLCR_weight_LA_raw=0 NWLCR_stage2_weight_raw=0 NWLCR_stage2_weight_size_raw=0
NWLCR_stage2_weight_LA_raw=0 NWLCR_stage3_weight_raw=1 NWLCR_stage2_3_weight_raw=1
NWLCR_stage3_weight_size_raw=18.656803697 NWLCR_stage3_weight_LA_raw=0 NWLCR_weight_cfvol_raw=0
NWLCR_weight_cfvol_fwd_raw=0 NWLCR_weight_la_cfvol_raw=0 NWLCR_weight=0 NWLCR_weight_size=0
NWLCR_weight_LA=0 NWLCR_stage2_weight=0 NWLCR_stage2_weight_size=0 NWLCR_stage2_weight_LA=0
NWLCR_stage3_weight=0.1666666667 NWLCR_stage3_weight_size=0.2684527144 NWLCR_stage3_weight_LA=0
NWLCR_stage2_3_weight=0.1666666667 NWLCR_weight_cfvol=0 NWLCR_weight_cfvol_fwd=0
NWLCR_weight_la_cfvol=0 _ERROR_=1 _N_=59
NOTE: Division by zero detected at line 324 column 46.
NOTE: Division by zero detected at line 324 column 89.
NOTE: Division by zero detected at line 325 column 54.
NOTE: Division by zero detected at line 325 column 101.
NOTE: Division by zero detected at line 327 column 52.
NOTE: Division by zero detected at line 327 column 101.
RSSD9001=1109227 _TYPE_=0 _FREQ_=4 totalweight=4 totalweight_size=36.417382725 totalweight_LA=1
totalconnection=4 totalconnection_la=1 NWLCR_weight_raw=0 NWLCR_weight_size_raw=0
NWLCR_weight_LA_raw=0 NWLCR_stage2_weight_raw=1 NWLCR_stage2_weight_size_raw=20.020928556
NWLCR_stage2_weight_LA_raw=1 NWLCR_stage3_weight_raw=0 NWLCR_stage2_3_weight_raw=1
NWLCR_stage3_weight_size_raw=0 NWLCR_stage3_weight_LA_raw=0 NWLCR_weight_cfvol_raw=0
NWLCR_weight_cfvol_fwd_raw=0 NWLCR_weight_la_cfvol_raw=0 NWLCR_weight=0 NWLCR_weight_size=0
NWLCR_weight_LA=0 NWLCR_stage2_weight=0.25 NWLCR_stage2_weight_size=0.5497629719
NWLCR_stage2_weight_LA=0.25 NWLCR_stage3_weight=0 NWLCR_stage3_weight_size=0
NWLCR_stage3_weight_LA=0 NWLCR_stage2_3_weight=0.25 NWLCR_weight_cfvol=0 NWLCR_weight_cfvol_fwd=0
NWLCR_weight_la_cfvol=0 _ERROR_=1 _N_=62
NOTE: Division by zero detected at line 327 column 52.
NOTE: Division by zero detected at line 327 column 101.
RSSD9001=1116609 _TYPE_=0 _FREQ_=8 totalweight=9 totalweight_size=163.34515451 totalweight_LA=3
totalconnection=8 totalconnection_la=2 NWLCR_weight_raw=1 NWLCR_weight_size_raw=21.711832206
NWLCR_weight_LA_raw=0 NWLCR_stage2_weight_raw=2 NWLCR_stage2_weight_size_raw=39.66515549
NWLCR_stage2_weight_LA_raw=2 NWLCR_stage3_weight_raw=1 NWLCR_stage2_3_weight_raw=3
NWLCR_stage3_weight_size_raw=18.928039706 NWLCR_stage3_weight_LA_raw=1
NWLCR_weight_cfvol_raw=0.1864523334 NWLCR_weight_cfvol_fwd_raw=0.1191787169
NWLCR_weight_la_cfvol_raw=0 NWLCR_weight=0.1111111111 NWLCR_weight_size=0.1329199649
NWLCR_weight_LA=0 NWLCR_stage2_weight=0.2222222222 NWLCR_stage2_weight_size=0.242830316
NWLCR_stage2_weight_LA=0.2222222222 NWLCR_stage3_weight=0.1111111111
NWLCR_stage3_weight_size=0.1158775708 NWLCR_stage3_weight_LA=0.1111111111
NWLCR_stage2_3_weight=0.3333333333 NWLCR_weight_cfvol=0.1864523334
NWLCR_weight_cfvol_fwd=0.1191787169 NWLCR_weight_la_cfvol=0 _ERROR_=1 _N_=66
NOTE: Division by zero detected at line 327 column 52.
NOTE: Division by zero detected at line 327 column 101.
RSSD9001=1117512 _TYPE_=0 _FREQ_=11 totalweight=11 totalweight_size=148.47789805 totalweight_LA=2
totalconnection=11 totalconnection_la=2 NWLCR_weight_raw=1 NWLCR_weight_size_raw=21.379518197
NWLCR_weight_LA_raw=0 NWLCR_stage2_weight_raw=2 NWLCR_stage2_weight_size_raw=39.853506301
NWLCR_stage2_weight_LA_raw=1 NWLCR_stage3_weight_raw=3 NWLCR_stage2_3_weight_raw=5
NWLCR_stage3_weight_size_raw=56.326146186 NWLCR_stage3_weight_LA_raw=1
NWLCR_weight_cfvol_raw=0.1731140537 NWLCR_weight_cfvol_fwd_raw=0.0952982531
NWLCR_weight_la_cfvol_raw=0 NWLCR_weight=0.0909090909 NWLCR_weight_size=0.1439912504
NWLCR_weight_LA=0 NWLCR_stage2_weight=0.1818181818 NWLCR_stage2_weight_size=0.2684137291
NWLCR_stage2_weight_LA=0.0909090909 NWLCR_stage3_weight=0.2727272727
NWLCR_stage3_weight_size=0.3793571092 NWLCR_stage3_weight_LA=0.0909090909
NWLCR_stage2_3_weight=0.4545454545 NWLCR_weight_cfvol=0.1731140537
NWLCR_weight_cfvol_fwd=0.0952982531 NWLCR_weight_la_cfvol=0 _ERROR_=1 _N_=69
NOTE: Division by zero detected at line 327 column 52.
NOTE: Division by zero detected at line 327 column 101.
RSSD9001=1118265 _TYPE_=0 _FREQ_=15 totalweight=23 totalweight_size=294.33071622 totalweight_LA=5
totalconnection=15 totalconnection_la=3 NWLCR_weight_raw=2 NWLCR_weight_size_raw=41.139160576
NWLCR_weight_LA_raw=0 NWLCR_stage2_weight_raw=4 NWLCR_stage2_weight_size_raw=79.707012603
NWLCR_stage2_weight_LA_raw=2 NWLCR_stage3_weight_raw=6 NWLCR_stage2_3_weight_raw=10
NWLCR_stage3_weight_size_raw=112.45806865 NWLCR_stage3_weight_LA_raw=3
NWLCR_weight_cfvol_raw=0.3014063505 NWLCR_weight_cfvol_fwd_raw=0.2072245365
NWLCR_weight_la_cfvol_raw=0 NWLCR_weight=0.0869565217 NWLCR_weight_size=0.1397718903
NWLCR_weight_LA=0 NWLCR_stage2_weight=0.1739130435 NWLCR_stage2_weight_size=0.2708076603
NWLCR_stage2_weight_LA=0.0869565217 NWLCR_stage3_weight=0.2608695652
NWLCR_stage3_weight_size=0.3820806408 NWLCR_stage3_weight_LA=0.1304347826
NWLCR_stage2_3_weight=0.4347826087 NWLCR_weight_cfvol=0.1507031752
NWLCR_weight_cfvol_fwd=0.1036122683 NWLCR_weight_la_cfvol=0 _ERROR_=1 _N_=70
NOTE: Division by zero detected at line 327 column 52.
NOTE: Division by zero detected at line 327 column 101.
RSSD9001=1118434 _TYPE_=0 _FREQ_=14 totalweight=19 totalweight_size=213.00061626 totalweight_LA=4
totalconnection=14 totalconnection_la=3 NWLCR_weight_raw=2 NWLCR_weight_size_raw=41.139160576
NWLCR_weight_LA_raw=0 NWLCR_stage2_weight_raw=4 NWLCR_stage2_weight_size_raw=79.707012603
NWLCR_stage2_weight_LA_raw=2 NWLCR_stage3_weight_raw=4 NWLCR_stage2_3_weight_raw=8
NWLCR_stage3_weight_size_raw=75.254185892 NWLCR_stage3_weight_LA_raw=2
NWLCR_weight_cfvol_raw=0.3014063505 NWLCR_weight_cfvol_fwd_raw=0.2072245365
NWLCR_weight_la_cfvol_raw=0 NWLCR_weight=0.1052631579 NWLCR_weight_size=0.1931410401
NWLCR_weight_LA=0 NWLCR_stage2_weight=0.2105263158 NWLCR_stage2_weight_size=0.3742102441
NWLCR_stage2_weight_LA=0.1052631579 NWLCR_stage3_weight=0.2105263158
NWLCR_stage3_weight_size=0.3533050149 NWLCR_stage3_weight_LA=0.1052631579
NWLCR_stage2_3_weight=0.4210526316 NWLCR_weight_cfvol=0.1507031752
NWLCR_weight_cfvol_fwd=0.1036122683 NWLCR_weight_la_cfvol=0 _ERROR_=1 _N_=71
NOTE: Division by zero detected at line 327 column 52.
NOTE: Division by zero detected at line 327 column 101.
RSSD9001=1119495 _TYPE_=0 _FREQ_=12 totalweight=12 totalweight_size=179.07590561 totalweight_LA=1
totalconnection=12 totalconnection_la=1 NWLCR_weight_raw=1 NWLCR_weight_size_raw=21.612834288
NWLCR_weight_LA_raw=0 NWLCR_stage2_weight_raw=2 NWLCR_stage2_weight_size_raw=39.853506301
NWLCR_stage2_weight_LA_raw=1 NWLCR_stage3_weight_raw=2 NWLCR_stage2_3_weight_raw=4
NWLCR_stage3_weight_size_raw=37.452968798 NWLCR_stage3_weight_LA_raw=0
NWLCR_weight_cfvol_raw=0.1122788152 NWLCR_weight_cfvol_fwd_raw=0.1218757131
NWLCR_weight_la_cfvol_raw=0 NWLCR_weight=0.0833333333 NWLCR_weight_size=0.1206909116
NWLCR_weight_LA=0 NWLCR_stage2_weight=0.1666666667 NWLCR_stage2_weight_size=0.2225509131
NWLCR_stage2_weight_LA=0.0833333333 NWLCR_stage3_weight=0.1666666667
NWLCR_stage3_weight_size=0.2091457735 NWLCR_stage3_weight_LA=0 NWLCR_stage2_3_weight=0.3333333333
NWLCR_weight_cfvol=0.1122788152 NWLCR_weight_cfvol_fwd=0.1218757131 NWLCR_weight_la_cfvol=0
_ERROR_=1 _N_=73
NOTE: Division by zero detected at line 324 column 46.
NOTE: Division by zero detected at line 324 column 89.
NOTE: Division by zero detected at line 325 column 54.
NOTE: Division by zero detected at line 325 column 101.
NOTE: Division by zero detected at line 327 column 52.
NOTE: Division by zero detected at line 327 column 101.
WARNING: Limit set by ERRORS= option reached.  Further errors of this type will not be printed.
RSSD9001=1130931 _TYPE_=0 _FREQ_=1 totalweight=1 totalweight_size=18.506875146 totalweight_LA=1
totalconnection=1 totalconnection_la=1 NWLCR_weight_raw=0 NWLCR_weight_size_raw=0
NWLCR_weight_LA_raw=0 NWLCR_stage2_weight_raw=0 NWLCR_stage2_weight_size_raw=0
NWLCR_stage2_weight_LA_raw=0 NWLCR_stage3_weight_raw=1 NWLCR_stage2_3_weight_raw=1
NWLCR_stage3_weight_size_raw=18.506875146 NWLCR_stage3_weight_LA_raw=1 NWLCR_weight_cfvol_raw=0
NWLCR_weight_cfvol_fwd_raw=0 NWLCR_weight_la_cfvol_raw=0 NWLCR_weight=0 NWLCR_weight_size=0
NWLCR_weight_LA=0 NWLCR_stage2_weight=0 NWLCR_stage2_weight_size=0 NWLCR_stage2_weight_LA=0
NWLCR_stage3_weight=1 NWLCR_stage3_weight_size=1 NWLCR_stage3_weight_LA=1 NWLCR_stage2_3_weight=1
NWLCR_weight_cfvol=0 NWLCR_weight_cfvol_fwd=0 NWLCR_weight_la_cfvol=0 _ERROR_=1 _N_=79
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).
      3 at 311:40   3 at 315:54   3 at 319:54   
NOTE: Mathematical operations could not be performed at the following places. The results of the 
      operations have been set to missing values.
      Each place is given by: (Number of times) at (Line):(Column).
      69 at 324:46    69 at 324:89    69 at 325:54    69 at 325:101   94 at 327:52
      94 at 327:101   
NOTE: There were 247 observations read from the data set WORK.CALNW.
NOTE: The data set WORK.CALNW has 247 observations and 18 variables.
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      cpu time            0.00 seconds
      

332  
333  /*End of Calculate network measures*/
334  
335  data nwregvar;
336  set nwdetails;
337  keep RSSD9001 RSSD9999 y q liquid_growth liquid_ratio liq_currliab illiquid_ratio core_ratio
337! cash_growth capital_ratio
338   commit_ratio credit_growth loan_growth size post post_stage2 post_stage3 post_1Q13 post_2Q13
338!  post_4Q13 post_4Q14 post_15 post_16 post_17
339   in1Q11 in2Q11 in3Q11 in4Q11 in1Q12 in2Q12 in3Q12 in4Q12 in1Q13 in2Q13 in3Q13 in4Q13
340   in1Q14 in2Q14 in3Q14 in4Q14 in1Q15 in2Q15 in3Q15 in4Q15
341   in1Q16 in2Q16 in3Q16 in4Q16 in1Q17 in2Q17 in3Q17 in4Q17 in1Q18 in2Q18 in3Q18 in4Q18 in1Q19
341! in2Q19 in3Q19 in4Q19
342   NPL_rel LLP_rel IntRate EBP_rel NCO_rel ALL_rel Leverage assets liquid_assets dividend
342! dividend_2 tier1ratio capital_ratio loan_growth loan_growth_2 asset_growth illiquid_ratio
343   credit_growth loan_lease_rel htm_mbs_rel afs_mbs_rel htm_abs_rel afs_abs_rel commit_ratio
343! loans_ratio;
344  run;

NOTE: There were 161752 observations read from the data set WORK.NWDETAILS.
NOTE: The data set WORK.NWREGVAR has 161752 observations and 81 variables.
NOTE: DATA statement used (Total process time):
      real time           0.13 seconds
      cpu time            0.04 seconds
      

345  
346  proc sort data=nwregvar;by rssd9001 rssd9999;run;

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

347  data nwregvar;set nwregvar;by rssd9001 rssd9999; if first.rssd9999;run;

NOTE: There were 161752 observations read from the data set WORK.NWREGVAR.
NOTE: The data set WORK.NWREGVAR has 7745 observations and 81 variables.
NOTE: DATA statement used (Total process time):
      real time           0.04 seconds
      cpu time            0.00 seconds
      

348  
349  
350  proc means data=nwdetails noprint;
351  by rssd9001 rssd9999;
352  var weight_yq ;
353  output out=nwdetails_sum sum=weight_yq ;
354  run;

NOTE: There were 161752 observations read from the data set WORK.NWDETAILS.
NOTE: The data set WORK.NWDETAILS_SUM has 7745 observations and 5 variables.
NOTE: PROCEDURE MEANS used (Total process time):
      real time           0.08 seconds
      cpu time            0.00 seconds
      

355  
356  data nwregvar;
357  merge nwregvar nwdetails_sum;
358  by rssd9001 rssd9999;
359  run;

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

360  
361  data nwregvar;
362  set nwregvar;
363  rename weight_yq=totalweight_yq;
364  run;

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

365  
366  data nwregvar_sub;
367  set nwregvar;
368  keep RSSD9001 RSSD9999 totalweight_yq ;
369  run;

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

370  
371  data nwdetails;
372  merge nwdetails nwregvar_sub;
373  by RSSD9001 RSSD9999;
374  run;

NOTE: There were 161752 observations read from the data set WORK.NWDETAILS.
NOTE: There were 7745 observations read from the data set WORK.NWREGVAR_SUB.
NOTE: The data set WORK.NWDETAILS has 161752 observations and 251 variables.
NOTE: DATA statement used (Total process time):
      real time           0.21 seconds
      cpu time            0.06 seconds
      

375  
376  data nwdetails;
377  set nwdetails;
378  NWLCR_weight_yq=NWLCR*weight_yq/totalweight_yq;
379  NWLCR_stage2_weight_yq=NWLCR_stage2*weight_yq/totalweight_yq;
380  NWLCR_stage3_weight_yq=NWLCR_stage3*weight_yq/totalweight_yq;
381  
382  if NWLCR_weight_yq=. then NWLCR_weight_yq=0;
383  if NWLCR_stage2_weight_yq=. then NWLCR_stage2_weight_yq=0;
384  if NWLCR_stage3_weight_yq=. then NWLCR_stage3_weight_yq=0;
385  run;

NOTE: Division by zero detected at line 378 column 32.
NOTE: Division by zero detected at line 379 column 46.
NOTE: Division by zero detected at line 380 column 46.
regid=1020180 NWregid=1039502 weight=1 weight_NWLeadArranger=1
LenderUltiParent=Bremer Financial Corp connection=1 connection_la=1
rssd9017=BREMER FINANCIAL CORPORATION RSSD9001=1020180 RSSD9999=20110630 RSSD9032=9
BHCB2210=437886 BHCB2389=3802634 BHCB3187=431483 BHCB6648=1118145 BHCK0081=128854 BHCK0395=496650
BHCK0397=0 BHCK1754=323846 BHCK1773=1254292 BHCK2122=5398482 BHCK2170=7859920 BHCK3123=90943
BHCK3196=903 BHCK3210=780510 BHCK3411=60786 BHCK3506=0 BHCK3507=0 BHCK3521=0 BHCK3548=0
BHCK3814=307995 BHCK3816=135041 BHCK3817=0 BHCK4073=29372 BHCK4079=41266 BHCK4093=113839
BHCK4107=167786 BHCK4230=13297 BHCK4301=53447 BHCK4340=37030 BHCK4460=19200 BHCK4605=4223
BHCK4635=11930 BHCK5525=4757 BHCK5526=66424 BHCK6550=0 BHCK8274=781394 BHCKA223=5715657
BHCKB529=5292018 BHCKB989=0 BHCKB995=484938 BHCKC026=0 BHCKC027=0 BHCKG300=0 BHCKG303=231232
BHCKG304=0 BHCKG307=650162 BHCKG308=0 BHCKG311=0 BHCKG312=0 BHCKG315=207497 BHCKG316=0 BHCKG319=0
BHCKG320=0 BHCKG323=74403 BHCKG336=0 BHCKG339=0 BHCKG340=0 BHCKG343=0 BHCKG344=0 BHCKG347=0
BHCKJ457=709497 BHCKJ458=0 BHCKJ459=335879 BHCKK142=0 BHCKK145=0 BHCKK146=0 BHCKK149=0 BHCKK150=0
BHCKK153=0 BHCKK154=0 BHCKK157=0 BHDM6631=1112953 BHDM6636=5191241 BHDMB987=529 BHDMB993=0
BHFN6631=0 BHFN6636=0 BHOD2389=0 BHOD3187=0 BHOD3189=0 BHOD6648=0 RSSD9054=1231 RSSD9200=MN
RSSD9210=27 BHCA8274=. BHCAA223=. BHCBHK29=0 BHODHK29=0 BHCK1403=. BHCK1407=. BHCKHT58=.
BHCKHT61=. m_FYE=12 y=2011 q=2 m_F=6 y_F=2011 y_F_lag1=2011 m_F_lag1=3 HBCK3521=0 i=24 cash=625504
fedfund=529 revrepo=0 htm=323846 afs=1254292 htm_mbs=0 afs_mbs=1163294 htm_abs=0 afs_abs=0
assets=7859920 liquid_assets=1040877 liquid_ratio=0.1324284471 liquid_growth=-0.016437023
illiquid_assets=6455312 illiquid_ratio=0.8212948732 loan_lease_rel=0.6732915857 htm_mbs_rel=0
afs_mbs_rel=0.1480032876 htm_abs_rel=0 afs_abs_rel=0 core_deposits=4672003 core_ratio=0.5944084673
capital=780510 capital_ratio=0.0993025374 tier1cap=781394 RWA=5715657 tier1ratio=0.1367111427
commit=1549198 loans=5398482 credit=6947680 commit_assets=9409118 commit_ratio=0.1646485887
loans_ratio=0.6868367617 credit_growth=0.0114148943 loan_growth=0.0177961826
loan_growth_2=0.0266535243 asset_growth=-0.001972331 cash_growth=-0.13133493 NPL=71181
NPL_rel=0.0135368099 LLP_raw=13297 LLP=6898 LLP_rel=0.0013118236 IntIncome_raw=167786
IntIncome=84058 IntRate=0.0159856867 IntExpense_raw=29372 IntExpense=14258 NonIntIncome_raw=42169
NonIntIncome=20316 NonIntExpense_raw=113839 NonIntExpense=57107 NonIntExpense_lending=45991.340813
NonIntExpense_rest=11115.659187 EBT_raw=53447 EBT=26111 ROA=0.0051360574 ROE=0.0334537674
ROA_IntIncome=0.0039655186 ROA_NonIntIncome=0.0011705387 ROE_IntIncome=0.021666166
ROE_NonIntIncome=0.0117876015 EBP_raw=50327 EBP=25055 EBP_rel=0.0031814043 NCO_raw=7707 NCO=6459
NCO_rel=0.001228337 Dividend_raw=19200 Dividend_raw2=9600 Dividend=0.001825675
Dividend_2=0.0012189775 ALL=90943 ALL_rel=0.017295038 Leverage=0.9006974626 size=15.877286986
currliability=6789132 liq_currliab=0.1533151808 complete=1 NWRSSD9001=1039502 NWRSSD9999=20110630
NWassets=2246764000 NWcomplete=1 NWcfvol=0.1864523334 NWcfvol_fwd=0.1191787169 NWLCR=1
NWLCR_stage2=0 NWLCR_stage3=0 NWLCR_stage2_3=0 post=0 post_stage2=0 post_stage3=0 post_1Q13=0
post_2Q13=0 post_4Q13=0 post_4Q14=0 post_15=0 post_16=0 post_17=0 in1Q11=0 in2Q11=1 in3Q11=0
in4Q11=0 in1Q12=0 in2Q12=0 in3Q12=0 in4Q12=0 in1Q13=0 in2Q13=0 in3Q13=0 in4Q13=0 in1Q14=0 in2Q14=0
in3Q14=0 in4Q14=0 in1Q15=0 in2Q15=0 in3Q15=0 in4Q15=0 in1Q16=0 in2Q16=0 in3Q16=0 in4Q16=0 in1Q17=0
in2Q17=0 in3Q17=0 in4Q17=0 in1Q18=0 in2Q18=0 in3Q18=0 in4Q18=0 in1Q19=0 in2Q19=0 in3Q19=0 in4Q19=0
weight_yq=0 weight_NWLeadArranger_yq=0 weight_size=21.532756796 totalweight_yq=0 NWLCR_weight_yq=0
NWLCR_stage2_weight_yq=0 NWLCR_stage3_weight_yq=0 _ERROR_=1 _N_=18
NOTE: Division by zero detected at line 378 column 32.
NOTE: Division by zero detected at line 379 column 46.
NOTE: Division by zero detected at line 380 column 46.
regid=1020180 NWregid=1068025 weight=1 weight_NWLeadArranger=0
LenderUltiParent=Bremer Financial Corp connection=1 connection_la=0
rssd9017=BREMER FINANCIAL CORPORATION RSSD9001=1020180 RSSD9999=20110630 RSSD9032=9
BHCB2210=437886 BHCB2389=3802634 BHCB3187=431483 BHCB6648=1118145 BHCK0081=128854 BHCK0395=496650
BHCK0397=0 BHCK1754=323846 BHCK1773=1254292 BHCK2122=5398482 BHCK2170=7859920 BHCK3123=90943
BHCK3196=903 BHCK3210=780510 BHCK3411=60786 BHCK3506=0 BHCK3507=0 BHCK3521=0 BHCK3548=0
BHCK3814=307995 BHCK3816=135041 BHCK3817=0 BHCK4073=29372 BHCK4079=41266 BHCK4093=113839
BHCK4107=167786 BHCK4230=13297 BHCK4301=53447 BHCK4340=37030 BHCK4460=19200 BHCK4605=4223
BHCK4635=11930 BHCK5525=4757 BHCK5526=66424 BHCK6550=0 BHCK8274=781394 BHCKA223=5715657
BHCKB529=5292018 BHCKB989=0 BHCKB995=484938 BHCKC026=0 BHCKC027=0 BHCKG300=0 BHCKG303=231232
BHCKG304=0 BHCKG307=650162 BHCKG308=0 BHCKG311=0 BHCKG312=0 BHCKG315=207497 BHCKG316=0 BHCKG319=0
BHCKG320=0 BHCKG323=74403 BHCKG336=0 BHCKG339=0 BHCKG340=0 BHCKG343=0 BHCKG344=0 BHCKG347=0
BHCKJ457=709497 BHCKJ458=0 BHCKJ459=335879 BHCKK142=0 BHCKK145=0 BHCKK146=0 BHCKK149=0 BHCKK150=0
BHCKK153=0 BHCKK154=0 BHCKK157=0 BHDM6631=1112953 BHDM6636=5191241 BHDMB987=529 BHDMB993=0
BHFN6631=0 BHFN6636=0 BHOD2389=0 BHOD3187=0 BHOD3189=0 BHOD6648=0 RSSD9054=1231 RSSD9200=MN
RSSD9210=27 BHCA8274=. BHCAA223=. BHCBHK29=0 BHODHK29=0 BHCK1403=. BHCK1407=. BHCKHT58=.
BHCKHT61=. m_FYE=12 y=2011 q=2 m_F=6 y_F=2011 y_F_lag1=2011 m_F_lag1=3 HBCK3521=0 i=24 cash=625504
fedfund=529 revrepo=0 htm=323846 afs=1254292 htm_mbs=0 afs_mbs=1163294 htm_abs=0 afs_abs=0
assets=7859920 liquid_assets=1040877 liquid_ratio=0.1324284471 liquid_growth=-0.016437023
illiquid_assets=6455312 illiquid_ratio=0.8212948732 loan_lease_rel=0.6732915857 htm_mbs_rel=0
afs_mbs_rel=0.1480032876 htm_abs_rel=0 afs_abs_rel=0 core_deposits=4672003 core_ratio=0.5944084673
capital=780510 capital_ratio=0.0993025374 tier1cap=781394 RWA=5715657 tier1ratio=0.1367111427
commit=1549198 loans=5398482 credit=6947680 commit_assets=9409118 commit_ratio=0.1646485887
loans_ratio=0.6868367617 credit_growth=0.0114148943 loan_growth=0.0177961826
loan_growth_2=0.0266535243 asset_growth=-0.001972331 cash_growth=-0.13133493 NPL=71181
NPL_rel=0.0135368099 LLP_raw=13297 LLP=6898 LLP_rel=0.0013118236 IntIncome_raw=167786
IntIncome=84058 IntRate=0.0159856867 IntExpense_raw=29372 IntExpense=14258 NonIntIncome_raw=42169
NonIntIncome=20316 NonIntExpense_raw=113839 NonIntExpense=57107 NonIntExpense_lending=45991.340813
NonIntExpense_rest=11115.659187 EBT_raw=53447 EBT=26111 ROA=0.0051360574 ROE=0.0334537674
ROA_IntIncome=0.0039655186 ROA_NonIntIncome=0.0011705387 ROE_IntIncome=0.021666166
ROE_NonIntIncome=0.0117876015 EBP_raw=50327 EBP=25055 EBP_rel=0.0031814043 NCO_raw=7707 NCO=6459
NCO_rel=0.001228337 Dividend_raw=19200 Dividend_raw2=9600 Dividend=0.001825675
Dividend_2=0.0012189775 ALL=90943 ALL_rel=0.017295038 Leverage=0.9006974626 size=15.877286986
currliability=6789132 liq_currliab=0.1533151808 complete=1 NWRSSD9001=1068025 NWRSSD9999=20110630
NWassets=88858600 NWcomplete=1 NWcfvol=0.3508251075 NWcfvol_fwd=0.3471153284 NWLCR=0
NWLCR_stage2=0 NWLCR_stage3=1 NWLCR_stage2_3=1 post=0 post_stage2=0 post_stage3=0 post_1Q13=0
post_2Q13=0 post_4Q13=0 post_4Q14=0 post_15=0 post_16=0 post_17=0 in1Q11=0 in2Q11=1 in3Q11=0
in4Q11=0 in1Q12=0 in2Q12=0 in3Q12=0 in4Q12=0 in1Q13=0 in2Q13=0 in3Q13=0 in4Q13=0 in1Q14=0 in2Q14=0
in3Q14=0 in4Q14=0 in1Q15=0 in2Q15=0 in3Q15=0 in4Q15=0 in1Q16=0 in2Q16=0 in3Q16=0 in4Q16=0 in1Q17=0
in2Q17=0 in3Q17=0 in4Q17=0 in1Q18=0 in2Q18=0 in3Q18=0 in4Q18=0 in1Q19=0 in2Q19=0 in3Q19=0 in4Q19=0
weight_yq=0 weight_NWLeadArranger_yq=0 weight_size=18.3025569 totalweight_yq=0 NWLCR_weight_yq=0
NWLCR_stage2_weight_yq=0 NWLCR_stage3_weight_yq=0 _ERROR_=1 _N_=19
NOTE: Division by zero detected at line 378 column 32.
NOTE: Division by zero detected at line 379 column 46.
NOTE: Division by zero detected at line 380 column 46.
regid=1020180 NWregid=1068191 weight=3 weight_NWLeadArranger=2
LenderUltiParent=Bremer Financial Corp connection=1 connection_la=1
rssd9017=BREMER FINANCIAL CORPORATION RSSD9001=1020180 RSSD9999=20110630 RSSD9032=9
BHCB2210=437886 BHCB2389=3802634 BHCB3187=431483 BHCB6648=1118145 BHCK0081=128854 BHCK0395=496650
BHCK0397=0 BHCK1754=323846 BHCK1773=1254292 BHCK2122=5398482 BHCK2170=7859920 BHCK3123=90943
BHCK3196=903 BHCK3210=780510 BHCK3411=60786 BHCK3506=0 BHCK3507=0 BHCK3521=0 BHCK3548=0
BHCK3814=307995 BHCK3816=135041 BHCK3817=0 BHCK4073=29372 BHCK4079=41266 BHCK4093=113839
BHCK4107=167786 BHCK4230=13297 BHCK4301=53447 BHCK4340=37030 BHCK4460=19200 BHCK4605=4223
BHCK4635=11930 BHCK5525=4757 BHCK5526=66424 BHCK6550=0 BHCK8274=781394 BHCKA223=5715657
BHCKB529=5292018 BHCKB989=0 BHCKB995=484938 BHCKC026=0 BHCKC027=0 BHCKG300=0 BHCKG303=231232
BHCKG304=0 BHCKG307=650162 BHCKG308=0 BHCKG311=0 BHCKG312=0 BHCKG315=207497 BHCKG316=0 BHCKG319=0
BHCKG320=0 BHCKG323=74403 BHCKG336=0 BHCKG339=0 BHCKG340=0 BHCKG343=0 BHCKG344=0 BHCKG347=0
BHCKJ457=709497 BHCKJ458=0 BHCKJ459=335879 BHCKK142=0 BHCKK145=0 BHCKK146=0 BHCKK149=0 BHCKK150=0
BHCKK153=0 BHCKK154=0 BHCKK157=0 BHDM6631=1112953 BHDM6636=5191241 BHDMB987=529 BHDMB993=0
BHFN6631=0 BHFN6636=0 BHOD2389=0 BHOD3187=0 BHOD3189=0 BHOD6648=0 RSSD9054=1231 RSSD9200=MN
RSSD9210=27 BHCA8274=. BHCAA223=. BHCBHK29=0 BHODHK29=0 BHCK1403=. BHCK1407=. BHCKHT58=.
BHCKHT61=. m_FYE=12 y=2011 q=2 m_F=6 y_F=2011 y_F_lag1=2011 m_F_lag1=3 HBCK3521=0 i=24 cash=625504
fedfund=529 revrepo=0 htm=323846 afs=1254292 htm_mbs=0 afs_mbs=1163294 htm_abs=0 afs_abs=0
assets=7859920 liquid_assets=1040877 liquid_ratio=0.1324284471 liquid_growth=-0.016437023
illiquid_assets=6455312 illiquid_ratio=0.8212948732 loan_lease_rel=0.6732915857 htm_mbs_rel=0
afs_mbs_rel=0.1480032876 htm_abs_rel=0 afs_abs_rel=0 core_deposits=4672003 core_ratio=0.5944084673
capital=780510 capital_ratio=0.0993025374 tier1cap=781394 RWA=5715657 tier1ratio=0.1367111427
commit=1549198 loans=5398482 credit=6947680 commit_assets=9409118 commit_ratio=0.1646485887
loans_ratio=0.6868367617 credit_growth=0.0114148943 loan_growth=0.0177961826
loan_growth_2=0.0266535243 asset_growth=-0.001972331 cash_growth=-0.13133493 NPL=71181
NPL_rel=0.0135368099 LLP_raw=13297 LLP=6898 LLP_rel=0.0013118236 IntIncome_raw=167786
IntIncome=84058 IntRate=0.0159856867 IntExpense_raw=29372 IntExpense=14258 NonIntIncome_raw=42169
NonIntIncome=20316 NonIntExpense_raw=113839 NonIntExpense=57107 NonIntExpense_lending=45991.340813
NonIntExpense_rest=11115.659187 EBT_raw=53447 EBT=26111 ROA=0.0051360574 ROE=0.0334537674
ROA_IntIncome=0.0039655186 ROA_NonIntIncome=0.0011705387 ROE_IntIncome=0.021666166
ROE_NonIntIncome=0.0117876015 EBP_raw=50327 EBP=25055 EBP_rel=0.0031814043 NCO_raw=7707 NCO=6459
NCO_rel=0.001228337 Dividend_raw=19200 Dividend_raw2=9600 Dividend=0.001825675
Dividend_2=0.0012189775 ALL=90943 ALL_rel=0.017295038 Leverage=0.9006974626 size=15.877286986
currliability=6789132 liq_currliab=0.1533151808 complete=1 NWRSSD9001=1068191 NWRSSD9999=20110630
NWassets=53050039 NWcomplete=1 NWcfvol=0.2982314552 NWcfvol_fwd=0.4549932195 NWLCR=0
NWLCR_stage2=0 NWLCR_stage3=1 NWLCR_stage2_3=1 post=0 post_stage2=0 post_stage3=0 post_1Q13=0
post_2Q13=0 post_4Q13=0 post_4Q14=0 post_15=0 post_16=0 post_17=0 in1Q11=0 in2Q11=1 in3Q11=0
in4Q11=0 in1Q12=0 in2Q12=0 in3Q12=0 in4Q12=0 in1Q13=0 in2Q13=0 in3Q13=0 in4Q13=0 in1Q14=0 in2Q14=0
in3Q14=0 in4Q14=0 in1Q15=0 in2Q15=0 in3Q15=0 in4Q15=0 in1Q16=0 in2Q16=0 in3Q16=0 in4Q16=0 in1Q17=0
in2Q17=0 in3Q17=0 in4Q17=0 in1Q18=0 in2Q18=0 in3Q18=0 in4Q18=0 in1Q19=0 in2Q19=0 in3Q19=0 in4Q19=0
weight_yq=0 weight_NWLeadArranger_yq=0 weight_size=53.360238475 totalweight_yq=0 NWLCR_weight_yq=0
NWLCR_stage2_weight_yq=0 NWLCR_stage3_weight_yq=0 _ERROR_=1 _N_=20
NOTE: Division by zero detected at line 378 column 32.
NOTE: Division by zero detected at line 379 column 46.
NOTE: Division by zero detected at line 380 column 46.
regid=1020180 NWregid=1070345 weight=1 weight_NWLeadArranger=0
LenderUltiParent=Bremer Financial Corp connection=1 connection_la=0
rssd9017=BREMER FINANCIAL CORPORATION RSSD9001=1020180 RSSD9999=20110630 RSSD9032=9
BHCB2210=437886 BHCB2389=3802634 BHCB3187=431483 BHCB6648=1118145 BHCK0081=128854 BHCK0395=496650
BHCK0397=0 BHCK1754=323846 BHCK1773=1254292 BHCK2122=5398482 BHCK2170=7859920 BHCK3123=90943
BHCK3196=903 BHCK3210=780510 BHCK3411=60786 BHCK3506=0 BHCK3507=0 BHCK3521=0 BHCK3548=0
BHCK3814=307995 BHCK3816=135041 BHCK3817=0 BHCK4073=29372 BHCK4079=41266 BHCK4093=113839
BHCK4107=167786 BHCK4230=13297 BHCK4301=53447 BHCK4340=37030 BHCK4460=19200 BHCK4605=4223
BHCK4635=11930 BHCK5525=4757 BHCK5526=66424 BHCK6550=0 BHCK8274=781394 BHCKA223=5715657
BHCKB529=5292018 BHCKB989=0 BHCKB995=484938 BHCKC026=0 BHCKC027=0 BHCKG300=0 BHCKG303=231232
BHCKG304=0 BHCKG307=650162 BHCKG308=0 BHCKG311=0 BHCKG312=0 BHCKG315=207497 BHCKG316=0 BHCKG319=0
BHCKG320=0 BHCKG323=74403 BHCKG336=0 BHCKG339=0 BHCKG340=0 BHCKG343=0 BHCKG344=0 BHCKG347=0
BHCKJ457=709497 BHCKJ458=0 BHCKJ459=335879 BHCKK142=0 BHCKK145=0 BHCKK146=0 BHCKK149=0 BHCKK150=0
BHCKK153=0 BHCKK154=0 BHCKK157=0 BHDM6631=1112953 BHDM6636=5191241 BHDMB987=529 BHDMB993=0
BHFN6631=0 BHFN6636=0 BHOD2389=0 BHOD3187=0 BHOD3189=0 BHOD6648=0 RSSD9054=1231 RSSD9200=MN
RSSD9210=27 BHCA8274=. BHCAA223=. BHCBHK29=0 BHODHK29=0 BHCK1403=. BHCK1407=. BHCKHT58=.
BHCKHT61=. m_FYE=12 y=2011 q=2 m_F=6 y_F=2011 y_F_lag1=2011 m_F_lag1=3 HBCK3521=0 i=24 cash=625504
fedfund=529 revrepo=0 htm=323846 afs=1254292 htm_mbs=0 afs_mbs=1163294 htm_abs=0 afs_abs=0
assets=7859920 liquid_assets=1040877 liquid_ratio=0.1324284471 liquid_growth=-0.016437023
illiquid_assets=6455312 illiquid_ratio=0.8212948732 loan_lease_rel=0.6732915857 htm_mbs_rel=0
afs_mbs_rel=0.1480032876 htm_abs_rel=0 afs_abs_rel=0 core_deposits=4672003 core_ratio=0.5944084673
capital=780510 capital_ratio=0.0993025374 tier1cap=781394 RWA=5715657 tier1ratio=0.1367111427
commit=1549198 loans=5398482 credit=6947680 commit_assets=9409118 commit_ratio=0.1646485887
loans_ratio=0.6868367617 credit_growth=0.0114148943 loan_growth=0.0177961826
loan_growth_2=0.0266535243 asset_growth=-0.001972331 cash_growth=-0.13133493 NPL=71181
NPL_rel=0.0135368099 LLP_raw=13297 LLP=6898 LLP_rel=0.0013118236 IntIncome_raw=167786
IntIncome=84058 IntRate=0.0159856867 IntExpense_raw=29372 IntExpense=14258 NonIntIncome_raw=42169
NonIntIncome=20316 NonIntExpense_raw=113839 NonIntExpense=57107 NonIntExpense_lending=45991.340813
NonIntExpense_rest=11115.659187 EBT_raw=53447 EBT=26111 ROA=0.0051360574 ROE=0.0334537674
ROA_IntIncome=0.0039655186 ROA_NonIntIncome=0.0011705387 ROE_IntIncome=0.021666166
ROE_NonIntIncome=0.0117876015 EBP_raw=50327 EBP=25055 EBP_rel=0.0031814043 NCO_raw=7707 NCO=6459
NCO_rel=0.001228337 Dividend_raw=19200 Dividend_raw2=9600 Dividend=0.001825675
Dividend_2=0.0012189775 ALL=90943 ALL_rel=0.017295038 Leverage=0.9006974626 size=15.877286986
currliability=6789132 liq_currliab=0.1533151808 complete=1 NWRSSD9001=1070345 NWRSSD9999=20110630
NWassets=110804760 NWcomplete=1 NWcfvol=0.2985775823 NWcfvol_fwd=0.2119227112 NWLCR=0
NWLCR_stage2=0 NWLCR_stage3=1 NWLCR_stage2_3=1 post=0 post_stage2=0 post_stage3=0 post_1Q13=0
post_2Q13=0 post_4Q13=0 post_4Q14=0 post_15=0 post_16=0 post_17=0 in1Q11=0 in2Q11=1 in3Q11=0
in4Q11=0 in1Q12=0 in2Q12=0 in3Q12=0 in4Q12=0 in1Q13=0 in2Q13=0 in3Q13=0 in4Q13=0 in1Q14=0 in2Q14=0
in3Q14=0 in4Q14=0 in1Q15=0 in2Q15=0 in3Q15=0 in4Q15=0 in1Q16=0 in2Q16=0 in3Q16=0 in4Q16=0 in1Q17=0
in2Q17=0 in3Q17=0 in4Q17=0 in1Q18=0 in2Q18=0 in3Q18=0 in4Q18=0 in1Q19=0 in2Q19=0 in3Q19=0 in4Q19=0
weight_yq=0 weight_NWLeadArranger_yq=0 weight_size=18.523280292 totalweight_yq=0 NWLCR_weight_yq=0
NWLCR_stage2_weight_yq=0 NWLCR_stage3_weight_yq=0 _ERROR_=1 _N_=21
NOTE: Division by zero detected at line 378 column 32.
NOTE: Division by zero detected at line 379 column 46.
NOTE: Division by zero detected at line 380 column 46.
regid=1020180 NWregid=1073757 weight=3 weight_NWLeadArranger=1
LenderUltiParent=Bremer Financial Corp connection=1 connection_la=1
rssd9017=BREMER FINANCIAL CORPORATION RSSD9001=1020180 RSSD9999=20110630 RSSD9032=9
BHCB2210=437886 BHCB2389=3802634 BHCB3187=431483 BHCB6648=1118145 BHCK0081=128854 BHCK0395=496650
BHCK0397=0 BHCK1754=323846 BHCK1773=1254292 BHCK2122=5398482 BHCK2170=7859920 BHCK3123=90943
BHCK3196=903 BHCK3210=780510 BHCK3411=60786 BHCK3506=0 BHCK3507=0 BHCK3521=0 BHCK3548=0
BHCK3814=307995 BHCK3816=135041 BHCK3817=0 BHCK4073=29372 BHCK4079=41266 BHCK4093=113839
BHCK4107=167786 BHCK4230=13297 BHCK4301=53447 BHCK4340=37030 BHCK4460=19200 BHCK4605=4223
BHCK4635=11930 BHCK5525=4757 BHCK5526=66424 BHCK6550=0 BHCK8274=781394 BHCKA223=5715657
BHCKB529=5292018 BHCKB989=0 BHCKB995=484938 BHCKC026=0 BHCKC027=0 BHCKG300=0 BHCKG303=231232
BHCKG304=0 BHCKG307=650162 BHCKG308=0 BHCKG311=0 BHCKG312=0 BHCKG315=207497 BHCKG316=0 BHCKG319=0
BHCKG320=0 BHCKG323=74403 BHCKG336=0 BHCKG339=0 BHCKG340=0 BHCKG343=0 BHCKG344=0 BHCKG347=0
BHCKJ457=709497 BHCKJ458=0 BHCKJ459=335879 BHCKK142=0 BHCKK145=0 BHCKK146=0 BHCKK149=0 BHCKK150=0
BHCKK153=0 BHCKK154=0 BHCKK157=0 BHDM6631=1112953 BHDM6636=5191241 BHDMB987=529 BHDMB993=0
BHFN6631=0 BHFN6636=0 BHOD2389=0 BHOD3187=0 BHOD3189=0 BHOD6648=0 RSSD9054=1231 RSSD9200=MN
RSSD9210=27 BHCA8274=. BHCAA223=. BHCBHK29=0 BHODHK29=0 BHCK1403=. BHCK1407=. BHCKHT58=.
BHCKHT61=. m_FYE=12 y=2011 q=2 m_F=6 y_F=2011 y_F_lag1=2011 m_F_lag1=3 HBCK3521=0 i=24 cash=625504
fedfund=529 revrepo=0 htm=323846 afs=1254292 htm_mbs=0 afs_mbs=1163294 htm_abs=0 afs_abs=0
assets=7859920 liquid_assets=1040877 liquid_ratio=0.1324284471 liquid_growth=-0.016437023
illiquid_assets=6455312 illiquid_ratio=0.8212948732 loan_lease_rel=0.6732915857 htm_mbs_rel=0
afs_mbs_rel=0.1480032876 htm_abs_rel=0 afs_abs_rel=0 core_deposits=4672003 core_ratio=0.5944084673
capital=780510 capital_ratio=0.0993025374 tier1cap=781394 RWA=5715657 tier1ratio=0.1367111427
commit=1549198 loans=5398482 credit=6947680 commit_assets=9409118 commit_ratio=0.1646485887
loans_ratio=0.6868367617 credit_growth=0.0114148943 loan_growth=0.0177961826
loan_growth_2=0.0266535243 asset_growth=-0.001972331 cash_growth=-0.13133493 NPL=71181
NPL_rel=0.0135368099 LLP_raw=13297 LLP=6898 LLP_rel=0.0013118236 IntIncome_raw=167786
IntIncome=84058 IntRate=0.0159856867 IntExpense_raw=29372 IntExpense=14258 NonIntIncome_raw=42169
NonIntIncome=20316 NonIntExpense_raw=113839 NonIntExpense=57107 NonIntExpense_lending=45991.340813
NonIntExpense_rest=11115.659187 EBT_raw=53447 EBT=26111 ROA=0.0051360574 ROE=0.0334537674
ROA_IntIncome=0.0039655186 ROA_NonIntIncome=0.0011705387 ROE_IntIncome=0.021666166
ROE_NonIntIncome=0.0117876015 EBP_raw=50327 EBP=25055 EBP_rel=0.0031814043 NCO_raw=7707 NCO=6459
NCO_rel=0.001228337 Dividend_raw=19200 Dividend_raw2=9600 Dividend=0.001825675
Dividend_2=0.0012189775 ALL=90943 ALL_rel=0.017295038 Leverage=0.9006974626 size=15.877286986
currliability=6789132 liq_currliab=0.1533151808 complete=1 NWRSSD9001=1073757 NWRSSD9999=20110630
NWassets=2264435837 NWcomplete=1 NWcfvol=0.1122788152 NWcfvol_fwd=0.1218757131 NWLCR=1
NWLCR_stage2=0 NWLCR_stage3=0 NWLCR_stage2_3=0 post=0 post_stage2=0 post_stage3=0 post_1Q13=0
post_2Q13=0 post_4Q13=0 post_4Q14=0 post_15=0 post_16=0 post_17=0 in1Q11=0 in2Q11=1 in3Q11=0
in4Q11=0 in1Q12=0 in2Q12=0 in3Q12=0 in4Q12=0 in1Q13=0 in2Q13=0 in3Q13=0 in4Q13=0 in1Q14=0 in2Q14=0
in3Q14=0 in4Q14=0 in1Q15=0 in2Q15=0 in3Q15=0 in4Q15=0 in1Q16=0 in2Q16=0 in3Q16=0 in4Q16=0 in1Q17=0
in2Q17=0 in3Q17=0 in4Q17=0 in1Q18=0 in2Q18=0 in3Q18=0 in4Q18=0 in1Q19=0 in2Q19=0 in3Q19=0 in4Q19=0
weight_yq=0 weight_NWLeadArranger_yq=0 weight_size=64.621774459 totalweight_yq=0 NWLCR_weight_yq=0
NWLCR_stage2_weight_yq=0 NWLCR_stage3_weight_yq=0 _ERROR_=1 _N_=22
NOTE: Division by zero detected at line 378 column 32.
NOTE: Division by zero detected at line 379 column 46.
NOTE: Division by zero detected at line 380 column 46.
regid=1020180 NWregid=1119794 weight=14 weight_NWLeadArranger=12
LenderUltiParent=Bremer Financial Corp connection=1 connection_la=1
rssd9017=BREMER FINANCIAL CORPORATION RSSD9001=1020180 RSSD9999=20110630 RSSD9032=9
BHCB2210=437886 BHCB2389=3802634 BHCB3187=431483 BHCB6648=1118145 BHCK0081=128854 BHCK0395=496650
BHCK0397=0 BHCK1754=323846 BHCK1773=1254292 BHCK2122=5398482 BHCK2170=7859920 BHCK3123=90943
BHCK3196=903 BHCK3210=780510 BHCK3411=60786 BHCK3506=0 BHCK3507=0 BHCK3521=0 BHCK3548=0
BHCK3814=307995 BHCK3816=135041 BHCK3817=0 BHCK4073=29372 BHCK4079=41266 BHCK4093=113839
BHCK4107=167786 BHCK4230=13297 BHCK4301=53447 BHCK4340=37030 BHCK4460=19200 BHCK4605=4223
BHCK4635=11930 BHCK5525=4757 BHCK5526=66424 BHCK6550=0 BHCK8274=781394 BHCKA223=5715657
BHCKB529=5292018 BHCKB989=0 BHCKB995=484938 BHCKC026=0 BHCKC027=0 BHCKG300=0 BHCKG303=231232
BHCKG304=0 BHCKG307=650162 BHCKG308=0 BHCKG311=0 BHCKG312=0 BHCKG315=207497 BHCKG316=0 BHCKG319=0
BHCKG320=0 BHCKG323=74403 BHCKG336=0 BHCKG339=0 BHCKG340=0 BHCKG343=0 BHCKG344=0 BHCKG347=0
BHCKJ457=709497 BHCKJ458=0 BHCKJ459=335879 BHCKK142=0 BHCKK145=0 BHCKK146=0 BHCKK149=0 BHCKK150=0
BHCKK153=0 BHCKK154=0 BHCKK157=0 BHDM6631=1112953 BHDM6636=5191241 BHDMB987=529 BHDMB993=0
BHFN6631=0 BHFN6636=0 BHOD2389=0 BHOD3187=0 BHOD3189=0 BHOD6648=0 RSSD9054=1231 RSSD9200=MN
RSSD9210=27 BHCA8274=. BHCAA223=. BHCBHK29=0 BHODHK29=0 BHCK1403=. BHCK1407=. BHCKHT58=.
BHCKHT61=. m_FYE=12 y=2011 q=2 m_F=6 y_F=2011 y_F_lag1=2011 m_F_lag1=3 HBCK3521=0 i=24 cash=625504
fedfund=529 revrepo=0 htm=323846 afs=1254292 htm_mbs=0 afs_mbs=1163294 htm_abs=0 afs_abs=0
assets=7859920 liquid_assets=1040877 liquid_ratio=0.1324284471 liquid_growth=-0.016437023
illiquid_assets=6455312 illiquid_ratio=0.8212948732 loan_lease_rel=0.6732915857 htm_mbs_rel=0
afs_mbs_rel=0.1480032876 htm_abs_rel=0 afs_abs_rel=0 core_deposits=4672003 core_ratio=0.5944084673
capital=780510 capital_ratio=0.0993025374 tier1cap=781394 RWA=5715657 tier1ratio=0.1367111427
commit=1549198 loans=5398482 credit=6947680 commit_assets=9409118 commit_ratio=0.1646485887
loans_ratio=0.6868367617 credit_growth=0.0114148943 loan_growth=0.0177961826
loan_growth_2=0.0266535243 asset_growth=-0.001972331 cash_growth=-0.13133493 NPL=71181
NPL_rel=0.0135368099 LLP_raw=13297 LLP=6898 LLP_rel=0.0013118236 IntIncome_raw=167786
IntIncome=84058 IntRate=0.0159856867 IntExpense_raw=29372 IntExpense=14258 NonIntIncome_raw=42169
NonIntIncome=20316 NonIntExpense_raw=113839 NonIntExpense=57107 NonIntExpense_lending=45991.340813
NonIntExpense_rest=11115.659187 EBT_raw=53447 EBT=26111 ROA=0.0051360574 ROE=0.0334537674
ROA_IntIncome=0.0039655186 ROA_NonIntIncome=0.0011705387 ROE_IntIncome=0.021666166
ROE_NonIntIncome=0.0117876015 EBP_raw=50327 EBP=25055 EBP_rel=0.0031814043 NCO_raw=7707 NCO=6459
NCO_rel=0.001228337 Dividend_raw=19200 Dividend_raw2=9600 Dividend=0.001825675
Dividend_2=0.0012189775 ALL=90943 ALL_rel=0.017295038 Leverage=0.9006974626 size=15.877286986
currliability=6789132 liq_currliab=0.1533151808 complete=1 NWRSSD9001=1119794 NWRSSD9999=20110630
NWassets=320874000 NWcomplete=1 NWcfvol=0.4098794306 NWcfvol_fwd=0.1811613754 NWLCR=0
NWLCR_stage2=1 NWLCR_stage3=0 NWLCR_stage2_3=1 post=0 post_stage2=0 post_stage3=0 post_1Q13=0
post_2Q13=0 post_4Q13=0 post_4Q14=0 post_15=0 post_16=0 post_17=0 in1Q11=0 in2Q11=1 in3Q11=0
in4Q11=0 in1Q12=0 in2Q12=0 in3Q12=0 in4Q12=0 in1Q13=0 in2Q13=0 in3Q13=0 in4Q13=0 in1Q14=0 in2Q14=0
in3Q14=0 in4Q14=0 in1Q15=0 in2Q15=0 in3Q15=0 in4Q15=0 in1Q16=0 in2Q16=0 in3Q16=0 in4Q16=0 in1Q17=0
in2Q17=0 in3Q17=0 in4Q17=0 in1Q18=0 in2Q18=0 in3Q18=0 in4Q18=0 in1Q19=0 in2Q19=0 in3Q19=0 in4Q19=0
weight_yq=0 weight_NWLeadArranger_yq=0 weight_size=274.21182713 totalweight_yq=0 NWLCR_weight_yq=0
NWLCR_stage2_weight_yq=0 NWLCR_stage3_weight_yq=0 _ERROR_=1 _N_=23
NOTE: Division by zero detected at line 378 column 32.
NOTE: Division by zero detected at line 379 column 46.
NOTE: Division by zero detected at line 380 column 46.
regid=1020180 NWregid=1120754 weight=4 weight_NWLeadArranger=1
LenderUltiParent=Bremer Financial Corp connection=1 connection_la=1
rssd9017=BREMER FINANCIAL CORPORATION RSSD9001=1020180 RSSD9999=20110630 RSSD9032=9
BHCB2210=437886 BHCB2389=3802634 BHCB3187=431483 BHCB6648=1118145 BHCK0081=128854 BHCK0395=496650
BHCK0397=0 BHCK1754=323846 BHCK1773=1254292 BHCK2122=5398482 BHCK2170=7859920 BHCK3123=90943
BHCK3196=903 BHCK3210=780510 BHCK3411=60786 BHCK3506=0 BHCK3507=0 BHCK3521=0 BHCK3548=0
BHCK3814=307995 BHCK3816=135041 BHCK3817=0 BHCK4073=29372 BHCK4079=41266 BHCK4093=113839
BHCK4107=167786 BHCK4230=13297 BHCK4301=53447 BHCK4340=37030 BHCK4460=19200 BHCK4605=4223
BHCK4635=11930 BHCK5525=4757 BHCK5526=66424 BHCK6550=0 BHCK8274=781394 BHCKA223=5715657
BHCKB529=5292018 BHCKB989=0 BHCKB995=484938 BHCKC026=0 BHCKC027=0 BHCKG300=0 BHCKG303=231232
BHCKG304=0 BHCKG307=650162 BHCKG308=0 BHCKG311=0 BHCKG312=0 BHCKG315=207497 BHCKG316=0 BHCKG319=0
BHCKG320=0 BHCKG323=74403 BHCKG336=0 BHCKG339=0 BHCKG340=0 BHCKG343=0 BHCKG344=0 BHCKG347=0
BHCKJ457=709497 BHCKJ458=0 BHCKJ459=335879 BHCKK142=0 BHCKK145=0 BHCKK146=0 BHCKK149=0 BHCKK150=0
BHCKK153=0 BHCKK154=0 BHCKK157=0 BHDM6631=1112953 BHDM6636=5191241 BHDMB987=529 BHDMB993=0
BHFN6631=0 BHFN6636=0 BHOD2389=0 BHOD3187=0 BHOD3189=0 BHOD6648=0 RSSD9054=1231 RSSD9200=MN
RSSD9210=27 BHCA8274=. BHCAA223=. BHCBHK29=0 BHODHK29=0 BHCK1403=. BHCK1407=. BHCKHT58=.
BHCKHT61=. m_FYE=12 y=2011 q=2 m_F=6 y_F=2011 y_F_lag1=2011 m_F_lag1=3 HBCK3521=0 i=24 cash=625504
fedfund=529 revrepo=0 htm=323846 afs=1254292 htm_mbs=0 afs_mbs=1163294 htm_abs=0 afs_abs=0
assets=7859920 liquid_assets=1040877 liquid_ratio=0.1324284471 liquid_growth=-0.016437023
illiquid_assets=6455312 illiquid_ratio=0.8212948732 loan_lease_rel=0.6732915857 htm_mbs_rel=0
afs_mbs_rel=0.1480032876 htm_abs_rel=0 afs_abs_rel=0 core_deposits=4672003 core_ratio=0.5944084673
capital=780510 capital_ratio=0.0993025374 tier1cap=781394 RWA=5715657 tier1ratio=0.1367111427
commit=1549198 loans=5398482 credit=6947680 commit_assets=9409118 commit_ratio=0.1646485887
loans_ratio=0.6868367617 credit_growth=0.0114148943 loan_growth=0.0177961826
loan_growth_2=0.0266535243 asset_growth=-0.001972331 cash_growth=-0.13133493 NPL=71181
NPL_rel=0.0135368099 LLP_raw=13297 LLP=6898 LLP_rel=0.0013118236 IntIncome_raw=167786
IntIncome=84058 IntRate=0.0159856867 IntExpense_raw=29372 IntExpense=14258 NonIntIncome_raw=42169
NonIntIncome=20316 NonIntExpense_raw=113839 NonIntExpense=57107 NonIntExpense_lending=45991.340813
NonIntExpense_rest=11115.659187 EBT_raw=53447 EBT=26111 ROA=0.0051360574 ROE=0.0334537674
ROA_IntIncome=0.0039655186 ROA_NonIntIncome=0.0011705387 ROE_IntIncome=0.021666166
ROE_NonIntIncome=0.0117876015 EBP_raw=50327 EBP=25055 EBP_rel=0.0031814043 NCO_raw=7707 NCO=6459
NCO_rel=0.001228337 Dividend_raw=19200 Dividend_raw2=9600 Dividend=0.001825675
Dividend_2=0.0012189775 ALL=90943 ALL_rel=0.017295038 Leverage=0.9006974626 size=15.877286986
currliability=6789132 liq_currliab=0.1533151808 complete=1 NWRSSD9001=1120754 NWRSSD9999=20110630
NWassets=1259734000 NWcomplete=1 NWcfvol=0.1731140537 NWcfvol_fwd=0.0952982531 NWLCR=1
NWLCR_stage2=0 NWLCR_stage3=0 NWLCR_stage2_3=0 post=0 post_stage2=0 post_stage3=0 post_1Q13=0
post_2Q13=0 post_4Q13=0 post_4Q14=0 post_15=0 post_16=0 post_17=0 in1Q11=0 in2Q11=1 in3Q11=0
in4Q11=0 in1Q12=0 in2Q12=0 in3Q12=0 in4Q12=0 in1Q13=0 in2Q13=0 in3Q13=0 in4Q13=0 in1Q14=0 in2Q14=0
in3Q14=0 in4Q14=0 in1Q15=0 in2Q15=0 in3Q15=0 in4Q15=0 in1Q16=0 in2Q16=0 in3Q16=0 in4Q16=0 in1Q17=0
in2Q17=0 in3Q17=0 in4Q17=0 in1Q18=0 in2Q18=0 in3Q18=0 in4Q18=0 in1Q19=0 in2Q19=0 in3Q19=0 in4Q19=0
weight_yq=0 weight_NWLeadArranger_yq=0 weight_size=83.816665698 totalweight_yq=0 NWLCR_weight_yq=0
NWLCR_stage2_weight_yq=0 NWLCR_stage3_weight_yq=0 _ERROR_=1 _N_=24
NOTE: Division by zero detected at line 378 column 32.
NOTE: Division by zero detected at line 379 column 46.
NOTE: Division by zero detected at line 380 column 46.
regid=1020180 NWregid=1127650 weight=1 weight_NWLeadArranger=0
LenderUltiParent=Bremer Financial Corp connection=1 connection_la=0
rssd9017=BREMER FINANCIAL CORPORATION RSSD9001=1020180 RSSD9999=20110630 RSSD9032=9
BHCB2210=437886 BHCB2389=3802634 BHCB3187=431483 BHCB6648=1118145 BHCK0081=128854 BHCK0395=496650
BHCK0397=0 BHCK1754=323846 BHCK1773=1254292 BHCK2122=5398482 BHCK2170=7859920 BHCK3123=90943
BHCK3196=903 BHCK3210=780510 BHCK3411=60786 BHCK3506=0 BHCK3507=0 BHCK3521=0 BHCK3548=0
BHCK3814=307995 BHCK3816=135041 BHCK3817=0 BHCK4073=29372 BHCK4079=41266 BHCK4093=113839
BHCK4107=167786 BHCK4230=13297 BHCK4301=53447 BHCK4340=37030 BHCK4460=19200 BHCK4605=4223
BHCK4635=11930 BHCK5525=4757 BHCK5526=66424 BHCK6550=0 BHCK8274=781394 BHCKA223=5715657
BHCKB529=5292018 BHCKB989=0 BHCKB995=484938 BHCKC026=0 BHCKC027=0 BHCKG300=0 BHCKG303=231232
BHCKG304=0 BHCKG307=650162 BHCKG308=0 BHCKG311=0 BHCKG312=0 BHCKG315=207497 BHCKG316=0 BHCKG319=0
BHCKG320=0 BHCKG323=74403 BHCKG336=0 BHCKG339=0 BHCKG340=0 BHCKG343=0 BHCKG344=0 BHCKG347=0
BHCKJ457=709497 BHCKJ458=0 BHCKJ459=335879 BHCKK142=0 BHCKK145=0 BHCKK146=0 BHCKK149=0 BHCKK150=0
BHCKK153=0 BHCKK154=0 BHCKK157=0 BHDM6631=1112953 BHDM6636=5191241 BHDMB987=529 BHDMB993=0
BHFN6631=0 BHFN6636=0 BHOD2389=0 BHOD3187=0 BHOD3189=0 BHOD6648=0 RSSD9054=1231 RSSD9200=MN
RSSD9210=27 BHCA8274=. BHCAA223=. BHCBHK29=0 BHODHK29=0 BHCK1403=. BHCK1407=. BHCKHT58=.
BHCKHT61=. m_FYE=12 y=2011 q=2 m_F=6 y_F=2011 y_F_lag1=2011 m_F_lag1=3 HBCK3521=0 i=24 cash=625504
fedfund=529 revrepo=0 htm=323846 afs=1254292 htm_mbs=0 afs_mbs=1163294 htm_abs=0 afs_abs=0
assets=7859920 liquid_assets=1040877 liquid_ratio=0.1324284471 liquid_growth=-0.016437023
illiquid_assets=6455312 illiquid_ratio=0.8212948732 loan_lease_rel=0.6732915857 htm_mbs_rel=0
afs_mbs_rel=0.1480032876 htm_abs_rel=0 afs_abs_rel=0 core_deposits=4672003 core_ratio=0.5944084673
capital=780510 capital_ratio=0.0993025374 tier1cap=781394 RWA=5715657 tier1ratio=0.1367111427
commit=1549198 loans=5398482 credit=6947680 commit_assets=9409118 commit_ratio=0.1646485887
loans_ratio=0.6868367617 credit_growth=0.0114148943 loan_growth=0.0177961826
loan_growth_2=0.0266535243 asset_growth=-0.001972331 cash_growth=-0.13133493 NPL=71181
NPL_rel=0.0135368099 LLP_raw=13297 LLP=6898 LLP_rel=0.0013118236 IntIncome_raw=167786
IntIncome=84058 IntRate=0.0159856867 IntExpense_raw=29372 IntExpense=14258 NonIntIncome_raw=42169
NonIntIncome=20316 NonIntExpense_raw=113839 NonIntExpense=57107 NonIntExpense_lending=45991.340813
NonIntExpense_rest=11115.659187 EBT_raw=53447 EBT=26111 ROA=0.0051360574 ROE=0.0334537674
ROA_IntIncome=0.0039655186 ROA_NonIntIncome=0.0011705387 ROE_IntIncome=0.021666166
ROE_NonIntIncome=0.0117876015 EBP_raw=50327 EBP=25055 EBP_rel=0.0031814043 NCO_raw=7707 NCO=6459
NCO_rel=0.001228337 Dividend_raw=19200 Dividend_raw2=9600 Dividend=0.001825675
Dividend_2=0.0012189775 ALL=90943 ALL_rel=0.017295038 Leverage=0.9006974626 size=15.877286986
currliability=6789132 liq_currliab=0.1533151808 complete=1 NWRSSD9001=1127650 NWRSSD9999=20110630
NWassets=672080 NWcomplete=1 NWcfvol=0.8320521341 NWcfvol_fwd=0.2522180593 NWLCR=0 NWLCR_stage2=0
NWLCR_stage3=0 NWLCR_stage2_3=0 post=0 post_stage2=0 post_stage3=0 post_1Q13=0 post_2Q13=0
post_4Q13=0 post_4Q14=0 post_15=0 post_16=0 post_17=0 in1Q11=0 in2Q11=1 in3Q11=0 in4Q11=0 in1Q12=0
in2Q12=0 in3Q12=0 in4Q12=0 in1Q13=0 in2Q13=0 in3Q13=0 in4Q13=0 in1Q14=0 in2Q14=0 in3Q14=0 in4Q14=0
in1Q15=0 in2Q15=0 in3Q15=0 in4Q15=0 in1Q16=0 in2Q16=0 in3Q16=0 in4Q16=0 in1Q17=0 in2Q17=0 in3Q17=0
in4Q17=0 in1Q18=0 in2Q18=0 in3Q18=0 in4Q18=0 in1Q19=0 in2Q19=0 in3Q19=0 in4Q19=0 weight_yq=0
weight_NWLeadArranger_yq=0 weight_size=13.41813266 totalweight_yq=0 NWLCR_weight_yq=0
NWLCR_stage2_weight_yq=0 NWLCR_stage3_weight_yq=0 _ERROR_=1 _N_=25
NOTE: Division by zero detected at line 378 column 32.
NOTE: Division by zero detected at line 379 column 46.
NOTE: Division by zero detected at line 380 column 46.
regid=1020180 NWregid=1132449 weight=4 weight_NWLeadArranger=0
LenderUltiParent=Bremer Financial Corp connection=1 connection_la=0
rssd9017=BREMER FINANCIAL CORPORATION RSSD9001=1020180 RSSD9999=20110630 RSSD9032=9
BHCB2210=437886 BHCB2389=3802634 BHCB3187=431483 BHCB6648=1118145 BHCK0081=128854 BHCK0395=496650
BHCK0397=0 BHCK1754=323846 BHCK1773=1254292 BHCK2122=5398482 BHCK2170=7859920 BHCK3123=90943
BHCK3196=903 BHCK3210=780510 BHCK3411=60786 BHCK3506=0 BHCK3507=0 BHCK3521=0 BHCK3548=0
BHCK3814=307995 BHCK3816=135041 BHCK3817=0 BHCK4073=29372 BHCK4079=41266 BHCK4093=113839
BHCK4107=167786 BHCK4230=13297 BHCK4301=53447 BHCK4340=37030 BHCK4460=19200 BHCK4605=4223
BHCK4635=11930 BHCK5525=4757 BHCK5526=66424 BHCK6550=0 BHCK8274=781394 BHCKA223=5715657
BHCKB529=5292018 BHCKB989=0 BHCKB995=484938 BHCKC026=0 BHCKC027=0 BHCKG300=0 BHCKG303=231232
BHCKG304=0 BHCKG307=650162 BHCKG308=0 BHCKG311=0 BHCKG312=0 BHCKG315=207497 BHCKG316=0 BHCKG319=0
BHCKG320=0 BHCKG323=74403 BHCKG336=0 BHCKG339=0 BHCKG340=0 BHCKG343=0 BHCKG344=0 BHCKG347=0
BHCKJ457=709497 BHCKJ458=0 BHCKJ459=335879 BHCKK142=0 BHCKK145=0 BHCKK146=0 BHCKK149=0 BHCKK150=0
BHCKK153=0 BHCKK154=0 BHCKK157=0 BHDM6631=1112953 BHDM6636=5191241 BHDMB987=529 BHDMB993=0
BHFN6631=0 BHFN6636=0 BHOD2389=0 BHOD3187=0 BHOD3189=0 BHOD6648=0 RSSD9054=1231 RSSD9200=MN
RSSD9210=27 BHCA8274=. BHCAA223=. BHCBHK29=0 BHODHK29=0 BHCK1403=. BHCK1407=. BHCKHT58=.
BHCKHT61=. m_FYE=12 y=2011 q=2 m_F=6 y_F=2011 y_F_lag1=2011 m_F_lag1=3 HBCK3521=0 i=24 cash=625504
fedfund=529 revrepo=0 htm=323846 afs=1254292 htm_mbs=0 afs_mbs=1163294 htm_abs=0 afs_abs=0
assets=7859920 liquid_assets=1040877 liquid_ratio=0.1324284471 liquid_growth=-0.016437023
illiquid_assets=6455312 illiquid_ratio=0.8212948732 loan_lease_rel=0.6732915857 htm_mbs_rel=0
afs_mbs_rel=0.1480032876 htm_abs_rel=0 afs_abs_rel=0 core_deposits=4672003 core_ratio=0.5944084673
capital=780510 capital_ratio=0.0993025374 tier1cap=781394 RWA=5715657 tier1ratio=0.1367111427
commit=1549198 loans=5398482 credit=6947680 commit_assets=9409118 commit_ratio=0.1646485887
loans_ratio=0.6868367617 credit_growth=0.0114148943 loan_growth=0.0177961826
loan_growth_2=0.0266535243 asset_growth=-0.001972331 cash_growth=-0.13133493 NPL=71181
NPL_rel=0.0135368099 LLP_raw=13297 LLP=6898 LLP_rel=0.0013118236 IntIncome_raw=167786
IntIncome=84058 IntRate=0.0159856867 IntExpense_raw=29372 IntExpense=14258 NonIntIncome_raw=42169
NonIntIncome=20316 NonIntExpense_raw=113839 NonIntExpense=57107 NonIntExpense_lending=45991.340813
NonIntExpense_rest=11115.659187 EBT_raw=53447 EBT=26111 ROA=0.0051360574 ROE=0.0334537674
ROA_IntIncome=0.0039655186 ROA_NonIntIncome=0.0011705387 ROE_IntIncome=0.021666166
ROE_NonIntIncome=0.0117876015 EBP_raw=50327 EBP=25055 EBP_rel=0.0031814043 NCO_raw=7707 NCO=6459
NCO_rel=0.001228337 Dividend_raw=19200 Dividend_raw2=9600 Dividend=0.001825675
Dividend_2=0.0012189775 ALL=90943 ALL_rel=0.017295038 Leverage=0.9006974626 size=15.877286986
currliability=6789132 liq_currliab=0.1533151808 complete=1 NWRSSD9001=1132449 NWRSSD9999=20110630
NWassets=131799704 NWcomplete=1 NWcfvol=0.5423027284 NWcfvol_fwd=0.2181952515 NWLCR=0
NWLCR_stage2=0 NWLCR_stage3=1 NWLCR_stage2_3=1 post=0 post_stage2=0 post_stage3=0 post_1Q13=0
post_2Q13=0 post_4Q13=0 post_4Q14=0 post_15=0 post_16=0 post_17=0 in1Q11=0 in2Q11=1 in3Q11=0
in4Q11=0 in1Q12=0 in2Q12=0 in3Q12=0 in4Q12=0 in1Q13=0 in2Q13=0 in3Q13=0 in4Q13=0 in1Q14=0 in2Q14=0
in3Q14=0 in4Q14=0 in1Q15=0 in2Q15=0 in3Q15=0 in4Q15=0 in1Q16=0 in2Q16=0 in3Q16=0 in4Q16=0 in1Q17=0
in2Q17=0 in3Q17=0 in4Q17=0 in1Q18=0 in2Q18=0 in3Q18=0 in4Q18=0 in1Q19=0 in2Q19=0 in3Q19=0 in4Q19=0
weight_yq=0 weight_NWLeadArranger_yq=0 weight_size=74.787175737 totalweight_yq=0 NWLCR_weight_yq=0
NWLCR_stage2_weight_yq=0 NWLCR_stage3_weight_yq=0 _ERROR_=1 _N_=26
NOTE: Division by zero detected at line 378 column 32.
NOTE: Division by zero detected at line 379 column 46.
NOTE: Division by zero detected at line 380 column 46.
regid=1020180 NWregid=1199563 weight=12 weight_NWLeadArranger=7
LenderUltiParent=Bremer Financial Corp connection=1 connection_la=1
rssd9017=BREMER FINANCIAL CORPORATION RSSD9001=1020180 RSSD9999=20110630 RSSD9032=9
BHCB2210=437886 BHCB2389=3802634 BHCB3187=431483 BHCB6648=1118145 BHCK0081=128854 BHCK0395=496650
BHCK0397=0 BHCK1754=323846 BHCK1773=1254292 BHCK2122=5398482 BHCK2170=7859920 BHCK3123=90943
BHCK3196=903 BHCK3210=780510 BHCK3411=60786 BHCK3506=0 BHCK3507=0 BHCK3521=0 BHCK3548=0
BHCK3814=307995 BHCK3816=135041 BHCK3817=0 BHCK4073=29372 BHCK4079=41266 BHCK4093=113839
BHCK4107=167786 BHCK4230=13297 BHCK4301=53447 BHCK4340=37030 BHCK4460=19200 BHCK4605=4223
BHCK4635=11930 BHCK5525=4757 BHCK5526=66424 BHCK6550=0 BHCK8274=781394 BHCKA223=5715657
BHCKB529=5292018 BHCKB989=0 BHCKB995=484938 BHCKC026=0 BHCKC027=0 BHCKG300=0 BHCKG303=231232
BHCKG304=0 BHCKG307=650162 BHCKG308=0 BHCKG311=0 BHCKG312=0 BHCKG315=207497 BHCKG316=0 BHCKG319=0
BHCKG320=0 BHCKG323=74403 BHCKG336=0 BHCKG339=0 BHCKG340=0 BHCKG343=0 BHCKG344=0 BHCKG347=0
BHCKJ457=709497 BHCKJ458=0 BHCKJ459=335879 BHCKK142=0 BHCKK145=0 BHCKK146=0 BHCKK149=0 BHCKK150=0
BHCKK153=0 BHCKK154=0 BHCKK157=0 BHDM6631=1112953 BHDM6636=5191241 BHDMB987=529 BHDMB993=0
BHFN6631=0 BHFN6636=0 BHOD2389=0 BHOD3187=0 BHOD3189=0 BHOD6648=0 RSSD9054=1231 RSSD9200=MN
RSSD9210=27 BHCA8274=. BHCAA223=. BHCBHK29=0 BHODHK29=0 BHCK1403=. BHCK1407=. BHCKHT58=.
BHCKHT61=. m_FYE=12 y=2011 q=2 m_F=6 y_F=2011 y_F_lag1=2011 m_F_lag1=3 HBCK3521=0 i=24 cash=625504
fedfund=529 revrepo=0 htm=323846 afs=1254292 htm_mbs=0 afs_mbs=1163294 htm_abs=0 afs_abs=0
assets=7859920 liquid_assets=1040877 liquid_ratio=0.1324284471 liquid_growth=-0.016437023
illiquid_assets=6455312 illiquid_ratio=0.8212948732 loan_lease_rel=0.6732915857 htm_mbs_rel=0
afs_mbs_rel=0.1480032876 htm_abs_rel=0 afs_abs_rel=0 core_deposits=4672003 core_ratio=0.5944084673
capital=780510 capital_ratio=0.0993025374 tier1cap=781394 RWA=5715657 tier1ratio=0.1367111427
commit=1549198 loans=5398482 credit=6947680 commit_assets=9409118 commit_ratio=0.1646485887
loans_ratio=0.6868367617 credit_growth=0.0114148943 loan_growth=0.0177961826
loan_growth_2=0.0266535243 asset_growth=-0.001972331 cash_growth=-0.13133493 NPL=71181
NPL_rel=0.0135368099 LLP_raw=13297 LLP=6898 LLP_rel=0.0013118236 IntIncome_raw=167786
IntIncome=84058 IntRate=0.0159856867 IntExpense_raw=29372 IntExpense=14258 NonIntIncome_raw=42169
NonIntIncome=20316 NonIntExpense_raw=113839 NonIntExpense=57107 NonIntExpense_lending=45991.340813
NonIntExpense_rest=11115.659187 EBT_raw=53447 EBT=26111 ROA=0.0051360574 ROE=0.0334537674
ROA_IntIncome=0.0039655186 ROA_NonIntIncome=0.0011705387 ROE_IntIncome=0.021666166
ROE_NonIntIncome=0.0117876015 EBP_raw=50327 EBP=25055 EBP_rel=0.0031814043 NCO_raw=7707 NCO=6459
NCO_rel=0.001228337 Dividend_raw=19200 Dividend_raw2=9600 Dividend=0.001825675
Dividend_2=0.0012189775 ALL=90943 ALL_rel=0.017295038 Leverage=0.9006974626 size=15.877286986
currliability=6789132 liq_currliab=0.1533151808 complete=1 NWRSSD9001=1199563 NWRSSD9999=20110630
NWassets=22048475 NWcomplete=1 NWcfvol=0.4040645317 NWcfvol_fwd=0.3032998435 NWLCR=0
NWLCR_stage2=0 NWLCR_stage3=0 NWLCR_stage2_3=0 post=0 post_stage2=0 post_stage3=0 post_1Q13=0
post_2Q13=0 post_4Q13=0 post_4Q14=0 post_15=0 post_16=0 post_17=0 in1Q11=0 in2Q11=1 in3Q11=0
in4Q11=0 in1Q12=0 in2Q12=0 in3Q12=0 in4Q12=0 in1Q13=0 in2Q13=0 in3Q13=0 in4Q13=0 in1Q14=0 in2Q14=0
in3Q14=0 in4Q14=0 in1Q15=0 in2Q15=0 in3Q15=0 in4Q15=0 in1Q16=0 in2Q16=0 in3Q16=0 in4Q16=0 in1Q17=0
in2Q17=0 in3Q17=0 in4Q17=0 in1Q18=0 in2Q18=0 in3Q18=0 in4Q18=0 in1Q19=0 in2Q19=0 in3Q19=0 in4Q19=0
weight_yq=0 weight_NWLeadArranger_yq=0 weight_size=202.90504796 totalweight_yq=0 NWLCR_weight_yq=0
NWLCR_stage2_weight_yq=0 NWLCR_stage3_weight_yq=0 _ERROR_=1 _N_=27
NOTE: Division by zero detected at line 378 column 32.
NOTE: Division by zero detected at line 379 column 46.
NOTE: Division by zero detected at line 380 column 46.
regid=1020180 NWregid=1199844 weight=1 weight_NWLeadArranger=0
LenderUltiParent=Bremer Financial Corp connection=1 connection_la=0
rssd9017=BREMER FINANCIAL CORPORATION RSSD9001=1020180 RSSD9999=20110630 RSSD9032=9
BHCB2210=437886 BHCB2389=3802634 BHCB3187=431483 BHCB6648=1118145 BHCK0081=128854 BHCK0395=496650
BHCK0397=0 BHCK1754=323846 BHCK1773=1254292 BHCK2122=5398482 BHCK2170=7859920 BHCK3123=90943
BHCK3196=903 BHCK3210=780510 BHCK3411=60786 BHCK3506=0 BHCK3507=0 BHCK3521=0 BHCK3548=0
BHCK3814=307995 BHCK3816=135041 BHCK3817=0 BHCK4073=29372 BHCK4079=41266 BHCK4093=113839
BHCK4107=167786 BHCK4230=13297 BHCK4301=53447 BHCK4340=37030 BHCK4460=19200 BHCK4605=4223
BHCK4635=11930 BHCK5525=4757 BHCK5526=66424 BHCK6550=0 BHCK8274=781394 BHCKA223=5715657
BHCKB529=5292018 BHCKB989=0 BHCKB995=484938 BHCKC026=0 BHCKC027=0 BHCKG300=0 BHCKG303=231232
BHCKG304=0 BHCKG307=650162 BHCKG308=0 BHCKG311=0 BHCKG312=0 BHCKG315=207497 BHCKG316=0 BHCKG319=0
BHCKG320=0 BHCKG323=74403 BHCKG336=0 BHCKG339=0 BHCKG340=0 BHCKG343=0 BHCKG344=0 BHCKG347=0
BHCKJ457=709497 BHCKJ458=0 BHCKJ459=335879 BHCKK142=0 BHCKK145=0 BHCKK146=0 BHCKK149=0 BHCKK150=0
BHCKK153=0 BHCKK154=0 BHCKK157=0 BHDM6631=1112953 BHDM6636=5191241 BHDMB987=529 BHDMB993=0
BHFN6631=0 BHFN6636=0 BHOD2389=0 BHOD3187=0 BHOD3189=0 BHOD6648=0 RSSD9054=1231 RSSD9200=MN
RSSD9210=27 BHCA8274=. BHCAA223=. BHCBHK29=0 BHODHK29=0 BHCK1403=. BHCK1407=. BHCKHT58=.
BHCKHT61=. m_FYE=12 y=2011 q=2 m_F=6 y_F=2011 y_F_lag1=2011 m_F_lag1=3 HBCK3521=0 i=24 cash=625504
fedfund=529 revrepo=0 htm=323846 afs=1254292 htm_mbs=0 afs_mbs=1163294 htm_abs=0 afs_abs=0
assets=7859920 liquid_assets=1040877 liquid_ratio=0.1324284471 liquid_growth=-0.016437023
illiquid_assets=6455312 illiquid_ratio=0.8212948732 loan_lease_rel=0.6732915857 htm_mbs_rel=0
afs_mbs_rel=0.1480032876 htm_abs_rel=0 afs_abs_rel=0 core_deposits=4672003 core_ratio=0.5944084673
capital=780510 capital_ratio=0.0993025374 tier1cap=781394 RWA=5715657 tier1ratio=0.1367111427
commit=1549198 loans=5398482 credit=6947680 commit_assets=9409118 commit_ratio=0.1646485887
loans_ratio=0.6868367617 credit_growth=0.0114148943 loan_growth=0.0177961826
loan_growth_2=0.0266535243 asset_growth=-0.001972331 cash_growth=-0.13133493 NPL=71181
NPL_rel=0.0135368099 LLP_raw=13297 LLP=6898 LLP_rel=0.0013118236 IntIncome_raw=167786
IntIncome=84058 IntRate=0.0159856867 IntExpense_raw=29372 IntExpense=14258 NonIntIncome_raw=42169
NonIntIncome=20316 NonIntExpense_raw=113839 NonIntExpense=57107 NonIntExpense_lending=45991.340813
NonIntExpense_rest=11115.659187 EBT_raw=53447 EBT=26111 ROA=0.0051360574 ROE=0.0334537674
ROA_IntIncome=0.0039655186 ROA_NonIntIncome=0.0011705387 ROE_IntIncome=0.021666166
ROE_NonIntIncome=0.0117876015 EBP_raw=50327 EBP=25055 EBP_rel=0.0031814043 NCO_raw=7707 NCO=6459
NCO_rel=0.001228337 Dividend_raw=19200 Dividend_raw2=9600 Dividend=0.001825675
Dividend_2=0.0012189775 ALL=90943 ALL_rel=0.017295038 Leverage=0.9006974626 size=15.877286986
currliability=6789132 liq_currliab=0.1533151808 complete=1 NWRSSD9001=1199844 NWRSSD9999=20110630
NWassets=54244445 NWcomplete=1 NWcfvol=0.4189102388 NWcfvol_fwd=0.2056307191 NWLCR=0
NWLCR_stage2=0 NWLCR_stage3=0 NWLCR_stage2_3=0 post=0 post_stage2=0 post_stage3=0 post_1Q13=0
post_2Q13=0 post_4Q13=0 post_4Q14=0 post_15=0 post_16=0 post_17=0 in1Q11=0 in2Q11=1 in3Q11=0
in4Q11=0 in1Q12=0 in2Q12=0 in3Q12=0 in4Q12=0 in1Q13=0 in2Q13=0 in3Q13=0 in4Q13=0 in1Q14=0 in2Q14=0
in3Q14=0 in4Q14=0 in1Q15=0 in2Q15=0 in3Q15=0 in4Q15=0 in1Q16=0 in2Q16=0 in3Q16=0 in4Q16=0 in1Q17=0
in2Q17=0 in3Q17=0 in4Q17=0 in1Q18=0 in2Q18=0 in3Q18=0 in4Q18=0 in1Q19=0 in2Q19=0 in3Q19=0 in4Q19=0
weight_yq=0 weight_NWLeadArranger_yq=0 weight_size=17.809011149 totalweight_yq=0 NWLCR_weight_yq=0
NWLCR_stage2_weight_yq=0 NWLCR_stage3_weight_yq=0 _ERROR_=1 _N_=28
NOTE: Division by zero detected at line 378 column 32.
NOTE: Division by zero detected at line 379 column 46.
NOTE: Division by zero detected at line 380 column 46.
regid=1020180 NWregid=1204627 weight=1 weight_NWLeadArranger=0
LenderUltiParent=Bremer Financial Corp connection=1 connection_la=0
rssd9017=BREMER FINANCIAL CORPORATION RSSD9001=1020180 RSSD9999=20110630 RSSD9032=9
BHCB2210=437886 BHCB2389=3802634 BHCB3187=431483 BHCB6648=1118145 BHCK0081=128854 BHCK0395=496650
BHCK0397=0 BHCK1754=323846 BHCK1773=1254292 BHCK2122=5398482 BHCK2170=7859920 BHCK3123=90943
BHCK3196=903 BHCK3210=780510 BHCK3411=60786 BHCK3506=0 BHCK3507=0 BHCK3521=0 BHCK3548=0
BHCK3814=307995 BHCK3816=135041 BHCK3817=0 BHCK4073=29372 BHCK4079=41266 BHCK4093=113839
BHCK4107=167786 BHCK4230=13297 BHCK4301=53447 BHCK4340=37030 BHCK4460=19200 BHCK4605=4223
BHCK4635=11930 BHCK5525=4757 BHCK5526=66424 BHCK6550=0 BHCK8274=781394 BHCKA223=5715657
BHCKB529=5292018 BHCKB989=0 BHCKB995=484938 BHCKC026=0 BHCKC027=0 BHCKG300=0 BHCKG303=231232
BHCKG304=0 BHCKG307=650162 BHCKG308=0 BHCKG311=0 BHCKG312=0 BHCKG315=207497 BHCKG316=0 BHCKG319=0
BHCKG320=0 BHCKG323=74403 BHCKG336=0 BHCKG339=0 BHCKG340=0 BHCKG343=0 BHCKG344=0 BHCKG347=0
BHCKJ457=709497 BHCKJ458=0 BHCKJ459=335879 BHCKK142=0 BHCKK145=0 BHCKK146=0 BHCKK149=0 BHCKK150=0
BHCKK153=0 BHCKK154=0 BHCKK157=0 BHDM6631=1112953 BHDM6636=5191241 BHDMB987=529 BHDMB993=0
BHFN6631=0 BHFN6636=0 BHOD2389=0 BHOD3187=0 BHOD3189=0 BHOD6648=0 RSSD9054=1231 RSSD9200=MN
RSSD9210=27 BHCA8274=. BHCAA223=. BHCBHK29=0 BHODHK29=0 BHCK1403=. BHCK1407=. BHCKHT58=.
BHCKHT61=. m_FYE=12 y=2011 q=2 m_F=6 y_F=2011 y_F_lag1=2011 m_F_lag1=3 HBCK3521=0 i=24 cash=625504
fedfund=529 revrepo=0 htm=323846 afs=1254292 htm_mbs=0 afs_mbs=1163294 htm_abs=0 afs_abs=0
assets=7859920 liquid_assets=1040877 liquid_ratio=0.1324284471 liquid_growth=-0.016437023
illiquid_assets=6455312 illiquid_ratio=0.8212948732 loan_lease_rel=0.6732915857 htm_mbs_rel=0
afs_mbs_rel=0.1480032876 htm_abs_rel=0 afs_abs_rel=0 core_deposits=4672003 core_ratio=0.5944084673
capital=780510 capital_ratio=0.0993025374 tier1cap=781394 RWA=5715657 tier1ratio=0.1367111427
commit=1549198 loans=5398482 credit=6947680 commit_assets=9409118 commit_ratio=0.1646485887
loans_ratio=0.6868367617 credit_growth=0.0114148943 loan_growth=0.0177961826
loan_growth_2=0.0266535243 asset_growth=-0.001972331 cash_growth=-0.13133493 NPL=71181
NPL_rel=0.0135368099 LLP_raw=13297 LLP=6898 LLP_rel=0.0013118236 IntIncome_raw=167786
IntIncome=84058 IntRate=0.0159856867 IntExpense_raw=29372 IntExpense=14258 NonIntIncome_raw=42169
NonIntIncome=20316 NonIntExpense_raw=113839 NonIntExpense=57107 NonIntExpense_lending=45991.340813
NonIntExpense_rest=11115.659187 EBT_raw=53447 EBT=26111 ROA=0.0051360574 ROE=0.0334537674
ROA_IntIncome=0.0039655186 ROA_NonIntIncome=0.0011705387 ROE_IntIncome=0.021666166
ROE_NonIntIncome=0.0117876015 EBP_raw=50327 EBP=25055 EBP_rel=0.0031814043 NCO_raw=7707 NCO=6459
NCO_rel=0.001228337 Dividend_raw=19200 Dividend_raw2=9600 Dividend=0.001825675
Dividend_2=0.0012189775 ALL=90943 ALL_rel=0.017295038 Leverage=0.9006974626 size=15.877286986
currliability=6789132 liq_currliab=0.1533151808 complete=1 NWRSSD9001=1204627 NWRSSD9999=20110630
NWassets=2847621 NWcomplete=1 NWcfvol=0.3401155581 NWcfvol_fwd=0.4537904032 NWLCR=0 NWLCR_stage2=0
NWLCR_stage3=0 NWLCR_stage2_3=0 post=0 post_stage2=0 post_stage3=0 post_1Q13=0 post_2Q13=0
post_4Q13=0 post_4Q14=0 post_15=0 post_16=0 post_17=0 in1Q11=0 in2Q11=1 in3Q11=0 in4Q11=0 in1Q12=0
in2Q12=0 in3Q12=0 in4Q12=0 in1Q13=0 in2Q13=0 in3Q13=0 in4Q13=0 in1Q14=0 in2Q14=0 in3Q14=0 in4Q14=0
in1Q15=0 in2Q15=0 in3Q15=0 in4Q15=0 in1Q16=0 in2Q16=0 in3Q16=0 in4Q16=0 in1Q17=0 in2Q17=0 in3Q17=0
in4Q17=0 in1Q18=0 in2Q18=0 in3Q18=0 in4Q18=0 in1Q19=0 in2Q19=0 in3Q19=0 in4Q19=0 weight_yq=0
weight_NWLeadArranger_yq=0 weight_size=14.861994467 totalweight_yq=0 NWLCR_weight_yq=0
NWLCR_stage2_weight_yq=0 NWLCR_stage3_weight_yq=0 _ERROR_=1 _N_=29
NOTE: Division by zero detected at line 378 column 32.
NOTE: Division by zero detected at line 379 column 46.
NOTE: Division by zero detected at line 380 column 46.
regid=1020180 NWregid=1205398 weight=2 weight_NWLeadArranger=0
LenderUltiParent=Bremer Financial Corp connection=1 connection_la=0
rssd9017=BREMER FINANCIAL CORPORATION RSSD9001=1020180 RSSD9999=20110630 RSSD9032=9
BHCB2210=437886 BHCB2389=3802634 BHCB3187=431483 BHCB6648=1118145 BHCK0081=128854 BHCK0395=496650
BHCK0397=0 BHCK1754=323846 BHCK1773=1254292 BHCK2122=5398482 BHCK2170=7859920 BHCK3123=90943
BHCK3196=903 BHCK3210=780510 BHCK3411=60786 BHCK3506=0 BHCK3507=0 BHCK3521=0 BHCK3548=0
BHCK3814=307995 BHCK3816=135041 BHCK3817=0 BHCK4073=29372 BHCK4079=41266 BHCK4093=113839
BHCK4107=167786 BHCK4230=13297 BHCK4301=53447 BHCK4340=37030 BHCK4460=19200 BHCK4605=4223
BHCK4635=11930 BHCK5525=4757 BHCK5526=66424 BHCK6550=0 BHCK8274=781394 BHCKA223=5715657
BHCKB529=5292018 BHCKB989=0 BHCKB995=484938 BHCKC026=0 BHCKC027=0 BHCKG300=0 BHCKG303=231232
BHCKG304=0 BHCKG307=650162 BHCKG308=0 BHCKG311=0 BHCKG312=0 BHCKG315=207497 BHCKG316=0 BHCKG319=0
BHCKG320=0 BHCKG323=74403 BHCKG336=0 BHCKG339=0 BHCKG340=0 BHCKG343=0 BHCKG344=0 BHCKG347=0
BHCKJ457=709497 BHCKJ458=0 BHCKJ459=335879 BHCKK142=0 BHCKK145=0 BHCKK146=0 BHCKK149=0 BHCKK150=0
BHCKK153=0 BHCKK154=0 BHCKK157=0 BHDM6631=1112953 BHDM6636=5191241 BHDMB987=529 BHDMB993=0
BHFN6631=0 BHFN6636=0 BHOD2389=0 BHOD3187=0 BHOD3189=0 BHOD6648=0 RSSD9054=1231 RSSD9200=MN
RSSD9210=27 BHCA8274=. BHCAA223=. BHCBHK29=0 BHODHK29=0 BHCK1403=. BHCK1407=. BHCKHT58=.
BHCKHT61=. m_FYE=12 y=2011 q=2 m_F=6 y_F=2011 y_F_lag1=2011 m_F_lag1=3 HBCK3521=0 i=24 cash=625504
fedfund=529 revrepo=0 htm=323846 afs=1254292 htm_mbs=0 afs_mbs=1163294 htm_abs=0 afs_abs=0
assets=7859920 liquid_assets=1040877 liquid_ratio=0.1324284471 liquid_growth=-0.016437023
illiquid_assets=6455312 illiquid_ratio=0.8212948732 loan_lease_rel=0.6732915857 htm_mbs_rel=0
afs_mbs_rel=0.1480032876 htm_abs_rel=0 afs_abs_rel=0 core_deposits=4672003 core_ratio=0.5944084673
capital=780510 capital_ratio=0.0993025374 tier1cap=781394 RWA=5715657 tier1ratio=0.1367111427
commit=1549198 loans=5398482 credit=6947680 commit_assets=9409118 commit_ratio=0.1646485887
loans_ratio=0.6868367617 credit_growth=0.0114148943 loan_growth=0.0177961826
loan_growth_2=0.0266535243 asset_growth=-0.001972331 cash_growth=-0.13133493 NPL=71181
NPL_rel=0.0135368099 LLP_raw=13297 LLP=6898 LLP_rel=0.0013118236 IntIncome_raw=167786
IntIncome=84058 IntRate=0.0159856867 IntExpense_raw=29372 IntExpense=14258 NonIntIncome_raw=42169
NonIntIncome=20316 NonIntExpense_raw=113839 NonIntExpense=57107 NonIntExpense_lending=45991.340813
NonIntExpense_rest=11115.659187 EBT_raw=53447 EBT=26111 ROA=0.0051360574 ROE=0.0334537674
ROA_IntIncome=0.0039655186 ROA_NonIntIncome=0.0011705387 ROE_IntIncome=0.021666166
ROE_NonIntIncome=0.0117876015 EBP_raw=50327 EBP=25055 EBP_rel=0.0031814043 NCO_raw=7707 NCO=6459
NCO_rel=0.001228337 Dividend_raw=19200 Dividend_raw2=9600 Dividend=0.001825675
Dividend_2=0.0012189775 ALL=90943 ALL_rel=0.017295038 Leverage=0.9006974626 size=15.877286986
currliability=6789132 liq_currliab=0.1533151808 complete=1 NWRSSD9001=1205398 NWRSSD9999=20110630
NWassets=1085785 NWcomplete=1 NWcfvol=0.3664553969 NWcfvol_fwd=0.1123388565 NWLCR=0 NWLCR_stage2=0
NWLCR_stage3=0 NWLCR_stage2_3=0 post=0 post_stage2=0 post_stage3=0 post_1Q13=0 post_2Q13=0
post_4Q13=0 post_4Q14=0 post_15=0 post_16=0 post_17=0 in1Q11=0 in2Q11=1 in3Q11=0 in4Q11=0 in1Q12=0
in2Q12=0 in3Q12=0 in4Q12=0 in1Q13=0 in2Q13=0 in3Q13=0 in4Q13=0 in1Q14=0 in2Q14=0 in3Q14=0 in4Q14=0
in1Q15=0 in2Q15=0 in3Q15=0 in4Q15=0 in1Q16=0 in2Q16=0 in3Q16=0 in4Q16=0 in1Q17=0 in2Q17=0 in3Q17=0
in4Q17=0 in1Q18=0 in2Q18=0 in3Q18=0 in4Q18=0 in1Q19=0 in2Q19=0 in3Q19=0 in4Q19=0 weight_yq=0
weight_NWLeadArranger_yq=0 weight_size=27.795627571 totalweight_yq=0 NWLCR_weight_yq=0
NWLCR_stage2_weight_yq=0 NWLCR_stage3_weight_yq=0 _ERROR_=1 _N_=30
NOTE: Division by zero detected at line 378 column 32.
NOTE: Division by zero detected at line 379 column 46.
NOTE: Division by zero detected at line 380 column 46.
regid=1020180 NWregid=1208184 weight=2 weight_NWLeadArranger=0
LenderUltiParent=Bremer Financial Corp connection=1 connection_la=0
rssd9017=BREMER FINANCIAL CORPORATION RSSD9001=1020180 RSSD9999=20110630 RSSD9032=9
BHCB2210=437886 BHCB2389=3802634 BHCB3187=431483 BHCB6648=1118145 BHCK0081=128854 BHCK0395=496650
BHCK0397=0 BHCK1754=323846 BHCK1773=1254292 BHCK2122=5398482 BHCK2170=7859920 BHCK3123=90943
BHCK3196=903 BHCK3210=780510 BHCK3411=60786 BHCK3506=0 BHCK3507=0 BHCK3521=0 BHCK3548=0
BHCK3814=307995 BHCK3816=135041 BHCK3817=0 BHCK4073=29372 BHCK4079=41266 BHCK4093=113839
BHCK4107=167786 BHCK4230=13297 BHCK4301=53447 BHCK4340=37030 BHCK4460=19200 BHCK4605=4223
BHCK4635=11930 BHCK5525=4757 BHCK5526=66424 BHCK6550=0 BHCK8274=781394 BHCKA223=5715657
BHCKB529=5292018 BHCKB989=0 BHCKB995=484938 BHCKC026=0 BHCKC027=0 BHCKG300=0 BHCKG303=231232
BHCKG304=0 BHCKG307=650162 BHCKG308=0 BHCKG311=0 BHCKG312=0 BHCKG315=207497 BHCKG316=0 BHCKG319=0
BHCKG320=0 BHCKG323=74403 BHCKG336=0 BHCKG339=0 BHCKG340=0 BHCKG343=0 BHCKG344=0 BHCKG347=0
BHCKJ457=709497 BHCKJ458=0 BHCKJ459=335879 BHCKK142=0 BHCKK145=0 BHCKK146=0 BHCKK149=0 BHCKK150=0
BHCKK153=0 BHCKK154=0 BHCKK157=0 BHDM6631=1112953 BHDM6636=5191241 BHDMB987=529 BHDMB993=0
BHFN6631=0 BHFN6636=0 BHOD2389=0 BHOD3187=0 BHOD3189=0 BHOD6648=0 RSSD9054=1231 RSSD9200=MN
RSSD9210=27 BHCA8274=. BHCAA223=. BHCBHK29=0 BHODHK29=0 BHCK1403=. BHCK1407=. BHCKHT58=.
BHCKHT61=. m_FYE=12 y=2011 q=2 m_F=6 y_F=2011 y_F_lag1=2011 m_F_lag1=3 HBCK3521=0 i=24 cash=625504
fedfund=529 revrepo=0 htm=323846 afs=1254292 htm_mbs=0 afs_mbs=1163294 htm_abs=0 afs_abs=0
assets=7859920 liquid_assets=1040877 liquid_ratio=0.1324284471 liquid_growth=-0.016437023
illiquid_assets=6455312 illiquid_ratio=0.8212948732 loan_lease_rel=0.6732915857 htm_mbs_rel=0
afs_mbs_rel=0.1480032876 htm_abs_rel=0 afs_abs_rel=0 core_deposits=4672003 core_ratio=0.5944084673
capital=780510 capital_ratio=0.0993025374 tier1cap=781394 RWA=5715657 tier1ratio=0.1367111427
commit=1549198 loans=5398482 credit=6947680 commit_assets=9409118 commit_ratio=0.1646485887
loans_ratio=0.6868367617 credit_growth=0.0114148943 loan_growth=0.0177961826
loan_growth_2=0.0266535243 asset_growth=-0.001972331 cash_growth=-0.13133493 NPL=71181
NPL_rel=0.0135368099 LLP_raw=13297 LLP=6898 LLP_rel=0.0013118236 IntIncome_raw=167786
IntIncome=84058 IntRate=0.0159856867 IntExpense_raw=29372 IntExpense=14258 NonIntIncome_raw=42169
NonIntIncome=20316 NonIntExpense_raw=113839 NonIntExpense=57107 NonIntExpense_lending=45991.340813
NonIntExpense_rest=11115.659187 EBT_raw=53447 EBT=26111 ROA=0.0051360574 ROE=0.0334537674
ROA_IntIncome=0.0039655186 ROA_NonIntIncome=0.0011705387 ROE_IntIncome=0.021666166
ROE_NonIntIncome=0.0117876015 EBP_raw=50327 EBP=25055 EBP_rel=0.0031814043 NCO_raw=7707 NCO=6459
NCO_rel=0.001228337 Dividend_raw=19200 Dividend_raw2=9600 Dividend=0.001825675
Dividend_2=0.0012189775 ALL=90943 ALL_rel=0.017295038 Leverage=0.9006974626 size=15.877286986
currliability=6789132 liq_currliab=0.1533151808 complete=1 NWRSSD9001=1208184 NWRSSD9999=20110630
NWassets=8129450 NWcomplete=1 NWcfvol=0.3697610971 NWcfvol_fwd=0.3438684894 NWLCR=0 NWLCR_stage2=0
NWLCR_stage3=0 NWLCR_stage2_3=0 post=0 post_stage2=0 post_stage3=0 post_1Q13=0 post_2Q13=0
post_4Q13=0 post_4Q14=0 post_15=0 post_16=0 post_17=0 in1Q11=0 in2Q11=1 in3Q11=0 in4Q11=0 in1Q12=0
in2Q12=0 in3Q12=0 in4Q12=0 in1Q13=0 in2Q13=0 in3Q13=0 in4Q13=0 in1Q14=0 in2Q14=0 in3Q14=0 in4Q14=0
in1Q15=0 in2Q15=0 in3Q15=0 in4Q15=0 in1Q16=0 in2Q16=0 in3Q16=0 in4Q16=0 in1Q17=0 in2Q17=0 in3Q17=0
in4Q17=0 in1Q18=0 in2Q18=0 in3Q18=0 in4Q18=0 in1Q19=0 in2Q19=0 in3Q19=0 in4Q19=0 weight_yq=0
weight_NWLeadArranger_yq=0 weight_size=31.822007657 totalweight_yq=0 NWLCR_weight_yq=0
NWLCR_stage2_weight_yq=0 NWLCR_stage3_weight_yq=0 _ERROR_=1 _N_=31
NOTE: Division by zero detected at line 378 column 32.
NOTE: Division by zero detected at line 379 column 46.
NOTE: Division by zero detected at line 380 column 46.
regid=1020180 NWregid=1208559 weight=2 weight_NWLeadArranger=0
LenderUltiParent=Bremer Financial Corp connection=1 connection_la=0
rssd9017=BREMER FINANCIAL CORPORATION RSSD9001=1020180 RSSD9999=20110630 RSSD9032=9
BHCB2210=437886 BHCB2389=3802634 BHCB3187=431483 BHCB6648=1118145 BHCK0081=128854 BHCK0395=496650
BHCK0397=0 BHCK1754=323846 BHCK1773=1254292 BHCK2122=5398482 BHCK2170=7859920 BHCK3123=90943
BHCK3196=903 BHCK3210=780510 BHCK3411=60786 BHCK3506=0 BHCK3507=0 BHCK3521=0 BHCK3548=0
BHCK3814=307995 BHCK3816=135041 BHCK3817=0 BHCK4073=29372 BHCK4079=41266 BHCK4093=113839
BHCK4107=167786 BHCK4230=13297 BHCK4301=53447 BHCK4340=37030 BHCK4460=19200 BHCK4605=4223
BHCK4635=11930 BHCK5525=4757 BHCK5526=66424 BHCK6550=0 BHCK8274=781394 BHCKA223=5715657
BHCKB529=5292018 BHCKB989=0 BHCKB995=484938 BHCKC026=0 BHCKC027=0 BHCKG300=0 BHCKG303=231232
BHCKG304=0 BHCKG307=650162 BHCKG308=0 BHCKG311=0 BHCKG312=0 BHCKG315=207497 BHCKG316=0 BHCKG319=0
BHCKG320=0 BHCKG323=74403 BHCKG336=0 BHCKG339=0 BHCKG340=0 BHCKG343=0 BHCKG344=0 BHCKG347=0
BHCKJ457=709497 BHCKJ458=0 BHCKJ459=335879 BHCKK142=0 BHCKK145=0 BHCKK146=0 BHCKK149=0 BHCKK150=0
BHCKK153=0 BHCKK154=0 BHCKK157=0 BHDM6631=1112953 BHDM6636=5191241 BHDMB987=529 BHDMB993=0
BHFN6631=0 BHFN6636=0 BHOD2389=0 BHOD3187=0 BHOD3189=0 BHOD6648=0 RSSD9054=1231 RSSD9200=MN
RSSD9210=27 BHCA8274=. BHCAA223=. BHCBHK29=0 BHODHK29=0 BHCK1403=. BHCK1407=. BHCKHT58=.
BHCKHT61=. m_FYE=12 y=2011 q=2 m_F=6 y_F=2011 y_F_lag1=2011 m_F_lag1=3 HBCK3521=0 i=24 cash=625504
fedfund=529 revrepo=0 htm=323846 afs=1254292 htm_mbs=0 afs_mbs=1163294 htm_abs=0 afs_abs=0
assets=7859920 liquid_assets=1040877 liquid_ratio=0.1324284471 liquid_growth=-0.016437023
illiquid_assets=6455312 illiquid_ratio=0.8212948732 loan_lease_rel=0.6732915857 htm_mbs_rel=0
afs_mbs_rel=0.1480032876 htm_abs_rel=0 afs_abs_rel=0 core_deposits=4672003 core_ratio=0.5944084673
capital=780510 capital_ratio=0.0993025374 tier1cap=781394 RWA=5715657 tier1ratio=0.1367111427
commit=1549198 loans=5398482 credit=6947680 commit_assets=9409118 commit_ratio=0.1646485887
loans_ratio=0.6868367617 credit_growth=0.0114148943 loan_growth=0.0177961826
loan_growth_2=0.0266535243 asset_growth=-0.001972331 cash_growth=-0.13133493 NPL=71181
NPL_rel=0.0135368099 LLP_raw=13297 LLP=6898 LLP_rel=0.0013118236 IntIncome_raw=167786
IntIncome=84058 IntRate=0.0159856867 IntExpense_raw=29372 IntExpense=14258 NonIntIncome_raw=42169
NonIntIncome=20316 NonIntExpense_raw=113839 NonIntExpense=57107 NonIntExpense_lending=45991.340813
NonIntExpense_rest=11115.659187 EBT_raw=53447 EBT=26111 ROA=0.0051360574 ROE=0.0334537674
ROA_IntIncome=0.0039655186 ROA_NonIntIncome=0.0011705387 ROE_IntIncome=0.021666166
ROE_NonIntIncome=0.0117876015 EBP_raw=50327 EBP=25055 EBP_rel=0.0031814043 NCO_raw=7707 NCO=6459
NCO_rel=0.001228337 Dividend_raw=19200 Dividend_raw2=9600 Dividend=0.001825675
Dividend_2=0.0012189775 ALL=90943 ALL_rel=0.017295038 Leverage=0.9006974626 size=15.877286986
currliability=6789132 liq_currliab=0.1533151808 complete=1 NWRSSD9001=1208559 NWRSSD9999=20110630
NWassets=4094222 NWcomplete=1 NWcfvol=0.2985294602 NWcfvol_fwd=0.2888467732 NWLCR=0 NWLCR_stage2=0
NWLCR_stage3=0 NWLCR_stage2_3=0 post=0 post_stage2=0 post_stage3=0 post_1Q13=0 post_2Q13=0
post_4Q13=0 post_4Q14=0 post_15=0 post_16=0 post_17=0 in1Q11=0 in2Q11=1 in3Q11=0 in4Q11=0 in1Q12=0
in2Q12=0 in3Q12=0 in4Q12=0 in1Q13=0 in2Q13=0 in3Q13=0 in4Q13=0 in1Q14=0 in2Q14=0 in3Q14=0 in4Q14=0
in1Q15=0 in2Q15=0 in3Q15=0 in4Q15=0 in1Q16=0 in2Q16=0 in3Q16=0 in4Q16=0 in1Q17=0 in2Q17=0 in3Q17=0
in4Q17=0 in1Q18=0 in2Q18=0 in3Q18=0 in4Q18=0 in1Q19=0 in2Q19=0 in3Q19=0 in4Q19=0 weight_yq=0
weight_NWLeadArranger_yq=0 weight_size=30.450174539 totalweight_yq=0 NWLCR_weight_yq=0
NWLCR_stage2_weight_yq=0 NWLCR_stage3_weight_yq=0 _ERROR_=1 _N_=32
NOTE: Division by zero detected at line 378 column 32.
NOTE: Division by zero detected at line 379 column 46.
NOTE: Division by zero detected at line 380 column 46.
regid=1020180 NWregid=1245705 weight=1 weight_NWLeadArranger=0
LenderUltiParent=Bremer Financial Corp connection=1 connection_la=0
rssd9017=BREMER FINANCIAL CORPORATION RSSD9001=1020180 RSSD9999=20110630 RSSD9032=9
BHCB2210=437886 BHCB2389=3802634 BHCB3187=431483 BHCB6648=1118145 BHCK0081=128854 BHCK0395=496650
BHCK0397=0 BHCK1754=323846 BHCK1773=1254292 BHCK2122=5398482 BHCK2170=7859920 BHCK3123=90943
BHCK3196=903 BHCK3210=780510 BHCK3411=60786 BHCK3506=0 BHCK3507=0 BHCK3521=0 BHCK3548=0
BHCK3814=307995 BHCK3816=135041 BHCK3817=0 BHCK4073=29372 BHCK4079=41266 BHCK4093=113839
BHCK4107=167786 BHCK4230=13297 BHCK4301=53447 BHCK4340=37030 BHCK4460=19200 BHCK4605=4223
BHCK4635=11930 BHCK5525=4757 BHCK5526=66424 BHCK6550=0 BHCK8274=781394 BHCKA223=5715657
BHCKB529=5292018 BHCKB989=0 BHCKB995=484938 BHCKC026=0 BHCKC027=0 BHCKG300=0 BHCKG303=231232
BHCKG304=0 BHCKG307=650162 BHCKG308=0 BHCKG311=0 BHCKG312=0 BHCKG315=207497 BHCKG316=0 BHCKG319=0
BHCKG320=0 BHCKG323=74403 BHCKG336=0 BHCKG339=0 BHCKG340=0 BHCKG343=0 BHCKG344=0 BHCKG347=0
BHCKJ457=709497 BHCKJ458=0 BHCKJ459=335879 BHCKK142=0 BHCKK145=0 BHCKK146=0 BHCKK149=0 BHCKK150=0
BHCKK153=0 BHCKK154=0 BHCKK157=0 BHDM6631=1112953 BHDM6636=5191241 BHDMB987=529 BHDMB993=0
BHFN6631=0 BHFN6636=0 BHOD2389=0 BHOD3187=0 BHOD3189=0 BHOD6648=0 RSSD9054=1231 RSSD9200=MN
RSSD9210=27 BHCA8274=. BHCAA223=. BHCBHK29=0 BHODHK29=0 BHCK1403=. BHCK1407=. BHCKHT58=.
BHCKHT61=. m_FYE=12 y=2011 q=2 m_F=6 y_F=2011 y_F_lag1=2011 m_F_lag1=3 HBCK3521=0 i=24 cash=625504
fedfund=529 revrepo=0 htm=323846 afs=1254292 htm_mbs=0 afs_mbs=1163294 htm_abs=0 afs_abs=0
assets=7859920 liquid_assets=1040877 liquid_ratio=0.1324284471 liquid_growth=-0.016437023
illiquid_assets=6455312 illiquid_ratio=0.8212948732 loan_lease_rel=0.6732915857 htm_mbs_rel=0
afs_mbs_rel=0.1480032876 htm_abs_rel=0 afs_abs_rel=0 core_deposits=4672003 core_ratio=0.5944084673
capital=780510 capital_ratio=0.0993025374 tier1cap=781394 RWA=5715657 tier1ratio=0.1367111427
commit=1549198 loans=5398482 credit=6947680 commit_assets=9409118 commit_ratio=0.1646485887
loans_ratio=0.6868367617 credit_growth=0.0114148943 loan_growth=0.0177961826
loan_growth_2=0.0266535243 asset_growth=-0.001972331 cash_growth=-0.13133493 NPL=71181
NPL_rel=0.0135368099 LLP_raw=13297 LLP=6898 LLP_rel=0.0013118236 IntIncome_raw=167786
IntIncome=84058 IntRate=0.0159856867 IntExpense_raw=29372 IntExpense=14258 NonIntIncome_raw=42169
NonIntIncome=20316 NonIntExpense_raw=113839 NonIntExpense=57107 NonIntExpense_lending=45991.340813
NonIntExpense_rest=11115.659187 EBT_raw=53447 EBT=26111 ROA=0.0051360574 ROE=0.0334537674
ROA_IntIncome=0.0039655186 ROA_NonIntIncome=0.0011705387 ROE_IntIncome=0.021666166
ROE_NonIntIncome=0.0117876015 EBP_raw=50327 EBP=25055 EBP_rel=0.0031814043 NCO_raw=7707 NCO=6459
NCO_rel=0.001228337 Dividend_raw=19200 Dividend_raw2=9600 Dividend=0.001825675
Dividend_2=0.0012189775 ALL=90943 ALL_rel=0.017295038 Leverage=0.9006974626 size=15.877286986
currliability=6789132 liq_currliab=0.1533151808 complete=1 NWRSSD9001=1245705 NWRSSD9999=20110630
NWassets=1933113 NWcomplete=1 NWcfvol=0.5257842016 NWcfvol_fwd=0.7641814026 NWLCR=0 NWLCR_stage2=0
NWLCR_stage3=0 NWLCR_stage2_3=0 post=0 post_stage2=0 post_stage3=0 post_1Q13=0 post_2Q13=0
post_4Q13=0 post_4Q14=0 post_15=0 post_16=0 post_17=0 in1Q11=0 in2Q11=1 in3Q11=0 in4Q11=0 in1Q12=0
in2Q12=0 in3Q12=0 in4Q12=0 in1Q13=0 in2Q13=0 in3Q13=0 in4Q13=0 in1Q14=0 in2Q14=0 in3Q14=0 in4Q14=0
in1Q15=0 in2Q15=0 in3Q15=0 in4Q15=0 in1Q16=0 in2Q16=0 in3Q16=0 in4Q16=0 in1Q17=0 in2Q17=0 in3Q17=0
in4Q17=0 in1Q18=0 in2Q18=0 in3Q18=0 in4Q18=0 in1Q19=0 in2Q19=0 in3Q19=0 in4Q19=0 weight_yq=0
weight_NWLeadArranger_yq=0 weight_size=14.474642215 totalweight_yq=0 NWLCR_weight_yq=0
NWLCR_stage2_weight_yq=0 NWLCR_stage3_weight_yq=0 _ERROR_=1 _N_=33
NOTE: Division by zero detected at line 378 column 32.
NOTE: Division by zero detected at line 379 column 46.
NOTE: Division by zero detected at line 380 column 46.
regid=1020180 NWregid=2260406 weight=4 weight_NWLeadArranger=0
LenderUltiParent=Bremer Financial Corp connection=1 connection_la=0
rssd9017=BREMER FINANCIAL CORPORATION RSSD9001=1020180 RSSD9999=20110630 RSSD9032=9
BHCB2210=437886 BHCB2389=3802634 BHCB3187=431483 BHCB6648=1118145 BHCK0081=128854 BHCK0395=496650
BHCK0397=0 BHCK1754=323846 BHCK1773=1254292 BHCK2122=5398482 BHCK2170=7859920 BHCK3123=90943
BHCK3196=903 BHCK3210=780510 BHCK3411=60786 BHCK3506=0 BHCK3507=0 BHCK3521=0 BHCK3548=0
BHCK3814=307995 BHCK3816=135041 BHCK3817=0 BHCK4073=29372 BHCK4079=41266 BHCK4093=113839
BHCK4107=167786 BHCK4230=13297 BHCK4301=53447 BHCK4340=37030 BHCK4460=19200 BHCK4605=4223
BHCK4635=11930 BHCK5525=4757 BHCK5526=66424 BHCK6550=0 BHCK8274=781394 BHCKA223=5715657
BHCKB529=5292018 BHCKB989=0 BHCKB995=484938 BHCKC026=0 BHCKC027=0 BHCKG300=0 BHCKG303=231232
BHCKG304=0 BHCKG307=650162 BHCKG308=0 BHCKG311=0 BHCKG312=0 BHCKG315=207497 BHCKG316=0 BHCKG319=0
BHCKG320=0 BHCKG323=74403 BHCKG336=0 BHCKG339=0 BHCKG340=0 BHCKG343=0 BHCKG344=0 BHCKG347=0
BHCKJ457=709497 BHCKJ458=0 BHCKJ459=335879 BHCKK142=0 BHCKK145=0 BHCKK146=0 BHCKK149=0 BHCKK150=0
BHCKK153=0 BHCKK154=0 BHCKK157=0 BHDM6631=1112953 BHDM6636=5191241 BHDMB987=529 BHDMB993=0
BHFN6631=0 BHFN6636=0 BHOD2389=0 BHOD3187=0 BHOD3189=0 BHOD6648=0 RSSD9054=1231 RSSD9200=MN
RSSD9210=27 BHCA8274=. BHCAA223=. BHCBHK29=0 BHODHK29=0 BHCK1403=. BHCK1407=. BHCKHT58=.
BHCKHT61=. m_FYE=12 y=2011 q=2 m_F=6 y_F=2011 y_F_lag1=2011 m_F_lag1=3 HBCK3521=0 i=24 cash=625504
fedfund=529 revrepo=0 htm=323846 afs=1254292 htm_mbs=0 afs_mbs=1163294 htm_abs=0 afs_abs=0
assets=7859920 liquid_assets=1040877 liquid_ratio=0.1324284471 liquid_growth=-0.016437023
illiquid_assets=6455312 illiquid_ratio=0.8212948732 loan_lease_rel=0.6732915857 htm_mbs_rel=0
afs_mbs_rel=0.1480032876 htm_abs_rel=0 afs_abs_rel=0 core_deposits=4672003 core_ratio=0.5944084673
capital=780510 capital_ratio=0.0993025374 tier1cap=781394 RWA=5715657 tier1ratio=0.1367111427
commit=1549198 loans=5398482 credit=6947680 commit_assets=9409118 commit_ratio=0.1646485887
loans_ratio=0.6868367617 credit_growth=0.0114148943 loan_growth=0.0177961826
loan_growth_2=0.0266535243 asset_growth=-0.001972331 cash_growth=-0.13133493 NPL=71181
NPL_rel=0.0135368099 LLP_raw=13297 LLP=6898 LLP_rel=0.0013118236 IntIncome_raw=167786
IntIncome=84058 IntRate=0.0159856867 IntExpense_raw=29372 IntExpense=14258 NonIntIncome_raw=42169
NonIntIncome=20316 NonIntExpense_raw=113839 NonIntExpense=57107 NonIntExpense_lending=45991.340813
NonIntExpense_rest=11115.659187 EBT_raw=53447 EBT=26111 ROA=0.0051360574 ROE=0.0334537674
ROA_IntIncome=0.0039655186 ROA_NonIntIncome=0.0011705387 ROE_IntIncome=0.021666166
ROE_NonIntIncome=0.0117876015 EBP_raw=50327 EBP=25055 EBP_rel=0.0031814043 NCO_raw=7707 NCO=6459
NCO_rel=0.001228337 Dividend_raw=19200 Dividend_raw2=9600 Dividend=0.001825675
Dividend_2=0.0012189775 ALL=90943 ALL_rel=0.017295038 Leverage=0.9006974626 size=15.877286986
currliability=6789132 liq_currliab=0.1533151808 complete=1 NWRSSD9001=2260406 NWRSSD9999=20110630
NWassets=14615897 NWcomplete=1 NWcfvol=0.2147956685 NWcfvol_fwd=0.2324641742 NWLCR=0
NWLCR_stage2=0 NWLCR_stage3=0 NWLCR_stage2_3=0 post=0 post_stage2=0 post_stage3=0 post_1Q13=0
post_2Q13=0 post_4Q13=0 post_4Q14=0 post_15=0 post_16=0 post_17=0 in1Q11=0 in2Q11=1 in3Q11=0
in4Q11=0 in1Q12=0 in2Q12=0 in3Q12=0 in4Q12=0 in1Q13=0 in2Q13=0 in3Q13=0 in4Q13=0 in1Q14=0 in2Q14=0
in3Q14=0 in4Q14=0 in1Q15=0 in2Q15=0 in3Q15=0 in4Q15=0 in1Q16=0 in2Q16=0 in3Q16=0 in4Q16=0 in1Q17=0
in2Q17=0 in3Q17=0 in4Q17=0 in1Q18=0 in2Q18=0 in3Q18=0 in4Q18=0 in1Q19=0 in2Q19=0 in3Q19=0 in4Q19=0
weight_yq=0 weight_NWLeadArranger_yq=0 weight_size=65.99048132 totalweight_yq=0 NWLCR_weight_yq=0
NWLCR_stage2_weight_yq=0 NWLCR_stage3_weight_yq=0 _ERROR_=1 _N_=34
NOTE: Division by zero detected at line 378 column 32.
NOTE: Division by zero detected at line 379 column 46.
NOTE: Division by zero detected at line 380 column 46.
regid=1020180 NWregid=1039502 weight=1 weight_NWLeadArranger=1
LenderUltiParent=Bremer Financial Corp connection=1 connection_la=1
rssd9017=BREMER FINANCIAL CORPORATION RSSD9001=1020180 RSSD9999=20110930 RSSD9032=9
BHCB2210=501709 BHCB2389=3821056 BHCB3187=453713 BHCB6648=1103404 BHCK0081=141341 BHCK0395=535684
BHCK0397=0 BHCK1754=336857 BHCK1773=1190014 BHCK2122=5535162 BHCK2170=8000824 BHCK3123=89964
BHCK3196=903 BHCK3210=795029 BHCK3411=60684 BHCK3506=0 BHCK3507=0 BHCK3521=0 BHCK3548=0
BHCK3814=305397 BHCK3816=143947 BHCK3817=0 BHCK4073=43320 BHCK4079=61111 BHCK4093=170958
BHCK4107=252866 BHCK4230=18422 BHCK4301=82180 BHCK4340=56985 BHCK4460=28800 BHCK4605=5234
BHCK4635=19045 BHCK5525=8510 BHCK5526=68080 BHCK6550=0 BHCK8274=792054 BHCKA223=5825495
BHCKB529=5412947 BHCKB989=0 BHCKB995=539191 BHCKC026=0 BHCKC027=0 BHCKG300=0 BHCKG303=224128
BHCKG304=0 BHCKG307=627707 BHCKG308=0 BHCKG311=0 BHCKG312=0 BHCKG315=202017 BHCKG316=0 BHCKG319=0
BHCKG320=0 BHCKG323=67636 BHCKG336=0 BHCKG339=0 BHCKG340=0 BHCKG343=0 BHCKG344=0 BHCKG347=0
BHCKJ457=738779 BHCKJ458=0 BHCKJ459=345406 BHCKK142=0 BHCKK145=0 BHCKK146=0 BHCKK149=0 BHCKK150=0
BHCKK153=0 BHCKK154=0 BHCKK157=0 BHDM6631=1268796 BHDM6636=5115246 BHDMB987=947 BHDMB993=0
BHFN6631=0 BHFN6636=0 BHOD2389=0 BHOD3187=0 BHOD3189=0 BHOD6648=0 RSSD9054=1231 RSSD9200=MN
RSSD9210=27 BHCA8274=. BHCAA223=. BHCBHK29=0 BHODHK29=0 BHCK1403=. BHCK1407=. BHCKHT58=.
BHCKHT61=. m_FYE=12 y=2011 q=3 m_F=9 y_F=2011 y_F_lag1=2011 m_F_lag1=6 HBCK3521=0 i=24 cash=677025
fedfund=947 revrepo=0 htm=336857 afs=1190014 htm_mbs=0 afs_mbs=1121488 htm_abs=0 afs_abs=0
assets=8000824 liquid_assets=1083355 liquid_ratio=0.1354054282 liquid_growth=0.0054043807
illiquid_assets=6534435 illiquid_ratio=0.8167202528 loan_lease_rel=0.6765486905 htm_mbs_rel=0
afs_mbs_rel=0.1401715623 htm_abs_rel=0 afs_abs_rel=0 core_deposits=4776478 core_ratio=0.5969982592
capital=795029 capital_ratio=0.0993683901 tier1cap=792054 RWA=5825495 tier1ratio=0.1359633817
commit=1594213 loans=5535162 credit=7129375 commit_assets=9595037 commit_ratio=0.1661497501
loans_ratio=0.6918239921 credit_growth=0.0193105241 loan_growth=0.01738949
loan_growth_2=0.0253182283 asset_growth=0.0179269 cash_growth=0.0823671791 NPL=76590
NPL_rel=0.0141873215 LLP_raw=18422 LLP=5125 LLP_rel=0.0009493409 IntIncome_raw=252866
IntIncome=85080 IntRate=0.0157599859 IntExpense_raw=43320 IntExpense=13948 NonIntIncome_raw=62014
NonIntIncome=19845 NonIntExpense_raw=170958 NonIntExpense=57119 NonIntExpense_lending=46315.792423
NonIntExpense_rest=10803.207577 EBT_raw=82180 EBT=28733 ROA=0.0053345755 ROE=0.03614082
ROA_IntIncome=0.0042044679 ROA_NonIntIncome=0.0011301077 ROE_IntIncome=0.0247679111
ROE_NonIntIncome=0.0113729089 EBP_raw=75407 EBP=25080 EBP_rel=0.0031908722 NCO_raw=13811 NCO=6104
NCO_rel=0.0011306882 Dividend_raw=28800 Dividend_raw2=9600 Dividend=0.0017782777
Dividend_2=0.0012213865 ALL=89964 ALL_rel=0.0166646846 Leverage=0.9006316099 size=15.895055094
currliability=6923233 liq_currliab=0.1564810833 complete=1 NWRSSD9001=1039502 NWRSSD9999=20110930
NWassets=2289240000 NWcomplete=1 NWcfvol=0.1864523334 NWcfvol_fwd=0.1191787169 NWLCR=1
NWLCR_stage2=0 NWLCR_stage3=0 NWLCR_stage2_3=0 post=0 post_stage2=0 post_stage3=0 post_1Q13=0
post_2Q13=0 post_4Q13=0 post_4Q14=0 post_15=0 post_16=0 post_17=0 in1Q11=0 in2Q11=0 in3Q11=1
in4Q11=0 in1Q12=0 in2Q12=0 in3Q12=0 in4Q12=0 in1Q13=0 in2Q13=0 in3Q13=0 in4Q13=0 in1Q14=0 in2Q14=0
in3Q14=0 in4Q14=0 in1Q15=0 in2Q15=0 in3Q15=0 in4Q15=0 in1Q16=0 in2Q16=0 in3Q16=0 in4Q16=0 in1Q17=0
in2Q17=0 in3Q17=0 in4Q17=0 in1Q18=0 in2Q18=0 in3Q18=0 in4Q18=0 in1Q19=0 in2Q19=0 in3Q19=0 in4Q19=0
weight_yq=0 weight_NWLeadArranger_yq=0 weight_size=21.551485722 totalweight_yq=0 NWLCR_weight_yq=0
NWLCR_stage2_weight_yq=0 NWLCR_stage3_weight_yq=0 _ERROR_=1 _N_=35
NOTE: Division by zero detected at line 378 column 32.
NOTE: Division by zero detected at line 379 column 46.
NOTE: Division by zero detected at line 380 column 46.
regid=1020180 NWregid=1068025 weight=1 weight_NWLeadArranger=0
LenderUltiParent=Bremer Financial Corp connection=1 connection_la=0
rssd9017=BREMER FINANCIAL CORPORATION RSSD9001=1020180 RSSD9999=20110930 RSSD9032=9
BHCB2210=501709 BHCB2389=3821056 BHCB3187=453713 BHCB6648=1103404 BHCK0081=141341 BHCK0395=535684
BHCK0397=0 BHCK1754=336857 BHCK1773=1190014 BHCK2122=5535162 BHCK2170=8000824 BHCK3123=89964
BHCK3196=903 BHCK3210=795029 BHCK3411=60684 BHCK3506=0 BHCK3507=0 BHCK3521=0 BHCK3548=0
BHCK3814=305397 BHCK3816=143947 BHCK3817=0 BHCK4073=43320 BHCK4079=61111 BHCK4093=170958
BHCK4107=252866 BHCK4230=18422 BHCK4301=82180 BHCK4340=56985 BHCK4460=28800 BHCK4605=5234
BHCK4635=19045 BHCK5525=8510 BHCK5526=68080 BHCK6550=0 BHCK8274=792054 BHCKA223=5825495
BHCKB529=5412947 BHCKB989=0 BHCKB995=539191 BHCKC026=0 BHCKC027=0 BHCKG300=0 BHCKG303=224128
BHCKG304=0 BHCKG307=627707 BHCKG308=0 BHCKG311=0 BHCKG312=0 BHCKG315=202017 BHCKG316=0 BHCKG319=0
BHCKG320=0 BHCKG323=67636 BHCKG336=0 BHCKG339=0 BHCKG340=0 BHCKG343=0 BHCKG344=0 BHCKG347=0
BHCKJ457=738779 BHCKJ458=0 BHCKJ459=345406 BHCKK142=0 BHCKK145=0 BHCKK146=0 BHCKK149=0 BHCKK150=0
BHCKK153=0 BHCKK154=0 BHCKK157=0 BHDM6631=1268796 BHDM6636=5115246 BHDMB987=947 BHDMB993=0
BHFN6631=0 BHFN6636=0 BHOD2389=0 BHOD3187=0 BHOD3189=0 BHOD6648=0 RSSD9054=1231 RSSD9200=MN
RSSD9210=27 BHCA8274=. BHCAA223=. BHCBHK29=0 BHODHK29=0 BHCK1403=. BHCK1407=. BHCKHT58=.
BHCKHT61=. m_FYE=12 y=2011 q=3 m_F=9 y_F=2011 y_F_lag1=2011 m_F_lag1=6 HBCK3521=0 i=24 cash=677025
fedfund=947 revrepo=0 htm=336857 afs=1190014 htm_mbs=0 afs_mbs=1121488 htm_abs=0 afs_abs=0
assets=8000824 liquid_assets=1083355 liquid_ratio=0.1354054282 liquid_growth=0.0054043807
illiquid_assets=6534435 illiquid_ratio=0.8167202528 loan_lease_rel=0.6765486905 htm_mbs_rel=0
afs_mbs_rel=0.1401715623 htm_abs_rel=0 afs_abs_rel=0 core_deposits=4776478 core_ratio=0.5969982592
capital=795029 capital_ratio=0.0993683901 tier1cap=792054 RWA=5825495 tier1ratio=0.1359633817
commit=1594213 loans=5535162 credit=7129375 commit_assets=9595037 commit_ratio=0.1661497501
loans_ratio=0.6918239921 credit_growth=0.0193105241 loan_growth=0.01738949
loan_growth_2=0.0253182283 asset_growth=0.0179269 cash_growth=0.0823671791 NPL=76590
NPL_rel=0.0141873215 LLP_raw=18422 LLP=5125 LLP_rel=0.0009493409 IntIncome_raw=252866
IntIncome=85080 IntRate=0.0157599859 IntExpense_raw=43320 IntExpense=13948 NonIntIncome_raw=62014
NonIntIncome=19845 NonIntExpense_raw=170958 NonIntExpense=57119 NonIntExpense_lending=46315.792423
NonIntExpense_rest=10803.207577 EBT_raw=82180 EBT=28733 ROA=0.0053345755 ROE=0.03614082
ROA_IntIncome=0.0042044679 ROA_NonIntIncome=0.0011301077 ROE_IntIncome=0.0247679111
ROE_NonIntIncome=0.0113729089 EBP_raw=75407 EBP=25080 EBP_rel=0.0031908722 NCO_raw=13811 NCO=6104
NCO_rel=0.0011306882 Dividend_raw=28800 Dividend_raw2=9600 Dividend=0.0017782777
Dividend_2=0.0012213865 ALL=89964 ALL_rel=0.0166646846 Leverage=0.9006316099 size=15.895055094
currliability=6923233 liq_currliab=0.1564810833 complete=1 NWRSSD9001=1068025 NWRSSD9999=20110930
NWassets=89405605 NWcomplete=1 NWcfvol=0.3508251075 NWcfvol_fwd=0.3471153284 NWLCR=0
NWLCR_stage2=0 NWLCR_stage3=1 NWLCR_stage2_3=1 post=0 post_stage2=0 post_stage3=0 post_1Q13=0
post_2Q13=0 post_4Q13=0 post_4Q14=0 post_15=0 post_16=0 post_17=0 in1Q11=0 in2Q11=0 in3Q11=1
in4Q11=0 in1Q12=0 in2Q12=0 in3Q12=0 in4Q12=0 in1Q13=0 in2Q13=0 in3Q13=0 in4Q13=0 in1Q14=0 in2Q14=0
in3Q14=0 in4Q14=0 in1Q15=0 in2Q15=0 in3Q15=0 in4Q15=0 in1Q16=0 in2Q16=0 in3Q16=0 in4Q16=0 in1Q17=0
in2Q17=0 in3Q17=0 in4Q17=0 in1Q18=0 in2Q18=0 in3Q18=0 in4Q18=0 in1Q19=0 in2Q19=0 in3Q19=0 in4Q19=0
weight_yq=0 weight_NWLeadArranger_yq=0 weight_size=18.308693934 totalweight_yq=0 NWLCR_weight_yq=0
NWLCR_stage2_weight_yq=0 NWLCR_stage3_weight_yq=0 _ERROR_=1 _N_=36
NOTE: Division by zero detected at line 378 column 32.
NOTE: Division by zero detected at line 379 column 46.
NOTE: Division by zero detected at line 380 column 46.
WARNING: Limit set by ERRORS= option reached.  Further errors of this type will not be printed.
regid=1020180 NWregid=1068191 weight=3 weight_NWLeadArranger=2
LenderUltiParent=Bremer Financial Corp connection=1 connection_la=1
rssd9017=BREMER FINANCIAL CORPORATION RSSD9001=1020180 RSSD9999=20110930 RSSD9032=9
BHCB2210=501709 BHCB2389=3821056 BHCB3187=453713 BHCB6648=1103404 BHCK0081=141341 BHCK0395=535684
BHCK0397=0 BHCK1754=336857 BHCK1773=1190014 BHCK2122=5535162 BHCK2170=8000824 BHCK3123=89964
BHCK3196=903 BHCK3210=795029 BHCK3411=60684 BHCK3506=0 BHCK3507=0 BHCK3521=0 BHCK3548=0
BHCK3814=305397 BHCK3816=143947 BHCK3817=0 BHCK4073=43320 BHCK4079=61111 BHCK4093=170958
BHCK4107=252866 BHCK4230=18422 BHCK4301=82180 BHCK4340=56985 BHCK4460=28800 BHCK4605=5234
BHCK4635=19045 BHCK5525=8510 BHCK5526=68080 BHCK6550=0 BHCK8274=792054 BHCKA223=5825495
BHCKB529=5412947 BHCKB989=0 BHCKB995=539191 BHCKC026=0 BHCKC027=0 BHCKG300=0 BHCKG303=224128
BHCKG304=0 BHCKG307=627707 BHCKG308=0 BHCKG311=0 BHCKG312=0 BHCKG315=202017 BHCKG316=0 BHCKG319=0
BHCKG320=0 BHCKG323=67636 BHCKG336=0 BHCKG339=0 BHCKG340=0 BHCKG343=0 BHCKG344=0 BHCKG347=0
BHCKJ457=738779 BHCKJ458=0 BHCKJ459=345406 BHCKK142=0 BHCKK145=0 BHCKK146=0 BHCKK149=0 BHCKK150=0
BHCKK153=0 BHCKK154=0 BHCKK157=0 BHDM6631=1268796 BHDM6636=5115246 BHDMB987=947 BHDMB993=0
BHFN6631=0 BHFN6636=0 BHOD2389=0 BHOD3187=0 BHOD3189=0 BHOD6648=0 RSSD9054=1231 RSSD9200=MN
RSSD9210=27 BHCA8274=. BHCAA223=. BHCBHK29=0 BHODHK29=0 BHCK1403=. BHCK1407=. BHCKHT58=.
BHCKHT61=. m_FYE=12 y=2011 q=3 m_F=9 y_F=2011 y_F_lag1=2011 m_F_lag1=6 HBCK3521=0 i=24 cash=677025
fedfund=947 revrepo=0 htm=336857 afs=1190014 htm_mbs=0 afs_mbs=1121488 htm_abs=0 afs_abs=0
assets=8000824 liquid_assets=1083355 liquid_ratio=0.1354054282 liquid_growth=0.0054043807
illiquid_assets=6534435 illiquid_ratio=0.8167202528 loan_lease_rel=0.6765486905 htm_mbs_rel=0
afs_mbs_rel=0.1401715623 htm_abs_rel=0 afs_abs_rel=0 core_deposits=4776478 core_ratio=0.5969982592
capital=795029 capital_ratio=0.0993683901 tier1cap=792054 RWA=5825495 tier1ratio=0.1359633817
commit=1594213 loans=5535162 credit=7129375 commit_assets=9595037 commit_ratio=0.1661497501
loans_ratio=0.6918239921 credit_growth=0.0193105241 loan_growth=0.01738949
loan_growth_2=0.0253182283 asset_growth=0.0179269 cash_growth=0.0823671791 NPL=76590
NPL_rel=0.0141873215 LLP_raw=18422 LLP=5125 LLP_rel=0.0009493409 IntIncome_raw=252866
IntIncome=85080 IntRate=0.0157599859 IntExpense_raw=43320 IntExpense=13948 NonIntIncome_raw=62014
NonIntIncome=19845 NonIntExpense_raw=170958 NonIntExpense=57119 NonIntExpense_lending=46315.792423
NonIntExpense_rest=10803.207577 EBT_raw=82180 EBT=28733 ROA=0.0053345755 ROE=0.03614082
ROA_IntIncome=0.0042044679 ROA_NonIntIncome=0.0011301077 ROE_IntIncome=0.0247679111
ROE_NonIntIncome=0.0113729089 EBP_raw=75407 EBP=25080 EBP_rel=0.0031908722 NCO_raw=13811 NCO=6104
NCO_rel=0.0011306882 Dividend_raw=28800 Dividend_raw2=9600 Dividend=0.0017782777
Dividend_2=0.0012213865 ALL=89964 ALL_rel=0.0166646846 Leverage=0.9006316099 size=15.895055094
currliability=6923233 liq_currliab=0.1564810833 complete=1 NWRSSD9001=1068191 NWRSSD9999=20110930
NWassets=54978707 NWcomplete=1 NWcfvol=0.2982314552 NWcfvol_fwd=0.4549932195 NWLCR=0
NWLCR_stage2=0 NWLCR_stage3=1 NWLCR_stage2_3=1 post=0 post_stage2=0 post_stage3=0 post_1Q13=0
post_2Q13=0 post_4Q13=0 post_4Q14=0 post_15=0 post_16=0 post_17=0 in1Q11=0 in2Q11=0 in3Q11=1
in4Q11=0 in1Q12=0 in2Q12=0 in3Q12=0 in4Q12=0 in1Q13=0 in2Q13=0 in3Q13=0 in4Q13=0 in1Q14=0 in2Q14=0
in3Q14=0 in4Q14=0 in1Q15=0 in2Q15=0 in3Q15=0 in4Q15=0 in1Q16=0 in2Q16=0 in3Q16=0 in4Q16=0 in1Q17=0
in2Q17=0 in3Q17=0 in4Q17=0 in1Q18=0 in2Q18=0 in3Q18=0 in4Q18=0 in1Q19=0 in2Q19=0 in3Q19=0 in4Q19=0
weight_yq=0 weight_NWLeadArranger_yq=0 weight_size=53.467369568 totalweight_yq=0 NWLCR_weight_yq=0
NWLCR_stage2_weight_yq=0 NWLCR_stage3_weight_yq=0 _ERROR_=1 _N_=37
NOTE: Mathematical operations could not be performed at the following places. The results of the 
      operations have been set to missing values.
      Each place is given by: (Number of times) at (Line):(Column).
      63884 at 378:32   63884 at 379:46   63884 at 380:46   
NOTE: There were 161752 observations read from the data set WORK.NWDETAILS.
NOTE: The data set WORK.NWDETAILS has 161752 observations and 254 variables.
NOTE: DATA statement used (Total process time):
      real time           0.76 seconds
      cpu time            0.01 seconds
      

386  
387  proc means data=nwdetails noprint;
388  by RSSD9001 RSSD9999;
389  var NWLCR_weight_yq NWLCR_stage2_weight_yq NWLCR_stage3_weight_yq;
390  output out=nwdetails_sum2 sum=NWLCR_weight_yq NWLCR_stage2_weight_yq NWLCR_stage3_weight_yq;
391  run;

NOTE: There were 161752 observations read from the data set WORK.NWDETAILS.
NOTE: The data set WORK.NWDETAILS_SUM2 has 7745 observations and 7 variables.
NOTE: PROCEDURE MEANS used (Total process time):
      real time           0.13 seconds
      cpu time            0.00 seconds
      

392  
393  data nwregvar;
394  merge nwregvar nwdetails_sum2;
395  by RSSD9001 RSSD9999;
396  run;

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

397  
398  proc sort data=calnw;by rssd9001;run;

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

399  proc sort data=nwregvar;by rssd9001;run;

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

400  data nwregvar;
401  merge nwregvar(in=a) calnw;
402  by rssd9001;
403  if a;
404  run;

NOTE: There were 7745 observations read from the data set WORK.NWREGVAR.
NOTE: There were 247 observations read from the data set WORK.CALNW.
NOTE: The data set WORK.NWREGVAR has 7745 observations and 104 variables.
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      cpu time            0.00 seconds
      

405  proc sort data=nwregvar;by rssd9001 rssd9999;run;

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

406  
407  
408  data nwregvar;
409  set nwregvar;
410  improve_potential=1-NWLCR_weight;
411  improve_potential_stage2=1-NWLCR_stage2_weight;
412  improve_potential_stage3=1-NWLCR_stage3_weight;
413  improve_potential_la_stage2=1-NWLCR_stage2_weight_la;
414  improve_potential_la_stage3=1-NWLCR_stage3_weight_la;
415  
416  trans_improve=post*(1-NWLCR_weight);
417  trans_improve_stage2=post_stage2*(1-NWLCR_stage2_weight);
418  trans_improve_stage3=post_stage3*(1-NWLCR_stage3_weight);
419  trans_improve_stage2_3=post_stage3*(1-NWLCR_stage2_3_weight);
420  
421  trans_improve_1Q13=post_1Q13*(1-NWLCR_weight);
422  trans_improve_2Q13=post_2Q13*(1-NWLCR_weight);
423  trans_improve_4Q13=post_4Q13 *(1-NWLCR_weight);
424  trans_improve_4Q14=post_4Q14*(1-NWLCR_weight);
425  trans_improve_15=post_15*(1-NWLCR_weight);
426  trans_improve_16=post_16*(1-NWLCR_weight);
427  trans_improve_17=post_17*(1-NWLCR_weight);
428  
429  
430  trans_improve_1Q2011=in1Q11*(1-NWLCR_weight);
431  trans_improve_2Q2011=in2Q11*(1-NWLCR_weight);
432  trans_improve_3Q2011=in3Q11*(1-NWLCR_weight);
433  trans_improve_4Q2011=in4Q11*(1-NWLCR_weight);
434  
435  trans_improve_1Q2012=in1Q12*(1-NWLCR_weight);
436  trans_improve_2Q2012=in2Q12*(1-NWLCR_weight);
437  trans_improve_3Q2012=in3Q12*(1-NWLCR_weight);
438  trans_improve_4Q2012=in4Q12*(1-NWLCR_weight);
439  
440  trans_improve_1Q2013=in1Q13*(1-NWLCR_weight);
441  trans_improve_2Q2013=in2Q13*(1-NWLCR_weight);
442  trans_improve_3Q2013=in3Q13*(1-NWLCR_weight);
443  trans_improve_4Q2013=in4Q13*(1-NWLCR_weight);
444  
445  trans_improve_1Q14=in1Q14*(1-NWLCR_weight);
446  trans_improve_2Q14=in2Q14*(1-NWLCR_weight);
447  trans_improve_3Q14=in3Q14*(1-NWLCR_weight);
448  trans_improve_4Q14=in4Q14*(1-NWLCR_weight);
449  
450  trans_improve_1Q15=in1Q15*(1-NWLCR_weight);
451  trans_improve_2Q15=in2Q15*(1-NWLCR_weight);
452  trans_improve_3Q15=in3Q15*(1-NWLCR_weight);
453  trans_improve_4Q15=in4Q15*(1-NWLCR_weight);
454  
455  trans_improve_1Q16=in1Q16*(1-NWLCR_weight);
456  trans_improve_2Q16=in2Q16*(1-NWLCR_weight);
457  trans_improve_3Q16=in3Q16*(1-NWLCR_weight);
458  trans_improve_4Q16=in4Q16*(1-NWLCR_weight);
459  trans_improve_1Q17=in1Q17*(1-NWLCR_weight);
460  trans_improve_2Q17=in2Q17*(1-NWLCR_weight);
461  trans_improve_3Q17=in3Q17*(1-NWLCR_weight);
462  trans_improve_4Q17=in4Q17*(1-NWLCR_weight);
463  trans_improve_1Q18=in1Q18*(1-NWLCR_weight);
464  trans_improve_2Q18=in2Q18*(1-NWLCR_weight);
465  trans_improve_3Q18=in3Q18*(1-NWLCR_weight);
466  trans_improve_4Q18=in4Q18*(1-NWLCR_weight);
467  trans_improve_1Q19=in1Q19*(1-NWLCR_weight);
468  trans_improve_2Q19=in2Q19*(1-NWLCR_weight);
469  trans_improve_3Q19=in3Q19*(1-NWLCR_weight);
470  trans_improve_4Q19=in4Q19*(1-NWLCR_weight);
471  
472  
473  trans_improve_sizeweighted=post*(1-NWLCR_weight_size);
474  trans_improve_size_stage2=post_stage2*(1-NWLCR_stage2_weight_size);
475  trans_improve_size_stage3=post_stage3*(1-NWLCR_stage3_weight_size);
476  
477  trans_improve_15_sizeweighted=post_15*(1-NWLCR_weight_size);
478  trans_improve_16_sizeweighted=post_16*(1-NWLCR_weight_size);
479  trans_improve_17_sizeweighted=post_17*(1-NWLCR_weight_size);
480  trans_improve_1Q16_sizeweighted=in1Q16*(1-NWLCR_weight_size);
481  trans_improve_2Q16_sizeweighted=in2Q16*(1-NWLCR_weight_size);
482  trans_improve_3Q16_sizeweighted=in3Q16*(1-NWLCR_weight_size);
483  trans_improve_4Q16_sizeweighted=in4Q16*(1-NWLCR_weight_size);
484  trans_improve_1Q17_sizeweighted=in1Q17*(1-NWLCR_weight_size);
485  trans_improve_2Q17_sizeweighted=in2Q17*(1-NWLCR_weight_size);
486  trans_improve_3Q17_sizeweighted=in3Q17*(1-NWLCR_weight_size);
487  trans_improve_4Q17_sizeweighted=in4Q17*(1-NWLCR_weight_size);
488  trans_improve_1Q18_sizeweighted=in1Q18*(1-NWLCR_weight_size);
489  trans_improve_2Q18_sizeweighted=in2Q18*(1-NWLCR_weight_size);
490  
491  improve_potential_la=1-NWLCR_weight_LA;
492  trans_improve_LA=post*(1-NWLCR_weight_LA);
493  trans_improve_LA_stage2=post_stage2*(1-NWLCR_stage2_weight_LA);
494  trans_improve_LA_stage3=post_stage3*(1-NWLCR_stage3_weight_LA);
495  
496  trans_improve_15_LA=post_15*(1-NWLCR_weight_LA);
497  trans_improve_16_LA=post_16*(1-NWLCR_weight_LA);
498  trans_improve_17_LA=post_17*(1-NWLCR_weight_LA);
499  trans_improve_1Q13_LA=in1Q13*(1-NWLCR_weight_LA);
500  trans_improve_1Q16_LA=in1Q16*(1-NWLCR_weight_LA);
501  trans_improve_2Q16_LA=in2Q16*(1-NWLCR_weight_LA);
502  trans_improve_3Q16_LA=in3Q16*(1-NWLCR_weight_LA);
503  trans_improve_4Q16_LA=in4Q16*(1-NWLCR_weight_LA);
504  trans_improve_1Q17_LA=in1Q17*(1-NWLCR_weight_LA);
505  trans_improve_2Q17_LA=in2Q17*(1-NWLCR_weight_LA);
506  trans_improve_3Q17_LA=in3Q17*(1-NWLCR_weight_LA);
507  trans_improve_4Q17_LA=in4Q17*(1-NWLCR_weight_LA);
508  trans_improve_1Q18_LA=in1Q18*(1-NWLCR_weight_LA);
509  trans_improve_2Q18_LA=in2Q18*(1-NWLCR_weight_LA);
510  
511  trans_improve_lag1=ifn(rssd9001=lag(rssd9001) & ((y=lag(y) & q=lag(q)+1) | (y=lag(y)+1 & q=1
511! & lag(q)=4)), lag(trans_improve),.);
512  trans_improve_stage2_lag1=ifn(rssd9001=lag(rssd9001) & ((y=lag(y) & q=lag(q)+1) | (y=lag(y)+1
512!  & q=1 & lag(q)=4)), lag(trans_improve_stage2),.);
513  trans_improve_stage3_lag1=ifn(rssd9001=lag(rssd9001) & ((y=lag(y) & q=lag(q)+1) | (y=lag(y)+1
513!  & q=1 & lag(q)=4)), lag(trans_improve_stage3),.);
514  trans_improve_stage2_3_lag1=ifn(rssd9001=lag(rssd9001) & ((y=lag(y) & q=lag(q)+1) |
514! (y=lag(y)+1 & q=1 & lag(q)=4)), lag(trans_improve_stage2_3),.);
515  
516  trans_improve_lag2=ifn(rssd9001=lag(rssd9001) & ((y=lag(y) & q=lag(q)+1) | (y=lag(y)+1 & q=1
516! & lag(q)=4)), lag(trans_improve_lag1),.);
517  trans_improve_stage2_lag2=ifn(rssd9001=lag(rssd9001) & ((y=lag(y) & q=lag(q)+1) | (y=lag(y)+1
517!  & q=1 & lag(q)=4)), lag(trans_improve_stage2_lag1),.);
518  trans_improve_stage3_lag2=ifn(rssd9001=lag(rssd9001) & ((y=lag(y) & q=lag(q)+1) | (y=lag(y)+1
518!  & q=1 & lag(q)=4)), lag(trans_improve_stage3_lag1),.);
519  trans_improve_stage2_3_lag2=ifn(rssd9001=lag(rssd9001) & ((y=lag(y) & q=lag(q)+1) |
519! (y=lag(y)+1 & q=1 & lag(q)=4)), lag(trans_improve_stage2_3_lag1),.);
520  
521  improve_potential_lag1=ifn(rssd9001=lag(rssd9001) & ((y=lag(y) & q=lag(q)+1) | (y=lag(y)+1 &
521! q=1 & lag(q)=4)), lag(improve_potential),.);
522  improve_potential_stage2_lag1=ifn(rssd9001=lag(rssd9001) & ((y=lag(y) & q=lag(q)+1) |
522! (y=lag(y)+1 & q=1 & lag(q)=4)), lag(improve_potential_stage2),.);
523  improve_potential_stage3_lag1=ifn(rssd9001=lag(rssd9001) & ((y=lag(y) & q=lag(q)+1) |
523! (y=lag(y)+1 & q=1 & lag(q)=4)), lag(improve_potential_stage3),.);
524  
525  improve_potential_la_lag1=ifn(rssd9001=lag(rssd9001) & ((y=lag(y) & q=lag(q)+1) | (y=lag(y)+1
525!  & q=1 & lag(q)=4)), lag(improve_potential_la),.);
526  
527  
528  trans_improve_2Q13_lag1=ifn(rssd9001=lag(rssd9001) & ((y=lag(y) & q=lag(q)+1) | (y=lag(y)+1 &
528!  q=1 & lag(q)=4)), lag(trans_improve_2Q13),.);
529  trans_improve_2Q13_lag2=ifn(rssd9001=lag(rssd9001) & ((y=lag(y) & q=lag(q)+1) | (y=lag(y)+1 &
529!  q=1 & lag(q)=4)), lag(trans_improve_2Q13_lag1),.);
530  
531  trans_improve_4Q13_lag1=ifn(rssd9001=lag(rssd9001) & ((y=lag(y) & q=lag(q)+1) | (y=lag(y)+1 &
531!  q=1 & lag(q)=4)), lag(trans_improve_4Q13),.);
532  trans_improve_4Q13_lag2=ifn(rssd9001=lag(rssd9001) & ((y=lag(y) & q=lag(q)+1) | (y=lag(y)+1 &
532!  q=1 & lag(q)=4)), lag(trans_improve_4Q13_lag1),.);
533  
534  trans_improve_4Q14_lag1=ifn(rssd9001=lag(rssd9001) & ((y=lag(y) & q=lag(q)+1) | (y=lag(y)+1 &
534!  q=1 & lag(q)=4)), lag(trans_improve_4Q14),.);
535  trans_improve_4Q14_lag2=ifn(rssd9001=lag(rssd9001) & ((y=lag(y) & q=lag(q)+1) | (y=lag(y)+1 &
535!  q=1 & lag(q)=4)), lag(trans_improve_4Q14_lag1),.);
536  
537  
538  trans_improve_15_lag1=ifn(rssd9001=lag(rssd9001) & ((y=lag(y) & q=lag(q)+1) | (y=lag(y)+1 &
538! q=1 & lag(q)=4)), lag(trans_improve_15),.);
539  trans_improve_15_lag2=ifn(rssd9001=lag(rssd9001) & ((y=lag(y) & q=lag(q)+1) | (y=lag(y)+1 &
539! q=1 & lag(q)=4)), lag(trans_improve_15_lag1),.);
540  
541  trans_improve_16_lag1=ifn(rssd9001=lag(rssd9001) & ((y=lag(y) & q=lag(q)+1) | (y=lag(y)+1 &
541! q=1 & lag(q)=4)), lag(trans_improve_16),.);
542  trans_improve_16_lag2=ifn(rssd9001=lag(rssd9001) & ((y=lag(y) & q=lag(q)+1) | (y=lag(y)+1 &
542! q=1 & lag(q)=4)), lag(trans_improve_16_lag1),.);
543  
544  trans_improve_17_lag1=ifn(rssd9001=lag(rssd9001) & ((y=lag(y) & q=lag(q)+1) | (y=lag(y)+1 &
544! q=1 & lag(q)=4)), lag(trans_improve_17),.);
545  trans_improve_17_lag2=ifn(rssd9001=lag(rssd9001) & ((y=lag(y) & q=lag(q)+1) | (y=lag(y)+1 &
545! q=1 & lag(q)=4)), lag(trans_improve_17_lag1),.);
546  
547  trans_improve_sizeweighted_lag1=ifn(rssd9001=lag(rssd9001) & ((y=lag(y) & q=lag(q)+1) |
547! (y=lag(y)+1 & q=1 & lag(q)=4)), lag(trans_improve_sizeweighted),.);
548  trans_improve_size_stage2_lag1=ifn(rssd9001=lag(rssd9001) & ((y=lag(y) & q=lag(q)+1) |
548! (y=lag(y)+1 & q=1 & lag(q)=4)), lag(trans_improve_size_stage2),.);
549  trans_improve_size_stage3_lag1=ifn(rssd9001=lag(rssd9001) & ((y=lag(y) & q=lag(q)+1) |
549! (y=lag(y)+1 & q=1 & lag(q)=4)), lag(trans_improve_size_stage3),.);
550  
551  trans_improve_sizeweighted_lag2=ifn(rssd9001=lag(rssd9001) & ((y=lag(y) & q=lag(q)+1) |
551! (y=lag(y)+1 & q=1 & lag(q)=4)), lag(trans_improve_sizeweighted_lag1),.);
552  trans_improve_size_stage2_lag2=ifn(rssd9001=lag(rssd9001) & ((y=lag(y) & q=lag(q)+1) |
552! (y=lag(y)+1 & q=1 & lag(q)=4)), lag(trans_improve_size_stage2_lag1),.);
553  trans_improve_size_stage3_lag2=ifn(rssd9001=lag(rssd9001) & ((y=lag(y) & q=lag(q)+1) |
553! (y=lag(y)+1 & q=1 & lag(q)=4)), lag(trans_improve_size_stage3_lag1),.);
554  
555  trans_improve_LA_lag1=ifn(rssd9001=lag(rssd9001) & ((y=lag(y) & q=lag(q)+1) | (y=lag(y)+1 &
555! q=1 & lag(q)=4)), lag(trans_improve_LA),.);
556  trans_improve_LA_stage2_lag1=ifn(rssd9001=lag(rssd9001) & ((y=lag(y) & q=lag(q)+1) |
556! (y=lag(y)+1 & q=1 & lag(q)=4)), lag(trans_improve_LA_stage2),.);
557  trans_improve_LA_stage3_lag1=ifn(rssd9001=lag(rssd9001) & ((y=lag(y) & q=lag(q)+1) |
557! (y=lag(y)+1 & q=1 & lag(q)=4)), lag(trans_improve_LA_stage3),.);
558  
559  trans_improve_LA_lag2=ifn(rssd9001=lag(rssd9001) & ((y=lag(y) & q=lag(q)+1) | (y=lag(y)+1 &
559! q=1 & lag(q)=4)), lag(trans_improve_LA_lag1),.);
560  trans_improve_LA_stage2_lag2=ifn(rssd9001=lag(rssd9001) & ((y=lag(y) & q=lag(q)+1) |
560! (y=lag(y)+1 & q=1 & lag(q)=4)), lag(trans_improve_LA_stage2_lag1),.);
561  trans_improve_LA_stage3_lag2=ifn(rssd9001=lag(rssd9001) & ((y=lag(y) & q=lag(q)+1) |
561! (y=lag(y)+1 & q=1 & lag(q)=4)), lag(trans_improve_LA_stage3_lag1),.);
562  
563  post_lag1=ifn(rssd9001=lag(rssd9001) & ((y=lag(y) & q=lag(q)+1) | (y=lag(y)+1 & q=1 &
563! lag(q)=4)), lag(post),.);
564  post_stage2_lag1=ifn(rssd9001=lag(rssd9001) & ((y=lag(y) & q=lag(q)+1) | (y=lag(y)+1 & q=1 &
564! lag(q)=4)), lag(post_stage2),.);
565  post_stage3_lag1=ifn(rssd9001=lag(rssd9001) & ((y=lag(y) & q=lag(q)+1) | (y=lag(y)+1 & q=1 &
565! lag(q)=4)), lag(post_stage3),.);
566  
567  LCRBanks=ifn(RSSD9001=1039502 | RSSD9001=1073757 | RSSD9001=1111435 | RSSD9001=1120754 |
567! RSSD9001=1951350 | RSSD9001=2380443 | RSSD9001=3587146 | RSSD9001=2162966,1,0);
568  LCRBanks_stage2=ifn(RSSD9001=1069778 | RSSD9001=1119794 | RSSD9001=1199611,1,0);
569  LCRBanks_stage3=ifn(RSSD9001=1037003 | RSSD9001=1068025 | RSSD9001=1068191 | RSSD9001=1070345
569!  | RSSD9001=1074156 | RSSD9001=1131787 | RSSD9001=1132449 | RSSD9001=1562859 |
569! RSSD9001=3242838,1,0);
570  Other_50bn_or_larger_Banks=ifn(RSSD9001=1027004 | RSSD9001=1031449 | RSSD9001=1129382 |
570! RSSD9001=1199844 | RSSD9001=3650152,1,0);
571  
572  run;

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).
      81 at 473:35   81 at 474:41   81 at 475:41   81 at 477:41   81 at 478:41   81 at 479:41
      81 at 480:42   81 at 481:42   81 at 482:42   81 at 483:42   81 at 484:42   81 at 485:42
      81 at 486:42   81 at 487:42   81 at 488:42   81 at 489:42   1 at 511:70    1 at 511:85
      1 at 512:77    1 at 512:92    1 at 513:77    1 at 513:92    1 at 514:79    1 at 514:94
      1 at 516:70    1 at 516:85    1 at 517:77    1 at 517:92    1 at 518:77    1 at 518:92
      1 at 519:79    1 at 519:94    1 at 521:74    1 at 521:89    1 at 522:81    1 at 522:96
      1 at 523:81    1 at 523:96    1 at 525:77    1 at 525:92    1 at 528:75    1 at 528:90
      1 at 529:75    1 at 529:90    1 at 531:75    1 at 531:90    1 at 532:75    1 at 532:90
      1 at 534:75    1 at 534:90    1 at 535:75    1 at 535:90    1 at 538:73    1 at 538:88
      1 at 539:73    1 at 539:88    1 at 541:73    1 at 541:88    1 at 542:73    1 at 542:88
      1 at 544:73    1 at 544:88    1 at 545:73    1 at 545:88    1 at 547:83    1 at 547:98
      1 at 548:82    1 at 548:97    1 at 549:82    1 at 549:97    1 at 551:83    1 at 551:98
      1 at 552:82    1 at 552:97    1 at 553:82    1 at 553:97    1 at 555:73    1 at 555:88
      1 at 556:80    1 at 556:95    1 at 557:80    1 at 557:95    1 at 559:73    1 at 559:88
      1 at 560:80    1 at 560:95    1 at 561:80    1 at 561:95    1 at 563:61    1 at 563:76
      1 at 564:68    1 at 564:83    1 at 565:68    1 at 565:83    
NOTE: There were 7745 observations read from the data set WORK.NWREGVAR.
NOTE: The data set WORK.NWREGVAR has 7745 observations and 232 variables.
NOTE: DATA statement used (Total process time):
      real time           0.05 seconds
      cpu time            0.00 seconds
      

573  
574  
575  data nwregvar;
576  set nwregvar;
577  by rssd9001;
578  if eof1=0  then
579  set nwregvar (firstobs=2 keep=liquid_ratio liq_currliab liquid_growth NWLCR_weight_yq
579! NWLCR_stage2_weight_yq NWLCR_stage3_weight_yq dividend dividend_2 tier1ratio capital_ratio
579! loan_growth illiquid_ratio
580  credit_growth loan_lease_rel htm_mbs_rel afs_mbs_rel htm_abs_rel afs_abs_rel commit_ratio
580! loans_ratio loan_growth_2 asset_growth core_ratio liquid_assets assets RSSD9001 y q
581  rename=(liquid_ratio=liquid_ratio_lead1 liq_currliab=liq_currliab_lead1
581! liquid_growth=liquid_growth_lead1 NWLCR_weight_yq=NWLCR_weight_yq_lead1
581! NWLCR_stage2_weight_yq=NWLCR_stage2_weight_yq_lead1
582    NWLCR_stage3_weight_yq=NWLCR_stage3_weight_yq_lead1 dividend=dividend_lead1
582! dividend_2=dividend_2_lead1 tier1ratio=tier1ratio_lead1 capital_ratio=capital_ratio_lead1
582! loan_growth=loan_growth_lead1
583    illiquid_ratio=illiquid_ratio_lead1 credit_growth=credit_growth_lead1
583! loan_lease_rel=loan_lease_rel_lead1 htm_mbs_rel=htm_mbs_rel_lead1
583! afs_mbs_rel=afs_mbs_rel_lead1
584    htm_abs_rel=htm_abs_rel_lead1 afs_abs_rel=afs_abs_rel_lead1 commit_ratio=commit_ratio_lead1
584!  loans_ratio=loans_ratio_lead1 loan_growth_2=loan_growth_2_lead1
584! asset_growth=asset_growth_lead1
585    core_ratio=core_ratio_lead1 liquid_assets=liquid_assets_lead1 assets=assets_lead1
585! rssd9001=rssd9001_lead1 y=y_lead1 q=q_lead1)) end=eof1;
586  
587  liquid_ratio_lead1=ifn(rssd9001=rssd9001_lead1 & ((y_lead1=y & q_lead1=q+1) | (y_lead1=y+1 &
587! q=4 & q_lead1=1)),liquid_ratio_lead1,.);
588  liq_currliab_lead1=ifn(rssd9001=rssd9001_lead1 & ((y_lead1=y & q_lead1=q+1) | (y_lead1=y+1 &
588! q=4 & q_lead1=1)),liq_currliab_lead1,.);
589  liquid_growth_lead1=ifn(rssd9001=rssd9001_lead1 & ((y_lead1=y & q_lead1=q+1) | (y_lead1=y+1 &
589!  q=4 & q_lead1=1)),liquid_growth_lead1,.);
590  NWLCR_weight_yq_lead1=ifn(rssd9001=rssd9001_lead1 & ((y_lead1=y & q_lead1=q+1) | (y_lead1=y+1
590!  & q=4 & q_lead1=1)),NWLCR_weight_yq_lead1,.);
591  NWLCR_stage2_weight_yq_lead1=ifn(rssd9001=rssd9001_lead1 & ((y_lead1=y & q_lead1=q+1) |
591! (y_lead1=y+1 & q=4 & q_lead1=1)),NWLCR_stage2_weight_yq_lead1,.);
592  NWLCR_stage3_weight_yq_lead1=ifn(rssd9001=rssd9001_lead1 & ((y_lead1=y & q_lead1=q+1) |
592! (y_lead1=y+1 & q=4 & q_lead1=1)),NWLCR_stage3_weight_yq_lead1,.);
593  
594  dividend_lead1=ifn(rssd9001=rssd9001_lead1 & ((y_lead1=y & q_lead1=q+1) | (y_lead1=y+1 & q=4
594! & q_lead1=1)),dividend_lead1,.);
595  dividend_2_lead1=ifn(rssd9001=rssd9001_lead1 & ((y_lead1=y & q_lead1=q+1) | (y_lead1=y+1 &
595! q=4 & q_lead1=1)),dividend_2_lead1,.);
596  tier1ratio_lead1=ifn(rssd9001=rssd9001_lead1 & ((y_lead1=y & q_lead1=q+1) | (y_lead1=y+1 &
596! q=4 & q_lead1=1)),tier1ratio_lead1,.);
597  loan_growth_lead1=ifn(rssd9001=rssd9001_lead1 & ((y_lead1=y & q_lead1=q+1) | (y_lead1=y+1 &
597! q=4 & q_lead1=1)),loan_growth_lead1,.);
598  illiquid_ratio_lead1=ifn(rssd9001=rssd9001_lead1 & ((y_lead1=y & q_lead1=q+1) | (y_lead1=y+1
598! & q=4 & q_lead1=1)),illiquid_ratio_lead1,.);
599  
600  credit_growth_lead1=ifn(rssd9001=rssd9001_lead1 & ((y_lead1=y & q_lead1=q+1) | (y_lead1=y+1 &
600!  q=4 & q_lead1=1)),credit_growth_lead1,.);
601  loan_lease_rel_lead1=ifn(rssd9001=rssd9001_lead1 & ((y_lead1=y & q_lead1=q+1) | (y_lead1=y+1
601! & q=4 & q_lead1=1)),loan_lease_rel_lead1,.);
602  htm_mbs_rel_lead1=ifn(rssd9001=rssd9001_lead1 & ((y_lead1=y & q_lead1=q+1) | (y_lead1=y+1 &
602! q=4 & q_lead1=1)),htm_mbs_rel_lead1,.);
603  afs_mbs_rel_lead1=ifn(rssd9001=rssd9001_lead1 & ((y_lead1=y & q_lead1=q+1) | (y_lead1=y+1 &
603! q=4 & q_lead1=1)),afs_mbs_rel_lead1,.);
604  htm_abs_rel_lead1=ifn(rssd9001=rssd9001_lead1 & ((y_lead1=y & q_lead1=q+1) | (y_lead1=y+1 &
604! q=4 & q_lead1=1)),htm_abs_rel_lead1,.);
605  afs_abs_rel_lead1=ifn(rssd9001=rssd9001_lead1 & ((y_lead1=y & q_lead1=q+1) | (y_lead1=y+1 &
605! q=4 & q_lead1=1)),afs_abs_rel_lead1,.);
606  
607  capital_ratio_lead1=ifn(rssd9001=rssd9001_lead1 & ((y_lead1=y & q_lead1=q+1) | (y_lead1=y+1 &
607!  q=4 & q_lead1=1)),capital_ratio_lead1,.);
608  
609  loans_ratio_lead1=ifn(rssd9001=rssd9001_lead1 & ((y_lead1=y & q_lead1=q+1) | (y_lead1=y+1 &
609! q=4 & q_lead1=1)),loans_ratio_lead1,.);
610  commit_ratio_lead1=ifn(rssd9001=rssd9001_lead1 & ((y_lead1=y & q_lead1=q+1) | (y_lead1=y+1 &
610! q=4 & q_lead1=1)),commit_ratio_lead1,.);
611  
612  loan_growth_2_lead1=ifn(rssd9001=rssd9001_lead1 & ((y_lead1=y & q_lead1=q+1) | (y_lead1=y+1 &
612!  q=4 & q_lead1=1)),loan_growth_2_lead1,.);
613  asset_growth_lead1=ifn(rssd9001=rssd9001_lead1 & ((y_lead1=y & q_lead1=q+1) | (y_lead1=y+1 &
613! q=4 & q_lead1=1)),asset_growth_lead1,.);
614  
615  core_ratio_lead1=ifn(rssd9001=rssd9001_lead1 & ((y_lead1=y & q_lead1=q+1) | (y_lead1=y+1 &
615! q=4 & q_lead1=1)),core_ratio_lead1,.);
616  
617  liquid_assets_lead1=ifn(rssd9001=rssd9001_lead1 & ((y_lead1=y & q_lead1=q+1) | (y_lead1=y+1 &
617!  q=4 & q_lead1=1)),liquid_assets_lead1,.);
618  assets_lead1=ifn(rssd9001=rssd9001_lead1 & ((y_lead1=y & q_lead1=q+1) | (y_lead1=y+1 & q=4 &
618! q_lead1=1)), assets_lead1,.);
619  
620  drop rssd9001_lead1 y_lead1 q_lead1;
621  run;

NOTE: There were 7745 observations read from the data set WORK.NWREGVAR.
NOTE: There were 7744 observations read from the data set WORK.NWREGVAR.
NOTE: The data set WORK.NWREGVAR has 7745 observations and 257 variables.
NOTE: DATA statement used (Total process time):
      real time           0.02 seconds
      cpu time            0.00 seconds
      

622  
623  
624  data temprank;
625  set nwregvar;
626  if RSSD9999=20170930;
627  keep RSSD9001 trans_improve_lag1 RSSD9999 LCRBanks;
628  run;

NOTE: There were 7745 observations read from the data set WORK.NWREGVAR.
NOTE: The data set WORK.TEMPRANK has 191 observations and 4 variables.
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      cpu time            0.00 seconds
      

629  
630  proc rank data=temprank groups=100 out=temprank;
631  var  trans_improve_lag1;
632  ranks trans_improve_lag1_rank_20170930;
633  run;

NOTE: The data set WORK.TEMPRANK has 191 observations and 5 variables.
NOTE: PROCEDURE RANK used (Total process time):
      real time           0.01 seconds
      cpu time            0.00 seconds
      

634  
635  data temprank;
636  set temprank;
637  trans_improve_lag1_rank_20170930=trans_improve_lag1_rank_20170930/100;
638  keep rssd9001 trans_improve_lag1_rank_20170930;
639  run;

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

640  
641  data nwregvar;
642  merge nwregvar temprank;
643  by rssd9001;
644  run;

NOTE: There were 7745 observations read from the data set WORK.NWREGVAR.
NOTE: There were 191 observations read from the data set WORK.TEMPRANK.
NOTE: The data set WORK.NWREGVAR has 7745 observations and 258 variables.
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      cpu time            0.00 seconds
      

645  
646  data nameidlist;
647  set nameidlist;
648  rename regid=rssd9001;
649  run;

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

650  
651  data nwregvar;
652  merge nwregvar (in=a) nameidlist;
653  by rssd9001;
654  if a;
655  run;

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

656  
657  data nwregvar;
658  set nwregvar;
659  if assets~=.;
660  run;

NOTE: There were 7745 observations read from the data set WORK.NWREGVAR.
NOTE: The data set WORK.NWREGVAR has 6623 observations and 259 variables.
NOTE: DATA statement used (Total process time):
      real time           0.02 seconds
      cpu time            0.00 seconds
      

661  
662  
663  proc rank data=nwregvar groups=100 out=nwregvar;
664  var  assets;
665  ranks assets_rank;
666  run;

NOTE: The data set WORK.NWREGVAR has 6623 observations and 260 variables.
NOTE: PROCEDURE RANK used (Total process time):
      real time           0.02 seconds
      cpu time            0.00 seconds
      

667  
668  
669  data potentialma;
670  set nwregvar;
671  if asset_growth>0.1 and rssd9999>20170701 and rssd9999<20180701;
672  keep rssd9001 rssd9999 assets asset_growth liquid_ratio liq_currliab liquid_growth;
673  run;

NOTE: There were 6623 observations read from the data set WORK.NWREGVAR.
NOTE: The data set WORK.POTENTIALMA has 30 observations and 7 variables.
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      cpu time            0.00 seconds
      

674  
675  PROC EXPORT DATA=potentialma
676              FILE="C:\Users\yl2269\Dropbox\Yao_Backup\ChicagoBooth_DB\Research_Project\Bank_li
676! quidity\Journal\JAR\CodeAndData\01_Build\bd_data\potentialma"
677              DBMS=xlsx REPLACE;
678  RUN;

NOTE: The export data set has 30 observations and 7 variables.
NOTE: "C:\Users\yl2269\Dropbox\Yao_Backup\ChicagoBooth_DB\Research_Project\Bank_liquidity\Journal\
      JAR\CodeAndData\01_Build\bd_data\potentialma.xlsx" file was successfully created.
NOTE: PROCEDURE EXPORT used (Total process time):
      real time           0.04 seconds
      cpu time            0.01 seconds
      

679  
680  PROC IMPORT OUT=potentialma_manual
681              FILE="C:\Users\yl2269\Dropbox\Yao_Backup\ChicagoBooth_DB\Research_Project\Bank_li
681! quidity\Journal\JAR\CodeAndData\01_Build\bd_data\potentialma_manual.xlsx"
682              DBMS=xlsx REPLACE;
683  RUN;

NOTE: One or more variables were converted because the data type is not supported by the V9 
      engine. For more details, run with options MSGLEVEL=I.
NOTE: The import data set has 33 observations and 8 variables.
NOTE: WORK.POTENTIALMA_MANUAL data set was successfully created.
NOTE: PROCEDURE IMPORT used (Total process time):
      real time           0.01 seconds
      cpu time            0.00 seconds
      

684  
685  data malist;
686  set potentialma_manual;
687  if AcquiringBank~=.;
688  RSSD9001temp=RSSD9001*1;
689  drop RSSD9001;
690  run;

NOTE: Character values have been converted to numeric values at the places given by: 
      (Line):(Column).
      688:14   
NOTE: There were 33 observations read from the data set WORK.POTENTIALMA_MANUAL.
NOTE: The data set WORK.MALIST has 30 observations and 8 variables.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
      

691  data malist; set malist; rename RSSD9001temp=RSSD9001;run;

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

692  
693  proc sort data=malist;by rssd9001;run;

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

694  proc means data=malist noprint;
695  by rssd9001;
696  var AcquiringBank AG_above_20;
697  output out=malist (drop=_TYPE_ _FREQ_) mean=AcquiringBank AG_above_20;
698  run;

NOTE: There were 30 observations read from the data set WORK.MALIST.
NOTE: The data set WORK.MALIST has 26 observations and 3 variables.
NOTE: PROCEDURE MEANS used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
      

699  
700  data malist;set malist; if AcquiringBank>0 then AcquiringBank=1; if AG_above_20>0 then
700! AG_above_20=1;run;

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

701  
702  data nwregvar;
703  merge nwregvar (in=a) malist;
704  by rssd9001;
705  if a;
706  run;

NOTE: There were 6623 observations read from the data set WORK.NWREGVAR.
NOTE: There were 26 observations read from the data set WORK.MALIST.
NOTE: The data set WORK.NWREGVAR has 6623 observations and 262 variables.
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      cpu time            0.00 seconds
      

707  
708  data nwregvar; set nwregvar; if AcquiringBank=. then AcquiringBank=0; if AG_above_20=. then
708! AG_above_20=0;run;

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

709  
710  
711  
712  data bankwithpost;
713  set nwregvar;
714  if rssd9999<=20180630 and rssd9999>20170630;
715  keep LenderUltiParent RSSD9001 RSSD9999 totalweight totalconnection totalconnection_la
715! totalweight_LA NWLCR_weight_cfvol NWLCR_weight_cfvol_fwd NWLCR_weight_la_cfvol trans_improve
715! trans_improve_LA trans_improve_stage2 trans_improve_stage3 trans_improve_stage2_3 lcrbanks
715! lcrbanks_stage2 lcrbanks_stage3;
716  run;

NOTE: There were 6623 observations read from the data set WORK.NWREGVAR.
NOTE: The data set WORK.BANKWITHPOST has 749 observations and 18 variables.
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      cpu time            0.00 seconds
      

717  proc sort data=bankwithpost; by LenderUltiParent;run;

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

718  data bankwithpost;set bankwithpost; by LenderUltiParent; if last.LenderUltiParent;run;

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

719  
720  data bankwithpre;
721  set nwregvar;
722  if rssd9999>=20160330 and rssd9999<=20170630;
723  withpre=1;
724  keep RSSD9001 withpre;
725  run;

NOTE: There were 6623 observations read from the data set WORK.NWREGVAR.
NOTE: The data set WORK.BANKWITHPRE has 1102 observations and 2 variables.
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      cpu time            0.00 seconds
      

726  proc sort data=bankwithpre; by RSSD9001;run;

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

727  data bankwithpre;set bankwithpre; by RSSD9001; if last.RSSD9001;run;

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

728  
729  
730  proc sort data=bankwithpost;by rssd9001;run;

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

731  proc sort data=bankwithpre;by rssd9001;run;

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

732  
733  data bankstats;
734  merge bankwithpost (in=a) bankwithpre;
735  by rssd9001;
736  if a;
737  run;

NOTE: There were 189 observations read from the data set WORK.BANKWITHPOST.
NOTE: There were 186 observations read from the data set WORK.BANKWITHPRE.
NOTE: The data set WORK.BANKSTATS has 189 observations and 19 variables.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
      

738  
739  data bankstats;
740  set bankstats;
741  if withpre=1;
742  drop withpre;
743  run;

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

744  proc sort data=bankstats; by totalweight;run;

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

745  
746  data samplebank;
747  set bankstats;
748  samplebank=1;
749  keep rssd9001 samplebank;
750  run;

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

751  
752  proc sort data=samplebank;by rssd9001;run;

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

753  proc sort data=nwregvar;by rssd9001;run;

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

754  data nwregvar;
755  merge nwregvar (in=a) samplebank;
756  by rssd9001;
757  if a;
758  run;

NOTE: There were 6623 observations read from the data set WORK.NWREGVAR.
NOTE: There were 186 observations read from the data set WORK.SAMPLEBANK.
NOTE: The data set WORK.NWREGVAR has 6623 observations and 263 variables.
NOTE: DATA statement used (Total process time):
      real time           0.02 seconds
      cpu time            0.00 seconds
      

759  
760  proc sort data=nwregvar;by rssd9001 rssd9999;run;

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

761  
762  
763  data build.nwregvar;
764    set nwregvar;
765  run;

NOTE: There were 6623 observations read from the data set WORK.NWREGVAR.
NOTE: The data set BUILD.NWREGVAR has 6623 observations and 263 variables.
NOTE: DATA statement used (Total process time):
      real time           0.02 seconds
      cpu time            0.00 seconds
      

766  
767  
768  data nwregvar_no_Acquiring;
769  set nwregvar;
770  if AcquiringBank~=1;
771  run;

NOTE: There were 6623 observations read from the data set WORK.NWREGVAR.
NOTE: The data set WORK.NWREGVAR_NO_ACQUIRING has 5845 observations and 263 variables.
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      cpu time            0.00 seconds
      

772  
773  
774  data nwregvar_no_large_Acquiring;
775  set nwregvar;
776  if AG_above_20~=1;
777  run;

NOTE: There were 6623 observations read from the data set WORK.NWREGVAR.
NOTE: The data set WORK.NWREGVAR_NO_LARGE_ACQUIRING has 6197 observations and 263 variables.
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      cpu time            0.00 seconds
      

778  
779  
780  
781  proc sort data=bankstats out=bankstats2;by rssd9001;run;

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

782  data bankstats2;
783  merge bankstats2 (in=a) malist;
784  by rssd9001;
785  if a;
786  run;

NOTE: There were 186 observations read from the data set WORK.BANKSTATS2.
NOTE: There were 26 observations read from the data set WORK.MALIST.
NOTE: The data set WORK.BANKSTATS2 has 186 observations and 20 variables.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
      

787  data bankstats2; set bankstats2; if AcquiringBank=. then AcquiringBank=0; if AG_above_20=.
787! then AG_above_20=0;run;

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

788  
789  data bankstats_no_large_Acquiring;
790  set bankstats2;
791  if AG_above_20~=1;
792  run;

NOTE: There were 186 observations read from the data set WORK.BANKSTATS2.
NOTE: The data set WORK.BANKSTATS_NO_LARGE_ACQUIRING has 174 observations and 20 variables.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
      

793  
794  /*Add variables*/
795  data avgcore;
796  set nwregvar_no_large_Acquiring;
797  if rssd9999>20160101 and rssd9999<20170701;
798  keep rssd9001 rssd9999 y q core_ratio;
799  run;

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

800  
801  proc means data=avgcore noprint;by rssd9001;var core_ratio; output out=avgcore_pre
801! (drop=_freq_ _type_) mean=avgcore_pre;run;

NOTE: There were 1030 observations read from the data set WORK.AVGCORE.
NOTE: The data set WORK.AVGCORE_PRE has 174 observations and 2 variables.
NOTE: PROCEDURE MEANS used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
      

802  
803  data nwregvar_no_large_Acquiring;
804  merge nwregvar_no_large_Acquiring(in=a) avgcore_pre;
805  by rssd9001;
806  if a;
807  run;

NOTE: There were 6197 observations read from the data set WORK.NWREGVAR_NO_LARGE_ACQUIRING.
NOTE: There were 174 observations read from the data set WORK.AVGCORE_PRE.
NOTE: The data set WORK.NWREGVAR_NO_LARGE_ACQUIRING has 6197 observations and 264 variables.
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      cpu time            0.00 seconds
      

808  
809  data build.nwregvar_no_large_Acquiring;
810  set nwregvar_no_large_Acquiring;
811  run;

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

812  
813  
814  PROC EXPORT DATA=nwregvar_no_large_Acquiring
815              FILE="C:\Users\yl2269\Dropbox\Yao_Backup\ChicagoBooth_DB\Research_Project\Bank_li
815! quidity\Journal\JAR\CodeAndData\02_Analysis\an_data\nwregvar_no_large_Acquiring"
816              DBMS=STATA REPLACE;
817  RUN;

NOTE: The export data set has 6197 observations and 264 variables.
NOTE: "C:\Users\yl2269\Dropbox\Yao_Backup\ChicagoBooth_DB\Research_Project\Bank_liquidity\Journal\
      JAR\CodeAndData\02_Analysis\an_data\nwregvar_no_large_Acquiring.dta" file was successfully 
      created.
NOTE: PROCEDURE EXPORT used (Total process time):
      real time           0.03 seconds
      cpu time            0.00 seconds
      

818  
819  
820  PROC EXPORT DATA=bankstats_no_large_Acquiring
821              FILE="C:\Users\yl2269\Dropbox\Yao_Backup\ChicagoBooth_DB\Research_Project\Bank_li
821! quidity\Journal\JAR\CodeAndData\02_Analysis\an_data\bankstats_no_large_Acquiring"
822              DBMS=STATA REPLACE;
823  RUN;

NOTE: The export data set has 174 observations and 20 variables.
NOTE: "C:\Users\yl2269\Dropbox\Yao_Backup\ChicagoBooth_DB\Research_Project\Bank_liquidity\Journal\
      JAR\CodeAndData\02_Analysis\an_data\bankstats_no_large_Acquiring.dta" file was successfully 
      created.
NOTE: PROCEDURE EXPORT used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
      

824  
825  
826  PROC EXPORT DATA=bankstats_no_large_Acquiring
827              FILE="C:\Users\yl2269\Dropbox\Yao_Backup\ChicagoBooth_DB\Research_Project\Bank_li
827! quidity\Journal\JAR\CodeAndData\02_Analysis\an_data\bankstats_no_large_Acquiring"
828              DBMS=xlsx REPLACE;
829  RUN;

NOTE: The export data set has 174 observations and 20 variables.
NOTE: "C:\Users\yl2269\Dropbox\Yao_Backup\ChicagoBooth_DB\Research_Project\Bank_liquidity\Journal\
      JAR\CodeAndData\02_Analysis\an_data\bankstats_no_large_Acquiring.xlsx" file was 
      successfully created.
NOTE: PROCEDURE EXPORT used (Total process time):
      real time           0.10 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           17.36 seconds
      cpu time            1.57 seconds
      
