Oct 16, 2019

SAS programming tip - DROP statement to drop columns while reading/creating table or dataset

If you like to drop columns from big table while reading or creating table/dataset. You can use DROP statement to drop selected columns. It helps programmer to output few columns.
Example:
 Data cars; * This step create sas dataset cars in work library;
     Set sashelp.cars; * This reads SAS dataset cars from sashelp library;
       Drop make model; * This will drop two columns from output table cars.;
 Run;

No comments:

Post a Comment