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 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 file names can contain blanks and special characters, enclose the screen file name in 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 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. |