Output Data Set

Many SAS procedures add the variables from the input data set when an observationwise output data set is created. The assumption of high-performance analytical procedures is that the input data sets can be large and contain many variables. For performance reasons, the output data set contains the following:

  • variables that are explicitly created by the statement

  • variables that are listed in the ID statement or specified by using the COPYVAR= option

  • distribution keys or hash keys that are transferred from the input data set

The high-performance analytical procedures enable you to add output data set information that is necessary for subsequent SQL joins without copying the entire input data set to the output data set. For further details about output data sets when PROC HPQUANTSELECT is run in distributed mode, see the section Output Data Sets in SAS/STAT 14.1 User's Guide: High-Performance Procedures.