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
This example shows how to use the ExtractDataSnapshot factlet to extract multiple screen items (price and sales) as of a single date for multiple companies (in this case IBM and Microsoft) for the quarterly estimate period (PERIOD=QTR).
title 'Retrieve Multiple Screen Items for Multiple Companies'; libname _all_ clear; libname xfsd sasexfsd "%sysget(FACTSET)" factlet=ExtractDataSnapshot ids='ibm,msft' items='p_price,ff_sales' dates='20110401' period=QTR format=sml outXml=fsdex05 automap=replace mapref=MyMap xmlmap="%sysget(FACTSET)fsdex05.map" orientation=eti user='XXXXXXXXXXXXXXXX' pass='XXXXXXXXXXXXXXXX'; data snapshot; set xfsd.fsdex05; run; proc print data=snapshot; run;