
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.
title 'Retrieve List of Securities Belonging to a Single Screen File'; libname _all_ clear; libname xfsd sasexfsd "%sysget(FACTSET)" 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 43.8.1: List of CUSIPs and Names from a Screen File
| Retrieve List of Securities Belonging to a Single Screen File |
| Obs | CUSIP | NAME |
|---|---|---|
| 1 | 00176510 | AMR CORP/DE |
| 2 | 00208J10 | ATP OIL & GAS CORP |
| 3 | 00258J10 | ABAKAN INC |
| 4 | 00404A10 | ACADIA HEALTHCARE CO INC |
| 5 | 00439710 | ACCURAY INC |
| 6 | 00439T20 | ACCURIDE CORP |
| 7 | 00752K10 | ADVANCED CELL TECHNOLOGY INC |
| 8 | 00767C10 | ADVANCED VOICE RECOGNITION |
| 9 | 00847J10 | AGILYSYS INC |
| 10 | 02051Q10 | ALON HOLDINGS BLUE SQUARE IS |
| 11 | 02052010 | ALON USA ENERGY INC |
| 12 | 02215R10 | ALTUS GROUP LTD |
| 13 | 03149820 | AMICA MATURE LIFESTYLES INC |
| 14 | 03236M10 | AMYRIS INC |
| 15 | 03444Q20 | ANDREW PELLER LTD |