APPEND= Data Set Option

specifies to append the data to an existing table in the server instance.

Interaction:

You must use the NOCLASS option if you load the initial table with the LASR procedure.

Syntax

APPEND=YES | NO

Details

By default, the SAS LASR Analytic Server engine does not permit appending observations to tables. The APPEND= data set option can be used to permit adding observations to an existing table.

Using the APPEND= Data Set Option

proc lasr add data=grp1.sales noclass port=10010;
run;

libname grp1lasr host="grid001.example.com" port=10010 tag=grp1;

data grp1lasr.sales (append=yes);
    set yr2012.sales (keep=date location amount);
run;

As shown in the preceding example, the APPEND= data set option can be used to add observations to an existing table. The KEEP= option on the input data set specifies the variables from the input data to append. Any variables for which the input data set does not append data are set to missing. You cannot add new variables to the table.

The example also shows how to load the initial table to memory with the LASR procedure. The NOCLASS option must be specified if you use the LASR procedure. As an alternative, you can load the initial table to memory with the SAS LASR Analytic Server engine.