topic Count of observations with at least one condition met in SAS Programming

Count of observations with at least one condition met

ipsum — Tue, 20 Dec 2016 19:23:32 GMT

I have a dataset that looks like the following:

ID MONTH VAR

1 1 2

1 2 2

1 3 1

2 1 2

2 2 2

2 3 2

3 1 1

3 2 1

3 3 1

I need to get a count of ID's where VAR=1 for at least one of the months.

I'm not a very advanced user.

Is there code that could easily accomplish what I'm looking for?

SuryaKiran — Tue, 20 Dec 2016 19:49:51 GMT

If you need just the count then use PROC SQL.

data one;

infile datalines;

input ID MONTH VAR;

datalines;

1 1 2

1 2 2

1 3 1

2 1 2

2 2 2

2 3 2

3 1 1

3 2 1

3 3 1

;

run;

proc sql;

select distinct count(id) INTO: count

from one

where var=1 and month=1;

quit;

Astounding — Tue, 20 Dec 2016 19:50:12 GMT

This might be the easiest way:

proc sql;

select count(distinct id) from your_dataset where var=1;

quit;