SASEXFSD Interface Engine

(View the complete code for this example.)

This example shows how to use the ExtractEconData factlet to retrieve the standardized government debt values, reflecting debt in billions of dollars at year end for the United States and Greece and using the country identifiers CC_US and CC_GR and the standardized FactSet economic code FDS_ECON_GDP_USD_Y.

options validvarname=any;

title 'Retrieve Standardized Economic Items for Multiple Countries (US,GR)';
libname _all_ clear;
libname xfsd sasexfsd "%sysget(FACTSET)"
   debug=on
   factlet=ExtractEconData
   ids='CC_US,CC_GR'
   items='FDS_ECON_GDP_USD_Y'
   dates='-6:-1:y'
   period=QTR
   format=sml
   outXml=fsdex06
   automap=replace
   mapref=MyMap
   xmlmap="%sysget(FACTSET)fsdex06.map"
   orientation=eti
   user='XXXXXXXXXXXXXXXX'
   pass='XXXXXXXXXXXXXXXX';

data econStnd; set xfsd.fsdex06; run;
proc print data=econStnd; run;