The SASEFAME Interface Engine

Example 41.7 Remote Fame Access by Using Fame CHLI

When you run Fame in a client/server environment and also have Fame CHLI capability to enable access to the server, you can access Fame remote data. Access the remote data by specifying the port number of the TCP/IP service that is defined for the frdb_m and the node name of the Fame master server in the physical path. In this example, the Fame server node name is STONES, and the port number is 5555, as was designated in the Fame master command. For more information about starting your Fame master server, see the section Starting the Master Server in the Guide to Fame Database Servers.

options ls=78;
title1 "DRIECON Database, Using FAME with Remote Access Via CHLI";
options validvarname=any;
libname test1 sasefame '#5555@stones $FAME/util';

data a;
   set test1.driecon;
   keep YP ZA ZB;
   where date between '01jan98'd and '31dec03'd;
run;

proc means data=a n;
run;

Output 41.7.1 shows the results.

Output 41.7.1: Summary Statistics for the Remote FAME Data

DRIECON Database, Using FAME with Remote Access Via CHLI

The MEANS Procedure

Variable Label N
YP
ZA
ZB
PERSONAL INCOME
CORPORATE PROFITS AFTER TAX EXCLUDING IVA
CORPORATE PROFITS BEFORE TAX EXCLUDING IVA
5
4
4