SASEXFSD Interface Engine

(View the complete code for this example.)

This example shows how to use the ExtractOFDBItem factlet to retrieve the uploaded share and price data for IBM and Microsoft from an OFDB file named SASTESTING for an absolute date range, starting February 27, 2012, and ending February 28, 2012, with a monthly frequency.

options validvarname=any;

title 'Retrieve Shares and Price Data for IBM and MSFT from an OFDB File';
libname _all_ clear;
libname xfsd sasexfsd "%sysget(FACTSET)"
   debug=on
   factlet=ExtractOFDBItem
   ofdb='SASTESTING.OFDB'
   ids='ibm,msft'
   items='shares,price'
   dates='20120227:20120228:d'
   period=QTR
   format=sml
   outXml=fsdex07
   automap=replace
   mapref=MyMap
   xmlmap="%sysget(FACTSET)fsdex07.map"
   orientation=eti
   user='XXXXXXXXXXXXXXXX'
   pass='XXXXXXXXXXXXXXXX';

data shareOFDB; set xfsd.fsdex07; run;
proc print data=shareOFDB; run;