How to split a variable with 2 delimiters

[Gladis6680]

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.

[Reeza]

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

[Gladis6680]

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

[Tom · Accepted solution]

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

[Gladis6680]

Thank you so much!!! that was easy

[PeterClemmensen]

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;

[Gladis6680]

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

[Tom]

---

@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'?

[Gladis6680]

sorry I meant (' ') quotation marks

[Tom]

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.

[Gladis6680]

Yes I understand, thank you