Hi,
I have following columns in my sas data set lets say.
some_column1
some_column2
RES_1111
RES_1112
RES_1113
mape_RES_1111
mape_RES_1112
mape_RES_1113
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?
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.
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.
Simple example
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;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.