(View the complete code for this example.)
This example shows how to use the ExtractScreenUniverse factlet to retrieve a list of CUSIPs and names that belong to a single user-defined screen file. For brevity, only a subset of the output (the first 15 securities) is displayed.
options validvarname=any;
title 'Retrieve List of Securities Belonging to a Single Screen File';
libname _all_ clear;
libname xfsd sasexfsd "%sysget(FACTSET)"
debug=on
factlet=ExtractScreenUniverse
screen='factset:bankruptcy'
name=y
format=sml
outXml=fsdex09
automap=replace
mapref=MyMap
xmlmap="%sysget(FACTSET)fsdex09.map"
user='XXXXXXXXXXXXXXXX'
pass='XXXXXXXXXXXXXXXX';
data screenUniv; set xfsd.fsdex09; run;
proc print data=screenUniv(firstobs=1 obs=15); run;
Output 56.15.1: List of CUSIPs and Names from a Screen File
| Retrieve List of Securities Belonging to a Single Screen File |
| Obs | Id | Name |
|---|---|---|
| 1 | 00081T10 | ACCO BRANDS CORP |
| 2 | 00258J10 | ABAKAN INC |
| 3 | 00439710 | ACCURAY INC |
| 4 | 00439T20 | ACCURIDE CORP |
| 5 | 00520810 | ADA-ES INC |
| 6 | 00752K10 | ADVANCED CELL TECHNOLOGY INC |
| 7 | 00847J10 | AGILYSYS INC |
| 8 | 02051Q10 | ALON HOLDINGS BLUE SQUARE IS |
| 9 | 02152V10 | ALTEROLA BIOTECH INC |
| 10 | 02153D10 | ALTERRA POWER CORP |
| 11 | 03011110 | AMERICAN SUPERCONDUCTOR CP |
| 12 | 03236M10 | AMYRIS INC |
| 13 | 03242010 | ANACOR PHARMACEUTICALS INC |
| 14 | 04269E10 | ARQULE INC |
| 15 | 04544X30 | ASSISTED LIVING CONCEPTS INC |