Counting Variables

[renjithr]

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

[art297]

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;

[renjithr]

Thanks so much!