The SASEFAME Interface Engine
- Overview
-
Getting Started
-
Syntax
-
Details
-
ExamplesConverting an Entire Fame DatabaseReading Time Series from the Fame DatabaseWriting Time Series to the SAS Data SetLimiting the Time Range of DataCreating a View Using the SQL Procedure and the SASEFAME EngineReading Other Fame Data Objects with the FAMEOUT= OptionRemote Fame Access by Using Fame CHLISelecting Time Series by Using the CROSSLIST= Option and KEEP StatementSelecting Time Series by Using the CROSSLIST= Option and Fame NamelistSelecting Time Series by Using the CROSSLIST= Option and WHERE=TICKSelecting Boolean Case Series with the FAMEOUT= OptionSelecting Numeric Case Series with the FAMEOUT= OptionSelecting Date Case Series with the FAMEOUT= OptionSelecting String Case Series with the FAMEOUT= OptionExtracting Source for FormulasReading Time Series by Defining Fame Expression Groups in the INSET= Option with the KEEP= ClauseOptimizing Cache Sizes with the TUNEFAME= and TUNECHLI= Options
- References
Example 47.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 47.7.1 shows the results.
Output 47.7.1: Summary Statistics for the Remote FAME Data