IMSTAT Procedure (Data and Server Management)

DROPCOLUMN Statement

The DROPCOLUMN statement removes a column that was created with the COMPUTE statement from an in-memory table.

Syntax
Required Argument
Example

Syntax

DROPCOLUMN column-name;

Required Argument

column-name

specifies the name of the computed column to remove. The column must have been created with the COMPUTE statement.

Example 

libname example sasiola host="grid001.example.com" port=10010 tag='hps';

data example.cars;
   set sashelp.cars;
run;

proc imstat nopreparse;
   table example.cars;
   compute ratio "ratio = mpg_city / mpg_highway";  1
   /* columninfo; */
run;

   dropcolumn ratio;  2
   /* columninfo; */
quit;
1 The COMPUTE statement adds the permanent computed column Ratio to the active table.
2 The DROPCOLUMN statement removes the permanent computed column that is named Ratio from the table.
Copyright © SAS Institute Inc. All Rights Reserved.