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 44.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 |