The SASEXFSD Interface Engine

This example shows how to use the ExtractDataSnapshot factlet to extract multiple screen items (price and sales) as of a single date for multiple companies (in this case IBM and Microsoft) for the quarterly estimate period (PERIOD=QTR).

title 'Retrieve Multiple Screen Items for Multiple Companies';
libname _all_ clear;

libname xfsd sasexfsd "%sysget(FACTSET)"
   factlet=ExtractDataSnapshot
   ids='ibm,msft'
   items='p_price,ff_sales'
   dates='20110401'
   period=QTR
   format=sml
   outXml=fsdex05
   automap=replace
   mapref=MyMap
   xmlmap="%sysget(FACTSET)fsdex05.map"
   orientation=eti
   user='XXXXXXXXXXXXXXXX'
   pass='XXXXXXXXXXXXXXXX';

data snapshot; set xfsd.fsdex05; run;
proc print data=snapshot; run;