topic Re: How to split a variable with 2 delimiters in SAS Programming

How to split a variable with 2 delimiters

Gladis6680 — Thu, 27 Jun 2019 17:38:16 GMT

Hi SAS Community,

I have a this table below with 2 delimiters, I tried the SCAN function but it did not work. Can I please get some help on this

HAVE	WANT_1	WANT_2	WANT_3
1/1 EA	1	1	EA
1/1.9 LB	1	1.9	LB
1/1002 EA	1	1002	EA
1/19.97 LB	1	19.97	LB
1/3 KG	1	3	KG
27/235 ML	27	235	ML
41/1.75 OZ	41	1.75	OZ
12/1.05 LT	12	1.05	LT
31/127 GR	31	127	GR

Thank you so much.

Re: How to split a variable with 2 delimiters

Reeza — Thu, 27 Jun 2019 17:39:44 GMT

SCAN can take multiple delimiters, can you post the code you tried.

Re: How to split a variable with 2 delimiters

Tom — Thu, 27 Jun 2019 17:44:09 GMT

want_1=scan(have,1,' /');

Re: How to split a variable with 2 delimiters

PeterClemmensen — Thu, 27 Jun 2019 17:44:28 GMT

The SCAN Function can handle this?

data have;
input HAVE $20.;
datalines;
1/1 EA
1/1.9 LB
1/1002 EA
1/19.97 LB
1/3 KG
27/235 ML
41/1.75 OZ
12/1.05 LT
31/127 GR
;

data want;
   set have;
   want_1=scan(HAVE, 1, '/ ');
   want_2=scan(HAVE, 2, '/ ');
   want_3=scan(HAVE, 3, '/ ');
run;

Re: How to split a variable with 2 delimiters

Gladis6680 — Thu, 27 Jun 2019 17:53:13 GMT

Hi there, this is what I tried

data HAVE

set WANT;

length WANT_1 $10 WANT_2 $10 WANT_3 $10;

WANT_1=scan(HAVE, 1, '/');

WANT_2=scan(HAVE, 2, '/');

WANT_3=scan(HAVE, 3, ' ');

run;

I got

HAVE	WANT_1	WANT_2	WANT_3
1/1 EA	1	1 EA
1/1.9 LB	1	1.9 LB
1/1002 EA	1	1002 EA
1/19.97 LB	1	19.97 LB
1/3 KG	1	3 KG
27/235 ML	27	235 ML
41/1.75 OZ	41	1.75 OZ
12/1.05 LT	12	1.05 LT
31/127 GR	31	127 GR

Re: How to split a variable with 2 delimiters

Gladis6680 — Thu, 27 Jun 2019 17:54:50 GMT

Thank you so much!!! that was easy

Re: How to split a variable with 2 delimiters

Gladis6680 — Thu, 27 Jun 2019 17:55:47 GMT

Thank you so much !!! So all I need to do is add the multiple delimiters in the inverted commas

Re: How to split a variable with 2 delimiters

Tom — Thu, 27 Jun 2019 18:01:12 GMT

@Gladis6680 wrote:

Thank you so much !!! So all I need to do is add the multiple delimiters in the inverted commas

🙂 🙂

What the heck is an 'inverted comma'?

Re: How to split a variable with 2 delimiters

Gladis6680 — Thu, 27 Jun 2019 18:09:14 GMT

sorry I meant (' ') quotation marks

Re: How to split a variable with 2 delimiters

Tom — Thu, 27 Jun 2019 18:18:36 GMT

Note that in SAS code you can use either the single quote character or the double quote character to enclose string literals. Not sure if there is a similar goofy name that people use for the double quote character.

Re: How to split a variable with 2 delimiters

Gladis6680 — Thu, 27 Jun 2019 18:23:20 GMT

Yes I understand, thank you