The SASEQUAN Interface Engine

This example shows how to use one Quandl code, GOOG/TYO_1551, to retrieve the price and yield performance of the JASDAQ-TOP20 Exchange Traded Fund (ETF) in Japan, starting January 1, 2014, and ending March 26, 2014, with a daily native frequency. The output is shown in Output 43.4.1.

options validvarname=any;

title 'JASDAQ-TOP20 ETF, Five Time Series';
libname _all_ clear;
libname mylib "U:\quan950\doc\";

libname myTOP20 sasequan "%sysget(QUANDL)"
   apikey='XXXXXXXXXXXXXXXXXXXX'
   idlist='GOOG/TYO_1551'
   format=XML
   outXml=jasdaq
   automap=replace
   mapref=MyMap
   xmlmap="%sysget(QUANDL)jasdaq.map"
   start='2014-01-01'
   end='2014-03-26'
   ;

data mylib.jasdaq;
   set myTOP20.jasdaq;
run;

proc contents data=mylib.jasdaq; run;
proc print data=mylib.jasdaq; run;