02-16-2016 02:01 PM
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,
02-16-2016 03:57 PM
instead of resorting to proc sql?
btw, What this mean?
Please see "to resort to something."
02-16-2016 04:04 PM
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
02-16-2016 04:08 PM
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.
02-16-2016 03:06 PM
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.
Need further help from the community? Please ask a new question.