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

data test;

string='abc_234_knm_dfjkdhf_dfdkf';

run;

 

i want ouput like

 

output_col = knm_dfjkdhf_dfdkf

 

can some one help on this 

1 ACCEPTED SOLUTION

Accepted Solutions
Astounding
PROC Star

I would use:

 

output_col = substr(string, length(scan(string, 1, '_')) + length(scan(string, 2, '_')) + 3);

 

I'm sure those familiar with parsing functions could find something elegant.

View solution in original post

5 REPLIES 5
novinosrin
Tourmaline | Level 20

output_col =scan(string,-1,'_');

mmkr
Obsidian | Level 7

it wil come only "dfdkf"

Astounding
PROC Star

I would use:

 

output_col = substr(string, length(scan(string, 1, '_')) + length(scan(string, 2, '_')) + 3);

 

I'm sure those familiar with parsing functions could find something elegant.

mmkr
Obsidian | Level 7

THANK YOU SO MUCH !!

Ksharp
Super User
data test;

string='abc_234_knm_dfjkdhf_dfdkf';
x=substr(string,findc(string,'1234567890','b')+1);
put x=;
run;

sas-innovate-2024.png

Today is the last day to save with the early bird rate! Register today for just $695 - $100 off the standard rate.

 

Plus, 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
  • 5 replies
  • 1159 views
  • 0 likes
  • 4 in conversation