The SASEXFSD Interface Engine

This example shows how to use the ExtractBenchmarkDetail factlet to retrieve the holdings for the Standard & Poor’s (S&P) 500 (ID=’sp50’) and display the P_PRICE data that correspond to each holding. For brevity, only a subset of the output (the first 10 holdings) is displayed.

title 'Retrieve Benchmark Data for Top Ten Holdings, CUTOFF=10';
libname _all_ clear;

libname fsd sasexfsd "%sysget(FACTSET)"
   factlet=ExtractBenchmarkDetail
   ids='sp50'
   items='p_price,proper_name'
   dates='20130320'
   cutoff=10
   format=sml
   outXml=fsdex12
   automap=replace
   mapref=MyMap
   xmlmap="%sysget(FACTSET)fsdex12.map"
   orientation=eti
   user='XXXXXXXXXXXXXXXX'
   pass='XXXXXXXXXXXXXXXX';

data bench;
   set fsd.fsdex12;
run;
proc print
   data=bench;
run;

The CUTOFF= option limits the output to the number of holdings that are specified. This example uses CUTOFF=10 to print the top 10 holdings. If you omit the CUTOFF= option, all 500 holdings are reported.