topic Extract words delimited by a text field in New SAS User

Extract words delimited by a text field

daniele_1306 — Tue, 07 May 2019 08:58:25 GMT

I have a text field with the words delimited by; .
the number of words is fixed.
how can I extract all the words from the text field? 
ex: 
Row 01: 299999;Pippo;45.89;Pluto;Sas
Row 02: 7777;George;4567.2;David;Enterprise

Re: Extract words delimited by a text field

Jagadishkatam — Tue, 07 May 2019 09:12:37 GMT

May we know if you want words in separate columns/variables or in a single variable

Re: Extract words delimited by a text field

PeterClemmensen — Tue, 07 May 2019 09:24:37 GMT

Do something like this and extract the values you consider a 'word'

data have;
length string $100;
string="299999;Pippo;45.89;Pluto;Sas";output;
string="7777;George;4567.2;David;Enterprise";output;
run;

data want;
   set have;
   do i=1 to countw(string, ';');
      word=scan(string, i, ';');
      output;
   end;
run;