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 |