SASEXFSD Interface Engine

(View the complete code for this example.)

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.

options validvarname=any;

title 'Retrieve Price-to-Earnings Data by Using ISON/ISONPARAMS';
libname _all_ clear;
libname xfsd sasexfsd "%sysget(FACTSET)"
   debug=on
   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;