Count only selected word in a string column

[sdang]

Hi all,

I have a character column, "PlayerTier1" contains "Classic" and "Emerald".  I want how many of "Classic" in that column without resorting to filter out "Classic".  Much like a CountIF function in excel.

Thank you all,

[mohamed_zaki · Accepted solution]

proc sql;
select count(PlayerTier1)
from have
where PlayerTier1='Classic';
quit;

[sdang]

Thank you!  But is there a Query Builder function I can use instead of resorting to proc sql?

[mohamed_zaki]

Check this 

Sample 31447: Counting the Number of Observations in a BY Group in SAS® Enterprise Guide

[mohamed_zaki]

---

@sdang wrote:

 instead of resorting to proc sql?

---

btw, What this mean?

[FreelanceReinh]

---

@mohamed_zaki wrote:

---

@sdang wrote:

 instead of resorting to proc sql?

---

btw, What this mean?

---

Please see "to resort to something."

[sdang]

HI,

I'm sorry if my choice of word might be mis-led.  I meant is there another way to get a summary table from Query Builder where a count column only counts Classic but others numeric columns sum by or count regardless of Classic? And using only Query Builder function, and not having to write codes in Proc SQL

Thanks

[Reeza]

The answer is in @Haikuo post.

Probably worth marking this question answered at this point as well.

One last tip, the comparison is case sensitive, so determine if you need to account for that. If you do, use UPPER() or LOWER() to set them all to the same case.

[sdang]

Thank you!

[sdang]

Thank you!

[Haikuo]

Could be as straightforward as:

proc sql;
select sum(playtier1='classic') as classic_ct from have ;
quit;

[sdang]

Thank you!

[Haikuo]

Add new computed column -> advanced expression -> sum(playertier1='classic') -> enter the name of your new column -> done.

[Reeza]

Query Builder writes SQL, so its the same as adding a filter within Query Builder.

For this type of summary its useful to determine why you want it, for display or in a table?

If display I would say a Summary Task would be more appropriate.