The SASEFAME Interface Engine

The following statements create a view of OECD data by using the SQL procedure’s FROM and USING clauses. For more information about SQL views, see the BASE SAS Procedures Guide.

 title1 'famesql5: PROC SQL Dual Embedded Libraries w/ FAME option';
 options validvarname=any;

 %let FAME=%sysget(FAME);
 %put(&FAME);
 %let FAMETEMP=%sysget(FAME_TEMP);
 %put(&FAMETEMP);

 title2 'OECD1: Dual Embedded Library Allocations with FAME Option';
 proc sql;
    create view fameview as
       select date, 'fin.herd'n
          from lib1.oecd1
       using libname lib1 sasefame "%sysget(FAME_DATA)"
                convert=(tech=constant freq=annual),
             libname temp "%sysget(FAME_TEMP)";
 quit;

 title2 'OECD1: Print of View from Embedded Library with FAME Option';
 proc print data=fameview;
 run;

Output 41.5.1 shows the results.

The following statements create a view of the DRI Basic Economic data by using the SQL procedure’s FROM and USING clauses:

title2 'SUBECON: Dual Embedded Library Allocations with FAME Option';
options validvarname=any;

%let FAME=%sysget(FAME);
%put(&FAME);
%let FAMETEMP=%sysget(FAME_TEMP);
%put(&FAMETEMP);

proc sql;
   create view fameview as
   select date, gaa
      from lib1.subecon
      using libname lib1 sasefame "%sysget(FAME_DATA)"
                         convert=(tech=constant freq=annual),
            libname temp "%sysget(FAME_TEMP)";
quit;

title2 'SUBECON: Print of View from Embedded Library with FAME Option';
proc print data=fameview;
run;

Output 41.5.2 shows the results.

The following statements create a view of the DB77 database by using the SQL procedure’s FROM and USING clauses:

title2 'DB77: Dual Embedded Library Allocations with FAME Option';
options validvarname=any;

%let FAME=%sysget(FAME);
%put(&FAME);
%let FAMETEMP=%sysget(FAME_TEMP);
%put(&FAMETEMP);

proc sql;
   create view fameview as
      select date, ann, 'qandom.x'n
      from lib1.db77
      using libname lib1 sasefame "%sysget(FAME_DATA)"
                    convert=(tech=constant freq=annual),
            libname temp "%sysget(FAME_TEMP)";
 quit;

title2 'DB77: Print of View from Embedded Library with FAME Option';
proc print data=fameview;
run;

Output 41.5.3 shows the results.

The following statements create a view of the Data Resources Incorporated (DRI) Basic Economic data by using the SQL procedure’s FROM and USING clauses:

title2 'DRIECON: Dual Embedded Library Allocations with FAME Option';
options validvarname=any;

%let FAME=%sysget(FAME);
%put(&FAME);
%let FAMETEMP=%sysget(FAME_TEMP);
%put(&FAMETEMP);

proc sql;
   create view fameview as
      select date, husts
      from lib1.driecon
      using libname lib1 sasefame "%sysget(FAME_DATA)"
                         convert=(tech=constant freq=annual)
                         range='01jan1980'd - '01jan2006'd ,
            libname temp "%sysget(FAME_TEMP)";
quit;

title2 'DRIECON: Print of View from Embedded Library with FAME Option';
proc print data=fameview;
run;

The SAS option VALIDVARNAME=ANY is used at the beginning of this example because special characters are present in the time series names. The output from this example shows how each Fame view is the output of the SASEFAME engine’s processing. Different engine options could have been used in the USING LIBNAME clause if desired. Output 41.5.4 shows the results.