topic Re: Variables written to output dataset in DATA STEP in SAS Programming

Variables written to output dataset in DATA STEP

rinugour — Mon, 04 Feb 2019 12:20:50 GMT

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

Oligolas — Mon, 04 Feb 2019 12:36:55 GMT

Hi,

you can use the DROP or KEEP statements

Amir — Mon, 04 Feb 2019 13:01:28 GMT

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:

Regards,

Amir.

anjita — Tue, 05 Feb 2019 12:02:11 GMT

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.