The SASEXFSD Interface Engine (Experimental)

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