The SASEXFSD Interface Engine

This example shows how to use the ExtractEconData factlet to retrieve the Z score for the GRLM0347861 monthly time series for Greece over the last three years by using the FQL economic download syntax. It is not necessary to use the IDS= option, because all necessary information is contained 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 the Z Score Using ECON_EXPR_DATA for the US CFTNCLOI%ALLNQ100CMEF Series';
libname _all_ clear;

libname xfsd sasexfsd "%sysget(FACTSET)"
   factlet=ExtractEconData
   items="ECON_EXPR_DATA('ZSCORE(FDS_ECON[GRLM0347861],
   -5AY,step,average)',0,0/0/-3,m)"
   format=sml
   outXml=fsdecon8z
   automap=replace
   mapref=MyMap
   xmlmap="%sysget(FACTSET)fsdecon8z.map"
   orientation=eti
   user='XXXXXXXXXXXXXXXX'
   pass='XXXXXXXXXXXXXXXX';

data FQLeconFunc; set xfsd.fsdecon8z; run;
proc print data=FQLeconFunc(firstobs=1 obs=34) label; run;