topic Remove First 3 Words in SAS Enterprise Guide

Remove First 3 Words

SanchitArora — Fri, 02 Oct 2015 08:33:25 GMT

HI,

Below is the input:

BOM_ZEB_MIC_1002214_API_1002214_K304330

BOM_EVR_MIC_11000000002328_API_11000000002328_243

And out put required is:

1002214_API_1002214_K304330

11000000002328_API_11000000002328_243

I want to remove the first 3 Words as you can see in output.What function to be used for this ?

Kindly help

Sanchit Arora

Re: Remove First 3 Words

RW9 — Fri, 02 Oct 2015 08:50:37 GMT

Use the substr() function with the findc() function and the "d" paramer:

data have;
  length text new_text $2000;
  text="BOM_ZEB_MIC_1002214_API_1002214_K304330"; 
  new_text=substr(text,findc(text,"1","d"));
  output;
  text="BOM_EVR_MIC_11000000002328_API_11000000002328_243"; 
  new_text=substr(text,findc(text,"1","d"));
  output;
run;

Re: Remove First 3 Words

SanchitArora — Fri, 02 Oct 2015 08:53:21 GMT

Thank you so much for the solution. It its working

Re: Remove First 3 Words

RW9 — Fri, 02 Oct 2015 09:10:48 GMT

Do bear in mind that it looks for the first occurence of a number in the string, and then substrings from there. If your data like the given examples you will be fine, just remember the above.

Re: Remove First 3 Words

SanchitArora — Fri, 02 Oct 2015 09:12:36 GMT

HI,

I found new problem . Sorry i have to mention earlier .

I have a Input like:

BOM_WAR_MIC_R740193 Output coming as :740193

BOM_EVR_MIC_CD5T: Output coming as :5T

I need output as:

R740193

CD5T:

Re: Remove First 3 Words

RW9 — Fri, 02 Oct 2015 09:58:29 GMT

Yes, thats why I mentioned it. Basically the idea is to find a logical pattern in the data (as I don't have the data I can't tell you), then find that data and substring from that point. Now say that your data is always separated by MIC, then you would do:

substr(text,find(text,"MIC")+4);

This will find the text MIC, then from the start position of MIC + four (so we don't get MIC_ in the output) substring out to the end of the string. Maybe if its always from the third underscore you could do:

new_string=strip(tranwrd(string,cats(scan(string,1,"_"),"_",scan(string,2,"_"),"_",scan(string,3,"_"),"_"),""));

What the above does is scan out the first three parts as delimited by the underscore and screate a string with the underscores, that text then being removed from the string by use of tranwrd.

Its really up to how your data looks and what the logical delimiter is.

Re: Remove First 3 Words

Haikuo — Fri, 02 Oct 2015 14:38:34 GMT

An alternative would be using Perl Regular Expression:

The following code will replace the first 3 words by nothing, meaning: removing them.

new_text=prxchange('s/^([^_]+_){3}//o', -1, text);