06-08-2017 04:33 AM
I have following columns in my sas data set lets say.
if i have to remove all the columns in bold starting with a particular prefix 'RES_'
then how do I delete or remove all the columns starting from 'RES_'
any regular expression, LIKE % operator kind of thing in SAS?
06-08-2017 04:46 AM
Simple, SAS has options for this:
data want; set have (drop=res_:); run;
Note the colon after the prefix, means all with that prefix. If you had a range of variables, you could do:
data want; set have (drop=res_1111--res_1113); run;
This would remove any variable which has a logical position and including res_1111 and res_1113 in the dataset.
06-08-2017 04:48 AM
data have; infile datalines; input some_column1 RES_1111 RES_1112 mape_RES_1111; datalines; 1 2 3 4 ; data want; set have; drop res_:; run;