topic Re: count no of cases in SAS Programming

count no of cases

anirudhs — Thu, 31 May 2018 05:22:08 GMT

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.

Re: count no of cases

Kurt_Bremser — Thu, 31 May 2018 05:50:49 GMT

In SQL, this would be

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

Re: count no of cases

anirudhs — Thu, 31 May 2018 06:44:53 GMT

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

Re: count no of cases

Kurt_Bremser — Thu, 31 May 2018 07:06:22 GMT

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

Re: count no of cases

Reeza — Thu, 31 May 2018 14:51:17 GMT

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.

Re: count no of cases

anirudhs — Mon, 04 Jun 2018 04:53:43 GMT

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