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
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
proc sql;
create table want as select month,count(var1) as count_var1 from have where var1 ne 0 group by month;
quit;
Proc freq data = have;
where var1 ne 0;
table month /out = want ;
run;
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.