The SASEXFSD Interface Engine

This simple example shows how to use the ExtractFormulaHistory factlet to retrieve price data for one company (in this case IBM).

title 'Retrieve Price Data for IBM';
libname _all_ clear;

libname xfsd sasexfsd "%sysget(FACTSET)"
   factlet=ExtractFormulaHistory
   ids='ibm'
   items='p_price'
   dates='20110130:20111231:m'
   format=sml
   outXml=fsdex01
   automap=replace
   mapref=MyMap
   xmlmap="%sysget(FACTSET)fsdex01.map"
   orientation=eti
   user='XXXXXXXXXXXXXXXX'
   pass='XXXXXXXXXXXXXXXX';

data recentprice; set xfsd.fsdex01; run;
proc print data=recentprice; run;