Count vowels from string and load in Macro variables

[vandhan]

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 · Accepted solution]

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;