BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
captainprice0
Fluorite | Level 6

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?

1 ACCEPTED SOLUTION

Accepted Solutions
RW9
Diamond | Level 26 RW9
Diamond | Level 26

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.

View solution in original post

2 REPLIES 2
RW9
Diamond | Level 26 RW9
Diamond | Level 26

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.

PeterClemmensen
Tourmaline | Level 20

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;

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 2 replies
  • 38247 views
  • 1 like
  • 3 in conversation