The SASEXFSD Interface Engine

Example 44.14 Retrieving a List of Securities from an OFDB file

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;

Output 44.14.1: List of Securities from a Single OFDB File

Retrieve List of Securities Belonging to a Single OFDB File

Obs CUSIP
1 00105510
2 00120410
3 00130H10
4 00206R10
5 00282410
6 00289620
7 00507K10
8 00724F10
9 00790310
10 00817Y10
11 00846U10
12 00915810
13 00936310
14 00971T10
15 01381710