The SASEXFSD Interface Engine

Example 43.15 Retrieving a List of CUSIPs from a Screen File

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.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