Bank Profitability Statistics

/*----------------------------------------------------------------

                   SAS SAMPLE LIBRARY

       Name: oecdex03.sas
Description: Example program from SAS/ETS User's Guide,
             The SASEOECD Interface Engine
      Title: Bank Profitability Statistics
    Product: SAS/ETS Software
       Keys: OECD data retrieval
      Procs: SASEOECD
      Notes:

           libname oecd saseoecd "%sysget(OECD_DATA)"
              SETID=BPF1
              FORMAT=JSON
              OUT=BALBK
              INSET0=keylist0
              INSET1=keylist1
              INSET2=keylist2
              START='1999'
              END='2009'
              ;
 ----------------------------------------------------------------*/

options validvarname=any
   sslcalistloc="<physical path and file name to specify your security certificates>";

data keylist0;
   length key0 $16;
   key0='BALSH_TOT'; output;
   key0='BT25TE'; output;
   key0='BT26TE'; output;
run;

data keylist1;
   length key1 $8;
   key1='ALL'; output;
run;

data keylist2;
   length key2 $8;
   key2='USA'; output;
   key2='NMEC'; output;
   key2='RUS'; output;
run;

title 'Request BPF1 for USA,NMEC and RUS, Annual Data';
libname _all_ clear;
LIBNAME myLib saseoecd "physical path to your folder for storing the OECD data"
   setid=BPF1
   inset0=keylist0
   inset1=keylist1
   inset2=keylist2
   out=BALBK
   start='1999'
   end='2009'
   format=json;

data myBALBK;
    set myLib.BALBK;
run;


proc contents data=myBALBK; run;
proc print data=myBALBK; run;