The SASEXFSD Interface Engine

The ExtractScreenUniverse Factlet

The ExtractScreenUniverse factlet is used for extracting a list of CUSIPs stored in a single FactSet screen. On the FactSet workstation, a user can screen for equity and fixed income securities based on specified criteria and store a list of companies by using FactSet Universal Screening for equity or debt securities. The ExtractScreenUniverse factlet uses the options that are listed in Table 44.18 to extract a list of CUSIPs that belong to a single user-defined screen. Use the SCREEN= option to specify a screen file, and use the NAME= option to specify whether or not to make the names of the corresponding securities visible. Specify NAME=Y (yes) to view the security names for each CUSIP in the screen. NAME=N (no) is the default, for which security names are not shown with the CUSIP list. Because screen filenames can contain blanks and special characters, enclose the screen filename with single quotation marks:

   options validvarname=any;
   LIBNAME myFast sasexfsd "%sysget(FACTSET)"
       debug=on
       factlet=ExtractScreenUniverse
       screen='factset:1 Week EPS Estimate Revisions - FactSet Consensus'
       name=y
       format=sml
       outXml=sasscrn4
       automap=replace
       mapref=MyMap
       xmlmap="%sysget(FACTSET)sasscrn4.map"
       period=QTR
       user='XXXXXXXXXXXXXXXX'
       pass='XXXXXXXXXXXXXXXX'
       ; 

Table 44.18: ExtractScreenUniverse Factlet Options

Option

Description

SCREEN=

Specifies a screen file

NAME=

Specifies whether security names are to be visible. NAME=Y indicates yes to show names; default is N, indicating that no names are shown.