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
The MEANS Procedure
|
PERSONAL INCOME |
CORPORATE PROFITS AFTER TAX EXCLUDING IVA |
CORPORATE PROFITS BEFORE TAX EXCLUDING IVA |
|
|