Variables written to output dataset in DATA STEP

[rinugour]

How can you limit the variables written to output dataset in DATA STEP?

[Oligolas]

Hi,

you can use the DROP or KEEP statements

[Amir]

Hi,

As well as the keep and drop statements answer already given by @Oligolas there are also keep= and drop= data set options.

For syntax details and an example, see the documentation:

http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a000131144.htm

Regards,

Amir.

[anjita]

Both DROP and KEEP can be used to limit the variables in the dataset.

• The DROP=option tells SAS which variables you want to  If you place the DROP= option on the SET statement, SAS drops the specified variables when it reads the input data set and if you place the DROP= option on the DATA statement, SAS drops the specified variables when it writes to the output data set.
• The KEEP=option tells SAS which variables you want to  If you place the KEEP= option on the SET statement, SAS keeps the listed variables when it reads the input data set. On the other hand, if you place the KEEP= option on the DATA statement, SAS keeps the specified variables when it writes to the output data set.