Previous Page | Next Page

The DATASOURCE Procedure

Example 11.5 DRI Data Delivery Service Database

This example demonstrates the DRIDDS filetype for the daily Federal Reserve Series fxrates_dds. Use VALIDVARNAME=ANY in your SAS options statement to allow special characters such as @, $, and % to be in the series name. Note the use of long variable names in the OUT= data set in Output 11.5.2 and long labels in the OUTCONT= data set in Output 11.5.1.

The following statements extract daily series starting in January 1,1997:

   options validvarname=any;
   filename datafile "drifxrat.dat" RECFM=F LRECL=80;
   proc format;
      value distekfm 0 = 'Unspecified'
                     2 = 'Linear'
                     4 = 'Triag'
                     6 = 'Polynomial'
                     8 = 'Even'
                    10 = 'Step'
                    12 = 'Stocklast'
                    14 = 'LinearUnadjusted'
                    16 = 'PolyUnadjusted'
                    18 = 'StockWithNAS'
                    99 = 'None'
                   255 = 'None';
   
      value convtkfm 0 = 'Unspecified'
                     1 = 'Average'
                     3 = 'AverageX'
                     5 = 'Sum'
                     7 = 'SumAnn'
                     9 = 'StockEnd'
                    11 = 'StockBegin'
                    13 = 'AvgNP'
                    15 = 'MaxNP'
                    17 = 'MinNP'
                    19 = 'StockEndNP'
                    21 = 'StockBeginNP'
                    23 = 'Max'
                    25 = 'Min'
                    27 = 'AvgXNP'
                    29 = 'SumNP'
                    31 = 'SumAnnNP'
                    99 = 'None'
                   255 = 'None';
   
    /*--------------------------------------------------------*
     *                 process daily series                   *
     *--------------------------------------------------------*/
   title3 'Reading DAILY Federal Reserve Series with fxrates_.dds';
   proc datasource filetype=dridds
                   infile=datafile
                   interval=day
                   out=fixr
                   outcont=fixrcnt
                   outall=fixrall;
      keep rx: ;
      range from '01jan97'd to '31dec99'd;
      format disttek distekfm.;
      format convtek convtkfm.;
   run;
   
   title1 'CONTENTS of FXRATES_.DDS File, KEEP RX:';
   proc print
      data=fixrcnt;
   run;
   
   title1 'Daily Series Available in FXRATES_.DDS File, KEEP RX:';
   proc print
      data=fixr;
   run;
   

Output 11.5.1 Listing of the OUTCONT=FIXRCNT Data Set for FILETYPE=DRIDDS
Daily Series Available in FXRATES_.DDS File, KEEP RX:

Obs NAME KEPT SELECTED TYPE LENGTH VARNUM LABEL FORMAT FORMATL FORMATD SOURCEID DISTTEK CONVTEK STATUS UPDATE UPTIME
1 RXA$%US$@AU 1 1 1 5 2 EXCHANGE RATE IN AUSTRALIAN DOLLAR PER US DOLLAR - AUSTRALIA   0 0 @FACS/DATA.D Unspecified Unspecified 0 31JAN97 132605
2 RXBF%US$@BE 1 1 1 5 3 EXCHANGE RATE IN BELGIAN FRANCS PER US DOLLAR - BELGIUM   0 0 @FACS/DATA.D Unspecified Unspecified 0 31JAN97 132544
3 RXDK%US$@DK 1 1 1 5 4 EXCHANGE RATE IN DANISH KRONE PER 100 US DOLLAR - DENMARK   0 0 @FACS/DATA.D Unspecified Unspecified 0 31JAN97 132544

Output 11.5.2 Printout of the OUT=FIXR Data Set for FILETYPE=DRIDDS
Daily Series Available in FXRATES_.DDS File, KEEP RX:

Obs DATE RXA$%US$@AU RXBF%US$@BE RXDK%US$@DK
1 01JAN1997 1.26133 31.9200 5.92877
2 02JAN1997 1.26133 31.9200 5.92877
3 03JAN1997 1.26133 31.9200 5.92877
4 04JAN1997 1.27708 32.4620 6.01098
5 05JAN1997 1.27708 32.4620 6.01098
6 06JAN1997 1.27708 32.4620 6.01098
7 07JAN1997 1.27708 32.4620 6.01098
8 08JAN1997 1.27708 32.4620 6.01098
9 09JAN1997 1.27708 32.4620 6.01098
10 10JAN1997 1.27708 32.4620 6.01098
11 11JAN1997 1.28443 32.9360 6.09112
12 12JAN1997 1.28443 32.9360 6.09112
13 13JAN1997 1.28443 32.9360 6.09112
14 14JAN1997 1.28443 32.9360 6.09112
15 15JAN1997 1.28443 32.9360 6.09112
16 16JAN1997 1.28443 32.9360 6.09112
17 17JAN1997 1.28443 32.9360 6.09112
18 18JAN1997 1.29195 33.7500 6.24658
19 19JAN1997 1.29195 33.7500 6.24658
20 20JAN1997 1.29195 33.7500 6.24658
21 21JAN1997 1.29195 33.7500 6.24658
22 22JAN1997 1.29195 33.7500 6.24658
23 23JAN1997 1.29195 33.7500 6.24658
24 24JAN1997 1.29195 33.7500 6.24658
25 25JAN1997 1.30133 33.8974 6.27520
26 26JAN1997 1.30133 33.8974 6.27520
27 27JAN1997 1.30133 33.8974 6.27520
28 28JAN1997 1.30133 33.8974 6.27520
29 29JAN1997 1.30133 33.8974 6.27520
30 30JAN1997 1.30133 33.8974 6.27520
31 31JAN1997 1.30133 33.8974 6.27520

Previous Page | Next Page | Top of Page