The SASEXFSD Interface Engine

Example 43.10 Retrieving Data by Using the ISON= and ISONPARAMS= Options

This example shows how to use the ExtractDataSnapshot factlet to retrieve price-to-earnings (PE) data for the quarterly estimate period by using the ISON= and ISONPARAMS= options. For brevity, only a subset of the output (the first 10 CUSIPs) is displayed.

title 'Retrieve Price-to-Earnings Data by Using ISON/ISONPARAMS';
libname _all_ clear;

libname xfsd sasexfsd "%sysget(FACTSET)"
   factlet=ExtractDataSnapshot
   ison='sp500'
   isonparams='0,1'
   items='ff_pe'
   dates='20110401'
   period=QTR
   format=sml
   outXml=fsdex10
   automap=replace
   mapref=MyMap
   xmlmap="%sysget(FACTSET)fsdex10.map"
   orientation=eti
   user='XXXXXXXXXXXXXXXX'
   pass='XXXXXXXXXXXXXXXX';

data snapIson; set xfsd.fsdex10; run;
proc print data=snapIson(firstobs=1 obs=10); run;

Output 43.10.1: Retrieving Price-to-Earnings Data by Using the ISON= and ISONPARAMS= Options

Retrieve Price-to-Earnings Data by Using ISON/ISONPARAMS

Obs FQL_Entity date ff_pe
1 17290810 04-01-2011 18.1419
2 41308610 04-01-2011 13.2635
3 80589M10 04-01-2011 13.3007
4 50242410 04-01-2011 9.5995
5 91301710 04-01-2011 17.2053
6 97665710 04-01-2011 14.5238
7 00130H10 04-01-2011 .
8 31190010 04-01-2011 33.0765
9 20911510 04-01-2011 13.5979
10 53983010 04-01-2011 10.0212