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 ExtractOFDBUniverse factlet to retrieve a list of securities that belong to a single OFDB file named SASTESTING for February 27, 2012. For brevity, only a subset of the output (the first 15 securities) is displayed.
title 'Retrieve List of Securities Belonging to a Single OFDB File'; libname _all_ clear; libname xfsd sasexfsd "%sysget(FACTSET)" factlet=ExtractOFDBUniverse ofdb='SASTESTING.OFDB' dates='20120227' format=sml outXml=fsdex08 automap=replace mapref=MyMap xmlmap="%sysget(FACTSET)fsdex08.map" user='XXXXXXXXXXXXXXXX' pass='XXXXXXXXXXXXXXXX'; data ofdbUniv; set xfsd.fsdex08; run; proc print data=ofdbUniv(firstobs=1 obs=15); run;