SASEFRED Interface Engine

Example 48.6 Specifying One Series ID with Multiple Vintage Dates for the OUTPUT=2 Option

(View the complete code for this example.)

This example demonstrates how to request the CBI time series, which show the change in private industries for three different vintage dates: 1947-08-17, 1966-08-11, and 1994-08-26. Using the early range of START='1942-01-01'and END='1947-04-01', you can get an idea of how the changes show up for each vintage date. If you specify OUTPUT=2, each time series is named by concatenating the series ID to the vintage date with an underscore.


options validvarname=any;

title 'Specifying One Series ID with Multiple Vintage Dates for OUTPUT=2 Option';
libname _all_ clear;
libname fred sasefred "%sysget(FRED)"
   OUTXML=fredex05
   AUTOMAP=replace
   MAPREF=MyMap
   XMLMAP="%sysget(FRED)fredex05.map"
   APIKEY='XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX'
   IDLIST='CBI'
   VINTAGE='1947-08-17,1966-08-11,1994-08-26'
   START='1942-01-01'
   END='1947-04-01'
   FREQ='q'
   OUTPUT=2
   UNITS='lin'
   FORMAT=xml;

data threeVinsCBI;
   set fred.fredex05;
run;
proc contents data=threeVinsCBI; run;
proc print data=threeVinsCBI; run;

Output 48.6.1: Specifying One Series ID with Multiple Vintage Dates for OUTPUT=2 Option

Specifying One Series ID with Multiple Vintage Dates for OUTPUT=2 Option

ObsdateCBI_19470817CBI_19660811CBI_19940826
11942-01-013.9..
21942-04-013.6..
31942-07-01-0.9..
41942-10-01-0.9..
51943-01-01-2.4..
61943-04-01-2.1..
71943-07-011.1..
81943-10-01-1.5..
91944-01-01-2.4..
101944-04-01-3.2..
111944-07-01-1.0..
121944-10-01-1.3..
131945-01-01-2.8..
141945-04-01-1.5..
151945-07-010.1..
161945-10-01-0.8..
171946-01-012.35.95.7
181946-04-012.08.88.6
191946-07-014.96.15.9
201946-10-015.44.74.5
211947-01-012.70.40.4
221947-04-011.5-1.0-1.2


Last updated: June 19, 2025