The SASEXFSD Interface Engine

Example 44.6 Retrieving Price Data for One Company

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;

Output 44.6.1: Price Data for IBM

Retrieve Price Data for IBM

Obs FQL_Entity date p_price
1 ibm 01-31-2011 162.000
2 ibm 02-28-2011 161.880
3 ibm 03-31-2011 163.070
4 ibm 04-30-2011 170.580
5 ibm 05-31-2011 168.930
6 ibm 06-30-2011 171.550
7 ibm 07-31-2011 181.850
8 ibm 08-31-2011 171.910
9 ibm 09-30-2011 174.870
10 ibm 10-31-2011 184.630
11 ibm 11-30-2011 188.000
12 ibm 12-31-2011 183.880