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 44.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 |