Create new variable - count

mfcy — Sun, 11 Apr 2021 07:11:15 GMT

Hello everyone,

I want to create a new variable (Students_Count) which counts the number of students in the Student_Names column.

The result that I need:

Any advice would be greatly appreciated.

Thank you!

Re: Create new variable - count

PeterClemmensen — Sun, 11 Apr 2021 07:34:01 GMT

Use the Countw Function like this

data want;
   set have;
   count = countw(student_names, ',');
run;