Example 5.1: Converting an entire FAME database

The SASEFAME Interface Engine

Example 5.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 are stored in the FAME WORK database during the SAS DATA step. You may further limit your resulting SAS data set by using KEEP, DROP, or WHERE statements inside your data step.


libname famedir sasefame '.' 
                convert=(freq=annual technique=constant);

libname mydir '/mine/data/europe/sas/oecdir';
 
data mydir.a;  /* add data set to mydir */
   set famedir.oecd1; 
   /* do nothing special */
   run;

proc print data=mydir.a; run;

In the above 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' which will reside in mydir. All time series in the FAME oecd1.db data base will be converted to an annual frequency and stored in the mydir.a SAS data set. The PROC PRINT statement creates a listing of all of the observations in the mydir.a SAS data set.

Chapter Contents
Previous
Next
Top