IMXFER Procedure

Example 1: Copying Tables from One Server to Another

Details

It might be necessary to copy tables from one SAS LASR Analytic Server instance to another.

Program

proc imxfer;
    server s1 host="grid001.example.com" port=10031; 1
    server s2 host="grid001.example.com" port=10010;

    table s1 public.fact_table s2; 2
quit;

Program Description

  1. The first SERVER statement creates a reference to the server that is listening on port 10031. The second SERVER statement creates a reference to a server on the same host, but listening on port 10010.
  2. The TABLE statement transfers the Hps.Fact_Table table from the server that is listening on port 10031 to the server that is listening on port 10010. Because no import-table-name is specified, the table uses the name Hps.Fact_Table on the importing server.