Hi, I have a dataset that has a variable with the name Fees which represents a changed in Fees that were paid. I would like to be able count the number of entries that are not zero ($0.00) and not empty cells using the Case When Statement. Is this even possible using the Case When Statement or is there a more efficient way to achieve this. Thanks in advance.
The simplest way to count the number of positive fees in a datastep is the sum statement:
countPos + (Fees > 0);
within a SQL query, you would use:
sum(Fees > 0) as countPos,
Note The comparison (Fees > 0) has value 1 for positive fees and zero for nul or missing fees.
PG
PG
Ready to join fellow brilliant minds for the SAS Hackathon?
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.