topic Re: Extracting values after " in SAS Programming

Extracting values after "

Aexor — Sun, 03 Oct 2021 19:05:29 GMT

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/

Re: Extracting values after "

novinosrin — Sun, 03 Oct 2021 19:43:15 GMT


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/

Re: Extracting values after "

novinosrin — Sun, 03 Oct 2021 19:48:17 GMT

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/

Re: Extracting values after "

ChrisNZ — Sun, 03 Oct 2021 22:33:04 GMT

Like this?

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

Re: Extracting values after "

ballardw — Mon, 04 Oct 2021 04:25:47 GMT

@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.