Writing Observations to Multiple SAS Data Sets
The SAS system allows you to create multiple SAS data sets in a
single data step. The basic tool is the “output” statement.
The basic syntax is OUTPUT <sas-data-set-name>;
If you use an “output” statement without specifying a data
set name, SAS will output that observation to data sets
named in the current Data statement.
If you want to write to a specific data set, then it must be
named in the “output” statement.
Any data set named in an “output” statement MUST be
listed in the Data statement.
Suppose you want to output two data sets; one with guide =
‘Lucas’ and one with guide = ‘other’.
(See program SAS_Output1_arts.sas)
Note that when you create more than one data set in a Data
Statement, the last one listed will be the most recently used data
set and hence will be the current work.dataset (in this case,
othrtour) . To use another data set in a procedure, you must use
the “DATA=sas.data.set.name” option.
Using an output statement suppresses the automatic output of
observations at the end of a DATA step. Therefore, if you plan
to use an output statement in a DATA step, then you must
program ALL output for that step with output statements.
(See program SAS_Output2_arts.sas)
