count no of cases

[anirudhs]

Hi i want to count total number of cases in data set .

The data has variable status so want to count total no of cases based on the values of status.

filter should be where status=cr then the total count should be stored in new variable.

if status-ct then count of ct in new variable.

[Kurt_Bremser · Accepted solution]

In SQL, this would be

select count(*) from ...... where status = "ct";

[anirudhs]

Thanks Kurt ,
any solution how can we implement it using the query builder.
and any data step

[Kurt_Bremser]

In the query builder, select status and apply the count() summary function to it; on the second tab, add the where condition.

[anirudhs]

Hi Kurt,
i used the following sum(case when status=ct then 1 else 0) which gave me the the count of ct cases in the data set similarly i did it for the other case where i got the required o/p using the query builder and designed the automated process flow.

Thanks for your help.
Anirudh

[Reeza]

---

---

That's three questions in one.

---

@anirudhs wrote:

Hi i want to count total number of cases in data set .

---

Use a summarization task

---

@anirudhs wrote:

The data has variable status so want to count total no of cases based on the values of status.

---

Again, a Summary task will produce that. 

---

@anirudhs wrote:

if status-ct then count of ct in new variable.

---

In a separate data set, how do you need that stored? You can use Query builder with a filter or you could save the results from the summary tasks into a dataset for use later.

It seems like all your results could be handled with a summarization procedure.