The SASEXFSD Interface Engine (Experimental)

This example shows how to use the ExtractDataSnapshot factlet to retrieve price-to-earnings (PE) data for the quarterly estimate period by using ISON and ISONParams. 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;