Skip to Main Content
Hands-On SAS for Data Analysis
book

Hands-On SAS for Data Analysis

by Harish Gulati
September 2019
Beginner to intermediate content levelBeginner to intermediate
346 pages
7h 35m
English
Packt Publishing
Content preview from Hands-On SAS for Data Analysis

Altering

Using the ALTER statement, we can drop (delete) columns, modify columns, and add columns. The general form of this statement is as follows:

ALTER TABLE table-name       <DROP column-name-1<, ... column-name-n>>       <MODIFY column-definition-1<, ... column-definition-n>>;      <ADD column-definition-1<, ... column-definition-n>> 

Here, table-name specifies the name of the table in which columns will be added, dropped, or modified.

At least one of the following clauses must be specified:

  • DROP specifies one or more column-names for columns to be dropped.
  • MODIFY specifies one or more column-definitions for columns to be modified, where column-definition specifies a column to be added or modified, and is formatted as follows: column-name data-type ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Big Data Analytics with SAS

Big Data Analytics with SAS

David Pope, Subhashini S Tripathi
An Introduction to SAS Visual Analytics

An Introduction to SAS Visual Analytics

Tricia Aanderud, Rob Collum, Ryan Kumpfmiller

Publisher Resources

ISBN: 9781788839822Supplemental Content