topic How do i does not refer to the record in proc mean in SAS Programming

How do i does not refer to the record in proc mean

shlomiohana — Tue, 11 Aug 2020 18:51:28 GMT

Hello,

In the table shown I use proc mean and I want when the field number_card =7777 the record will be taken into account but will not be counted in the number of records.

For example in this table, the proc mean will be count 4 records.

Is it possible?

table:

bank	branch	number_card	group	company
20	1	33378789	2	22
20	1	33335345	3	31
20	1	7777	5	51
20	2	44454534	2	22
20	2	7777	3	31
20	2	44434535	5	51

Proc Means Data=SASHelp.cars;

class branch;
Var group;

Run;

And I'll get something like that:

branch	N Obs	group
1	1	2
1	1	3
1	0	5
2	1	2
2	0	3
2	1	5

Thanks.

Re: How do i does not refer to the record in proc mean

Tom — Tue, 11 Aug 2020 19:25:41 GMT

Sounds like you just want to add a WHERE statement to exclude those observations.

Clearly your dataset is not named SASHELP.CARS. Let's assume it is named HAVE instead.

Do you want the MEAN of GROUP? That doesn't make much sense unless the GROUP variable has the number of people in the group? Looks more like you want to use GROUP as another CLASS variable.

Assuming number_card is a character variable then the code could look like:

proc means data=HAVE ;
  where number_card ne '7777';
  class branch group;
run;