topic Re: count the number of nonzero value of a variable by month in SAS Programming

count the number of nonzero value of a variable by month

Nieves — Mon, 03 Sep 2018 05:23:11 GMT

Hello SAS expert,

I have a dataset as follows and I want to create a variable count_var1 that reports the number of nonzero value of var1 for each month

month var1

1 5

1 0

1 3

2 0

2 7

2 0

3 9

3 0

3 6

4 10

4 0

5 7

5 4

5 0

6 8

6 7

6 9

so count_var1 would be

month count_var1

1 2

2 1

3 2

4 1

5 2

6 3

May I ask you kind help on how to implement this ?

Thanks

Jagadishkatam — Mon, 03 Sep 2018 05:29:43 GMT

proc sql;
create table want as select month,count(var1) as count_var1 from have where var1 ne 0 group by month;
quit;

Reeza — Mon, 03 Sep 2018 05:47:11 GMT

Proc freq data = have;

where var1 ne 0;

table month /out = want ;

run;