Knowledge and Data Management White Papers

Using Data Set Options in PROC SQL

Overview Data set options are an oft over-looked feature when querying and manipulating SAS data sets with PROC SQL. This paper explores using the data set options DROP, KEEP, LABEL, COMPRESS, SORTEDBY, WHERE, and RENAME in the CREATE TABLE statement and FROM clause of PROC SQL. These options can help facilitate more succinct and efficient code and create parsimonious and well-labeled data sets.

Further White Paper Details
PublisherSAS Institute File FormatPDF
Date PublishedFebruary 2006 Downloads14
FormatWhite Papers   
Topics
  • Featured White Papers
Thin clients switch on digitally excluded

Thin clients switch on digitally excluded

Case study: Digital inclusion project tackles social exclusion in Liverpool more

Renault goes multilingual

Renault goes multilingual

Case study: Translation tech turns docs into 23 languages… more


Quick Sitemap Links: