KEEP= Data Set Option

Syntax Description

variable-1 <...variable-n>

lists one or more variable names. You can list the variables in any form that SAS allows.

If the KEEP= data set option is associated with an input data set, only those variables that are listed after the KEEP= data set option are available for processing. If the KEEP= data set option is associated with an output data set, only the variables listed after the option are written to the output data set, but all variables are available for processing.

• The KEEP= data set option differs from the KEEP statement in the following ways:

  • In DATA steps, the KEEP= data set option can apply to both input and output data sets. The KEEP statement applies only to output data sets.

  • In DATA steps, when you create multiple output data sets, use the KEEP= data set option to write different variables to different data sets. The KEEP statement applies to all output data sets.

  • In PROC steps, you can use only the KEEP= data set option, not the KEEP statement.

• The DROP= data set option specifies variables to omit during processing or to omit from the output data set.

In this example, only IDNUM and SALARY are read from PAYROLL, and they are the only variables in PAYROLL that are available for processing:

data bonus;
   set payroll(keep=idnum salary);
   bonus=salary*1.1;
run;

Copyright © 2007 by SAS Institute Inc., Cary, NC, USA. All rights reserved.