Loading and Unloading Tables for Non-Distributed Servers

Tables are loaded into memory in a non-distributed server with the SAS LASR Analytic Server engine. A DATA step can be used. The following example demonstrates loading the Prdsale table into memory after starting a server on port 10010.
To load a table to memory:
Loading a Table to Memory for Non-Distributed Servers
libname server1 sasiola start port=10010 tag='hps';

data server1.prdsale;
    set sashelp.prdsale;
run;
Note: The SASIOLA engine can always be used to connect to a server on the local host, as shown in this example. However, for connections to remote hosts, the engine supports connections to Linux hosts only. For more information, see Understanding How the SAS LASR Analytic Server Engine Works.
You can unload a table from memory with the DATASETS procedure:
Unloading a Table with the DATASETS Procedure
proc datasets lib=server1;
    delete prdsale;
quit;