The SASEXFSD Interface Engine

Example 43.1 Retrieving Standardized Economic Items for Multiple Countries

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.

title 'Retrieve Standardized Economic Items for Multiple Countries (US,GR)';
libname _all_ clear;

libname xfsd sasexfsd "%sysget(FACTSET)"
   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;

Output 43.1.1: Standardized Economic Items for Multiple Countries

Retrieve Standardized Economic Items for Multiple Countries (US,GR)

Obs FQL_Entity date fds_econ_gdp_usd_y
1 CC_US 12-31-2006 13377.20
2 CC_US 12-31-2007 14028.70
3 CC_US 12-31-2008 14291.50
4 CC_US 12-31-2009 13973.70
5 CC_US 12-31-2010 14498.90
6 CC_US 12-31-2011 15075.70
7 CC_GR 12-31-2006 261.85
8 CC_GR 12-31-2007 305.54
9 CC_GR 12-31-2008 341.24
10 CC_GR 12-31-2009 321.34
11 CC_GR 12-31-2010 294.03
12 CC_GR 12-31-2011 290.04