The SASEXFSD Interface Engine
- Overview
- Getting Started
-
Syntax
-
Details
-
ExamplesRetrieving Standardized Economic Items for Multiple CountriesRetrieving Economic Items by Using the FQL Syntax for Function Z ScoreUsing ECON_EXPR_DATA with the FQL Syntax for Function ReturnsUsing SPEC_ID_DATA with the FQL Economic Download SyntaxUsing Multiple Database Sources with the FQL SyntaxRetrieving 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 the ISON= and ISONPARAMS= OptionsRetrieving Benchmark Data by Using the CUTOFF= optionRetrieving Benchmark Data by Using the MATCHDATE= OptionRetrieving Multiple Items for Multiple Companies from an OFDB FileRetrieving a List of Securities from an OFDB fileRetrieving a List of CUSIPs from a Screen File
- References
Example 52.13 Retrieving Multiple Items for Multiple Companies from an OFDB File
This example shows how to use the ExtractOFDBItem factlet to retrieve the uploaded share and price data for IBM and Microsoft from an OFDB file named SASTESTING for an absolute date range, starting February 27, 2012, and ending February 28, 2012, with a monthly frequency.
title 'Retrieve Shares and Price Data for IBM and MSFT from an OFDB File'; libname _all_ clear; libname xfsd sasexfsd "%sysget(FACTSET)" factlet=ExtractOFDBItem ofdb='SASTESTING.OFDB' ids='ibm,msft' items='shares,price' dates='20120227:20120228:d' period=QTR format=sml outXml=fsdex07 automap=replace mapref=MyMap xmlmap="%sysget(FACTSET)fsdex07.map" orientation=eti user='XXXXXXXXXXXXXXXX' pass='XXXXXXXXXXXXXXXX'; data shareOFDB; set xfsd.fsdex07; run; proc print data=shareOFDB; run;
Output 52.13.1: Multiple Items for Multiple Companies from an OFDB File