The SASEXFSD Interface Engine (Experimental)
- Overview
- Getting Started
-
Syntax
-
Details
-
ExamplesRetrieving Price Data for One CompanyRetrieving Price and Sales Data for Multiple CompaniesRetrieving Book Value Data for One Company by Using Relative DatesRetrieving Multiple Screen Items for Multiple CompaniesRetrieving Data by Using ISON and ISONParamsRetrieving Multiple Items for Multiple Companies from an OFDB FileRetrieving a List of Securities from an OFDB fileRetrieving a List of CUSIPs from a Screen FileRetrieving Standardized Economic Items for Multiple Countries
- References
The ExtractEconData factlet provides access to a broad array of macroeconomic content, interest rates and yields, country indices, and various exchange rate measures from both the FactSet Economics and Standardized Economic databases. The ExtractEconData factlet uses the options listed in Table 43.15 to extract economic items for a list of country IDs or for no country IDs over time. Use the IDS= option to specify one or more country IDs based on the database source. See Table 43.16 for the complete list of country IDs that work with the standardized codes for the FactSet Economics database. Use the ITEM= option to specify an FQL item based on the database source. See the ExtractEconData appendix (link on page ID 16948 in the FactSet Online Assistant) for the complete list of the data series codes available with the FactSet Economics database. The series data are available in monthly, quarterly, and annual frequencies, as is denoted by the _M, _Q, _Y suffixes in the series code. You can use the START=, END=, and FREQ= options or the DATES= option to specify a date range for selecting time series data. The ORIENTATION= option supports only ETI, which is the default.
Table 43.15: ExtractEconData Factlet Options
|
Option |
Description |
|---|---|
|
IDS= |
String array with a list of the tickers country identifiers from the standardized economic database. |
|
ITEMS=* |
String specifying the economic series mnemonic (for example, US GDP data base source[mnemonic] is FDS_ECON[BEANIPAA191RL1@US]). |
|
DATES= |
YYYYMMDD:YYYYMMDD:F; or relative dates -1b:-4b:m. |
|
START= |
Start date entered in mm/dd/yyyy format. |
|
END= |
End date entered in mm/dd/yyyy format. |
|
FREQ= |
Valid FQL frequencies; for example, M, D, Y. Note: For economic request codes, a frequency argument is necessary to retrieve the data. See Table 43.18. |
|
ORIENTATION= |
Optional orientation (default is currently ETI). |
|
* SAS 9.3 supports only the data items that return numeric values. |
|
Table 43.16: Country Identifiers
|
Country |
Country ID |
Country |
Country ID |
|---|---|---|---|
|
Argentina |
CC_AR |
Lithuania |
CC_LT |
|
Australia |
CC_AU |
Luxembourg |
CC_LU |
|
Austria |
CC_AT |
Malaysia |
CC_MY |
|
Azerbaijan |
CC_AZ |
Malta |
CC_MT |
|
Bangladesh |
CC_BD |
Mexico |
CC_MX |
|
Belarus |
CC_BY |
Morocco |
CC_MA |
|
Belgium |
CC_BE |
Netherlands |
CC_NL |
|
Bolivia |
CC_BO |
New Zealand |
CC_NZ |
|
Brazil |
CC_BR |
Nigeria |
CC_NG |
|
Bulgaria |
CC_BG |
Norway |
CC_NO |
|
Canada |
CC_CA |
Pakistan |
CC_PK |
|
Chile |
CC_CL |
Panama |
CC_PA |
|
China |
CC_CN |
Paraguay |
CC_PY |
|
Colombia |
CC_CO |
Peru |
CC_PE |
|
Costa Rica |
CC_CR |
Philippines |
CC_PH |
|
Croatia |
CC_HR |
Poland |
CC_PL |
|
Cyprus |
CC_CY |
Portugal |
CC_PT |
|
Czech Republic |
CC_CZ |
Romania |
CC_RO |
|
Denmark |
CC_DK |
Russia |
CC_RU |
|
Dominican Republic |
CC_DO |
Saudi Arabia |
CC_SA |
|
Ecuador |
CC_EC |
Singapore |
CC_SG |
|
Egypt |
CC_EG |
Slovakia |
CC_SK |
|
Estonia |
CC_EE |
Slovenia |
CC_SI |
|
Finland |
CC_FI |
South Africa |
CC_ZA |
|
France |
CC_FR |
South Korea |
CC_KR |
|
Germany |
CC_DE |
Spain |
CC_ES |
|
Greece |
CC_GR |
Sri Lanka |
CC_LK |
|
Hong Kong |
CC_HK |
Sweden |
CC_SE |
|
Hungary |
CC_HU |
Switzerland |
CC_CH |
|
Iceland |
CC_IS |
Taiwan |
CC_TW |
|
India |
CC_IN |
Thailand |
CC_TH |
|
Indonesia |
CC_ID |
Turkey |
CC_TR |
|
Ireland |
CC_IE |
Ukraine |
CC_UA |
|
Israel |
CC_IL |
United Kingdom |
CC_GB |
|
Italy |
CC_IT |
United States |
CC_US |
|
Japan |
CC_JP |
Uruguay |
CC_UY |
|
Jordan |
CC_JO |
Uzbekistan |
CC_UZ |
|
Kazakhstan |
CC_KK |
Venezuela |
CC_VE |
|
Latvia |
CC_LV |
Vietnam |
CC_VN |