topic Equivelant of Excel's COUNTIF in Advanced Expression Editor in SAS Enterprise Guide

Equivelant of Excel's COUNTIF in Advanced Expression Editor

Silvertreetops — Tue, 30 Sep 2014 02:48:20 GMT

across_Hi,

I'm looking for an equivelant to Excel's COUNTIF function in SAS EG Advanced Expression Editor. Below is an example of what I'd like to achieve

INPUT DATASET

name	age
bill	14
bob	18
ben	21
sarach	18
shane	14
sonya	15

OUTPUT DATASET

name	age	count of age
bill	14	2
bob	18	2
ben	21	1
sarach	18	2
shane	14	2
sonya	15	1

I have looked at other sas forum entries but can't quite figure them out. I understand that advanced expression editor may be limited to calculating based on the row only, but am not sure. If someone could please how I can attain this in SAS EG I would be most appreciative.

Regards

Re: Equivelant of Excel's COUNTIF in Advanced Expression Editor

Reeza — Tue, 30 Sep 2014 03:02:04 GMT

Assuming you wanted to use query builder then try the following:

1. Add Name, Age

2. Add Computed Column, Summarized Column, Add Age, Count-> make sure to name the column appropriately

3. Under summary groups, De select Automatically select and manually select only Age.

If you want code:

proc sql;

create table want as

select name, age, count(age) as count_age

from sashelp.class

group by age;

quit;

Re: Equivelant of Excel's COUNTIF in Advanced Expression Editor

Silvertreetops — Wed, 01 Oct 2014 01:48:47 GMT

Thank you so much Reeza

😄