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

3    
4    proc import out= sample datafile =
4  ! "C:\Users\yl2269\Dropbox\Yao_Backup\ChicagoBooth_DB\Research_Project\Bank_liquidity\Journal\J
4  ! AR\CodeAndData\02_Analysis\an_data\nwregvar_no_large_Acquiring.dta";
5    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 6197 observations and 264 variables.
NOTE: WORK.SAMPLE data set was successfully created.
NOTE: PROCEDURE IMPORT used (Total process time):
      real time           0.02 seconds
      cpu time            0.00 seconds
      

6    
7    
8    data sample;
9    set sample;
10   if lcrbanks~=1 & totalweight<10001 & totalweight>6 & rssd9999>20160101 & rssd9999<20180401;
11   keep assets liquid_ratio_lead1 trans_improve_lag1 liquid_ratio core_ratio capital_ratio
11 ! commit_ratio size loan_growth npl_rel intrate ebp_rel  lcrbanks totalweight rssd9999 rssd9001
11 !  improve_potential_lag1 post_lag1;
12   run;

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

13   
14   data infogain;
15   set sample;
16   if rssd9999=20170331;
17   keep improve_potential_lag1;
18   run;

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

19   
20   proc means data=infogain noprint;
21   var improve_potential_lag1;
22   output out=infogain_med (drop=_freq_ _type_) median=improve_potential_lag1_med;
23   run;

NOTE: There were 118 observations read from the data set WORK.INFOGAIN.
NOTE: The data set WORK.INFOGAIN_MED has 1 observations and 1 variables.
NOTE: PROCEDURE MEANS used (Total process time):
      real time           0.01 seconds
      cpu time            0.00 seconds
      

24   
25   data infogain_med;set infogain_med;check=1;run;

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

26   data sample;set sample;check=1;run;

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

27   data sample;
28   merge sample infogain_med;
29   by check;
30   run;

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

31   
32   data sample;
33   set sample;
34   length InfoGain_D $5.;
35   improve_potential_lag1_d=ifn(improve_potential_lag1>improve_potential_lag1_med,1,0);
36   InfoGain_D="low";
37   if improve_potential_lag1_d=1 then InfoGain_D="high";
38   drop improve_potential_lag1_med check ;
39   run;

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

40   
41   /*PSM*/
42   ods graphics on;
43   proc psmatch data=sample region=cs;
44   class InfoGain_D;
45   psmodel InfoGain_D(Treated="high")= liquid_ratio core_ratio capital_ratio commit_ratio size
45 ! loan_growth npl_rel intrate ebp_rel ;
46   match method=greedy(k=1) stat=lps caliper=0.15;
47   assess lps var=(liquid_ratio core_ratio capital_ratio commit_ratio size loan_growth npl_rel
47 ! intrate ebp_rel ) / weight=none plots=(boxplot barchart);
48   output out(obs=match)=Outgs lps=_Lps matchid=_MatchID;
49   run;

NOTE: Writing HTML Body file: sashtml.htm
WARNING: Some treated units do not have matched controls because there are not enough available 
         controls for these treated units.
NOTE: The data set WORK.OUTGS has 656 observations and 24 variables.
NOTE: PROCEDURE PSMATCH used (Total process time):
      real time           1.84 seconds
      cpu time            0.15 seconds
      

50   proc sort data=outgs;by infogain_d;run;

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

51   proc means data= outgs;
52   var size assets improve_potential_lag1;
53   by infogain_d;
54   run;

NOTE: There were 656 observations read from the data set WORK.OUTGS.
NOTE: PROCEDURE MEANS used (Total process time):
      real time           0.01 seconds
      cpu time            0.00 seconds
      

55   
56   
57   PROC EXPORT DATA=outgs
58               FILE="C:\Users\yl2269\Dropbox\Yao_Backup\ChicagoBooth_DB\Research_Project\Bank_li
58 ! quidity\Journal\JAR\CodeAndData\02_Analysis\an_data\PSM"
59               DBMS=STATA REPLACE;
60   RUN;

NOTE: The export data set has 656 observations and 24 variables.
NOTE: "C:\Users\yl2269\Dropbox\Yao_Backup\ChicagoBooth_DB\Research_Project\Bank_liquidity\Journal\
      JAR\CodeAndData\02_Analysis\an_data\PSM.dta" file was successfully created.
NOTE: PROCEDURE EXPORT used (Total process time):
      real time           0.00 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           16.04 seconds
      cpu time            0.98 seconds
      
