The SASEXFSD Interface Engine

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;