topic Re: cleaning character string in SAS Data Management

cleaning character string

psh23 — Wed, 06 Jun 2018 00:25:00 GMT

Hello,

I am trying to clean character strings - I would like to pull out and keep only the characters between the first set of quotes.

Here is an example:

{"I34.0":1,"I48.0

I would like the result to be

I34.0

Thank you!

Re: cleaning character string

SuryaKiran — Wed, 06 Jun 2018 00:22:48 GMT

Do you mean quotes. I don't see parentheses() in your string.

data test;
string='{"I34.0":1,"I48.0';
sub=scan(string,2,'"');
run;

Use scan function taking " as delimiter.

Re: cleaning character string

psh23 — Wed, 06 Jun 2018 00:26:44 GMT

yes thank you!!

Re: cleaning character string

TomKari — Wed, 06 Jun 2018 00:30:49 GMT

Assuming you mean double quotes, not parentheses,

data have;
	CharString = '{"I34.0":1,"I48.0';
	output;
run;

data want;
	retain _RX1;

	if _n_ = 1 then
		_RX1 = prxparse('|"([^"]+)"|');
	set have;

	if prxmatch(_RX1, CharString) then
		WantedString = prxposn(_RX1, 1, CharString);
run;

Tom