topic Counting Variables in SAS Procedures

Counting Variables

renjithr — Thu, 09 Feb 2012 22:07:23 GMT

Hi,

Could you please help me with the following requirement:

I have a dataset like the following:

State Visited

------- ----------

CA Y

NV Y

NV Y

NV N

NV N

GA N

I need to have an output dataset like the following:

State Yes No

------- ---- ----

CA 1 0

NV 2 2

GA 0 1

Please share your thoughts

Thanks

Counting Variables

art297 — Thu, 09 Feb 2012 22:29:47 GMT

Here is one of many ways:

data have;

input (State Visited) ($);

cards;

CA Y

NV Y

NV Y

NV N

NV N

GA N

;

proc sql;

select state,

sum(visited="Y") as Yes,

sum(Visited="N") as No

from have

group by state

;

quit;

Counting Variables

renjithr — Thu, 09 Feb 2012 22:53:00 GMT

Thanks so much!