Example 36.1 Converting an Entire Fame Database

To enable conversion of all time series no wildcard is specified, so the default "?" wildcard is used. Always consider both the number of time series and the number of observations generated by the conversion process. The converted series reside in the Fame Work database during the SAS DATA step. You can further limit your resulting SAS data set by using KEEP, DROP, or WHERE statements inside your DATA step.

The following statements convert a Fame database and print out its contents:

options pagesize=60 linesize=80 validvarname=any ;
%let FAME=%sysget(FAME);
%put(&FAME);
%let FAMETEMP=%sysget(FAME_TEMP);
%put(&FAMETEMP);

libname famedir sasefame "%sysget(FAME_DATA)"
        convert=(freq=annual technique=constant);
 
libname mydir "%sysget(FAME_TEMP)";

data mydir.a;  /* add data set to mydir */
   set famedir.oecd1;
   /* Read in oecd1.db data from the Organization */
   /*  For Economic Cooperation and Development    */
   where date between '01jan88'd and '31dec93'd;
run;

proc print data=mydir.a;
run;

In the preceding example, the Fame database is called oecd1.db and it resides in the famedir directory. The DATA statement names the SAS output data set 'a', that will reside in mydir. All time series in the Fame oecd1.db database will be converted to an annual frequency and reside in the mydir.a SAS data set. Since the time series variable names contain the special glue symbol '.', the SAS option statement specifies VALIDVARNAME=ANY. See the SAS Language Reference: Dictionary for more information about this option. The Fame environment variable is the location of the Fame installation. On Windows, the log would look like this:

1             options validvarname=any;

2             %let FAME=%sysget(FAME);
3             %put(&FAME);
(C:\PROGRA~1\FAME)
4             %let FAMETEMP=%sysget(FAME_TEMP);
5             %put(&FAMETEMP);
(\\ge\U11\saskff\fametemp\)
6
7             libname famedir sasefame "&FAME\util"
8                     convert=(freq=annual technique=constant);
NOTE: Libref FAMEDIR was successfully assigned as follows:
      Engine:        FAMECHLI
      Physical Name: C:\PROGRA~1\FAME\util
9
10            libname mydir '\\dntsrc\usrtmp\saskff';
NOTE: Libref MYDIR was successfully assigned as follows:
      Engine:        V9
      Physical Name: \\dntsrc\usrtmp\saskff
11
12            data mydir.a;  /* add data set to mydir */
13               set famedir.oecd1;
AUS.DIRDES -- SERIES (NUMERIC by ANNUAL)
AUS.DIRDES copied to work data base as AUS.DIRDES.

For more about the glue DOT character, refer to "Gluing Names Together" in the User’s Guide to Fame. In the preceding log, the variable name AUS.DIRDES uses the glue DOT between AUS and DIRDES.

The PROC PRINT statement creates Output 36.1.1 which shows all of the observations in the mydir.a SAS data set.