Create new variable - count

[mfcy]

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!

[PeterClemmensen · Accepted solution]

Use the Countw Function like this

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