SASEXFSD Interface Engine

(View the complete code for this example.)

This example shows how to use the ExtractFormulaHistory factlet to retrieve several data items for several companies. The data items are price and sales, and the companies are IBM and FactSet (FDS).

options validvarname=any;

title 'Retrieve Price and Sales Data for IBM and FactSet(FDS)';
libname _all_ clear;
libname xfsd sasexfsd "%sysget(FACTSET)"
   debug=on
   factlet=ExtractFormulaHistory
   ids='ibm,fds'
   items='p_price,ff_sales'
   dates='20110130:20110631:m'
   format=sml
   outXml=fsdex02
   automap=replace
   mapref=MyMap
   xmlmap="%sysget(FACTSET)fsdex02.map"
   orientation=eti
   user='XXXXXXXXXXXXXXXX'
   pass='XXXXXXXXXXXXXXXX';

data priceSale; set xfsd.fsdex02; run;
proc print data=priceSale; run;