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
You can use the SAS DATA step to write the selected FactSet data to a SAS data set. This enables you to use SAS software to easily analyze the data. If you specify the name of the output data set in the DATA step, the engine supervisor creates a SAS data set that has the specified name in either the SAS Work library or, if specified, the User library.
The contents of the SAS data set include the BY groups, the date of each observation, and the series name of each series that is read from the FactSet data source.
The SASEXFSD interface engine sorts the IDs into keys or BY groups, so that the time series are sorted in the resulting SAS data set by key (entity identifier such as a ticker), by date (time ID), and by variable (time series item name).
You can use the PRINT and CONTENTS procedures to print your output data set and its contents. Alternatively, you can view your SAS output observations by opening the desired output data set in a SAS Explorer window. You can also use the SQL procedure with your SASEXFSD libref to create a custom view of your data.