The SASEXFSD Interface Engine

This example shows how to use the ExtractEconData factlet to retrieve the Returns for the GDPEURNS quarterly time series for Greece over the last 10 years by using the FQL economic download syntax. It is not necessary to use the IDS= option, because the FQL downloading syntax allows ’\@@GR’ to be appended to the series name in the ITEMS= option. The PRINT procedure uses the LABEL option to allow the time series name to be in the column heading in the output. Without the LABEL option, the column heading would be ’ECON_EXPR_DATA’.

option validvarname=any;

title 'Retrieve Returns Using ECON_EXPR_DATA for the GDPEURNS@GR Series';
libname _all_ clear;

libname xfsd sasexfsd "%sysget(FACTSET)"
   factlet=ExtractEconData
   items="ECON_EXPR_DATA('RETURNS(EURO_STAT[GDPEURNS@GR],-1AQ,4)',0,0/0/-10,q)"
   format=sml
   outXml=fsdecon20
   automap=replace
   mapref=MyMap
   xmlmap="%sysget(FACTSET)fsdecon20.map"
   orientation=eti
   user='XXXXXXXXXXXXXXXX'
   pass='XXXXXXXXXXXXXXXX';

data EUROFunc; set xfsd.fsdecon20; run;
proc print data=EUROFunc label; run;