When SAS Data Integration
Studio generates code for a job, a library is considered local or
remote in relation to the SAS Application Server that executes the
job. If the library is stored on one of the machines that is specified
in the metadata for the SAS Application Server that executes the job,
it is local. Otherwise, it is remote.
SAS Data
Integration Studio generates the appropriate LIBNAME statements for
local and remote libraries.
Here is
the syntax that is generated for a local library:
libname libref <enginer> <"lib-specification"> <connectionOptions> <libraryOptions>
<schema=databaseSchema>
<user=userID>
<password=password>;
Here is
the syntax that is generated for a remote library:
options
comamid=connection_type;
%let remote_session_id=host_name <host_port>;
signon
remote_session_id<user=userID>
<password=password>;
rsubmit remote_session_id;
libname <library details>;
endrsubmit;
rsubmit remote_session_id;
proc download
data=table_on_remote_machine
out=table_on_local_machine;
run;
endrsubmit;