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;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.