Fisheries and Aquaculture Statistics

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

                   SAS SAMPLE LIBRARY

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

           libname oecd saseoecd "%sysget(OECD_DATA)"
              SETID=FISH_EMPL
              OUT=FISHEMP
              INSET0=keylist0
              INSET1=keylist1
              INSET2=keylist2
              INSET3=keylist3
              START='2009'
              END='2016'
              ;
 ----------------------------------------------------------------*/

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

data keylist0;
   length key0 $3;
   key0='CZE'; output;
run;

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

data keylist2;
   length key2 $3;
   key2='MAL'; output;
   key2='FEM'; output;
run;

data keylist3;
   length key3 $3;
   key3='PA'; output;
   key3='FU'; output;
run;

title 'Request FISH_EMPL Data, Annual Data';
libname _all_ clear;
LIBNAME myLib saseoecd "physical path to your folder for storing the OECD data"
   setid=FISH_EMPL
   inset0=keylist0
   inset1=keylist1
   inset2=keylist2
   inset3=keylist3
   out=FISHEMP
   start='2009'
   end='2016'
   ;

data myfish;
    set myLib.fishemp;
run;


proc print data=myfish; run;