Connect to the DataFlux Federation Server and Reference a DSN Definition :: SAS(R) 9.3 LIBNAME Engine for DataFlux(R) Federation Server: User's Guide

Details

This example accesses a SAS data set by specifying server connection arguments to connect to the DataFlux Federation Server and by referencing a DataFlux DSN with the DSN= data source connection argument. The DataFlux DSN provides the information to access the data source.

Program

libname mylib fedsvr 1
   server="d1234.us.company.com" port=2171 user="myid" pwd=mypwd 2
   dsn=BaseDSN; 3

proc print data=mylib.MyTable; 4
run;

Program Description

The LIBNAME statement assigns the libref MYLIB and specifies the FEDSVR engine.
The LIBNAME statement server connection arguments specify how to connect to the DataFlux Federation Server. The arguments identify the computer on which the server is running, the port number that is used to access the server, and user authentication information.
The DSN= connection argument references a DataFlux DSN, which is defined on the DataFlux Federation Server and provides the information to access the data source. The BaseDSN encapsulates the SAS data set connection information, such as the BASE table driver name and the physical location of the data.
The PRINT procedure specifies the name of the SAS data set that is accessed by the DataFlux DSN and prints the SAS data set.