The SASEXFSD Interface Engine (Experimental)

This example shows how to use the ExtractOFDBUniverse factlet to retrieve a list of securities that belong to a single OFDB file named SASTESTING for February 27, 2012. For brevity, only a subset of the output (the first 15 securities) is displayed.

title 'Retrieve List of Securities Belonging to a Single OFDB File';
libname _all_ clear;

libname xfsd sasexfsd "%sysget(FACTSET)"
   factlet=ExtractOFDBUniverse
   ofdb='SASTESTING.OFDB'
   dates='20120227'
   format=sml
   outXml=fsdex08
   automap=replace
   mapref=MyMap
   xmlmap="%sysget(FACTSET)fsdex08.map"
   user='XXXXXXXXXXXXXXXX'
   pass='XXXXXXXXXXXXXXXX';

data ofdbUniv;
   set xfsd.fsdex08;
run;
proc print
   data=ofdbUniv  (firstobs=1 obs=15);
run;