SASEXFSD Interface Engine

(View the complete code for this example.)

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

options validvarname=any;

title 'Retrieve Price Data for IBM';
libname _all_ clear;
libname xfsd sasexfsd "%sysget(FACTSET)"
   debug=on
   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;