topic Re: Count vowels from string and load in Macro variables in SAS Programming

Count vowels from string and load in Macro variables

vandhan — Thu, 02 Feb 2017 09:56:55 GMT

Data have;

var1 var2

1 read

2 write

3 sing

4 dance

I want to load count of vowels from var2 to macro variable.

like for read - 2 vowels (o and e)

write - 2 (i and e)

goes on...

help me how to count vowels from a string.

Thanks

RW9 — Thu, 02 Feb 2017 10:08:27 GMT

Edit: I add the i modifier also to avoid casing issues - even though your test data didn't show upper case.

Use compress with the keep option and lengthn:

data want;
  set have;
  num_vowels=lengthn(compress(yourvariable,"aeiou","ki"));
run;