Extracting values after "

[Aexor]

Dear member,

Could you please help me in below query:

input

Data  one;

input all $50. ;

datalines; 

ram is "amazing"

shyan needs "/books/lamps"

we are "/travellling/"

;

run;

 I need output dataset New having values like this  in a new variable two.

two

amazing

/books/lamps

  /travellling/

[novinosrin]

Data  one;

input all $50. ;

datalines; 
ram is "amazing"
shyan needs "/books/lamps"
we are "/travellling/"
;

run;

data two;
  set one;
  length want $50;
  _k=findc(all,'"','b');
  _k1=findc(all,'"')+1;
  want=substr(all,_k1, _k-_k1);
  drop _k:;
run;

proc print noobs;run;

all	want
ram is "amazing"	amazing
shyan needs "/books/lamps"	/books/lamps
we are "/travellling/"	/travellling/

[novinosrin · Accepted solution]

Hmm No wonder not participating here enough makes me lose touch consequential in not thinking of the following in the 1st place. Jeez!--

Data  one;

input all $50. ;

datalines; 
ram is "amazing"
shyan needs "/books/lamps"
we are "/travellling/"
;

run;


data two;
  set one;
  length want $50;
  want=scan(all,-2,'"');
run;

proc print noobs;run;

all	want
ram is "amazing"	amazing
shyan needs "/books/lamps"	/books/lamps
we are "/travellling/"	/travellling/

[ballardw]

---

@novinosrin wrote:

Hmm No wonder not participating here enough makes me lose touch consequential in not thinking of the following in the 1st place. Jeez!--

Data  one;

input all $50. ;

datalines; 
ram is "amazing"
shyan needs "/books/lamps"
we are "/travellling/"
;

run;


data two;
  set one;
  length want $50;
  want=scan(all,-2,'"');
run;

proc print noobs;run;

all	want
ram is "amazing"	amazing
shyan needs "/books/lamps"	/books/lamps
we are "/travellling/"	/travellling/

---

Maybe we need a self-assigned badge of the "Forehead pop" for such.

[ChrisNZ]

Like this?

WANT=scan(ALL, 2, '"');