TAKE FREQUENCY STATE WISE AND CITY WISE

[thanikondharish]

DATA C ;
INPUT ID $ STATE $ CITY $ COUPON $ ;
CARDS ;
101  TEL   HYD    A
101  TEL   WAR   B
101  AP     VIJ      A
101  AP    GUN    B
101  AP    VIZ      B
102  TEL   HYD    B
102  TEL   WAR   A
102  AP    VIJ       B
102  AP   GUN     A
102  AP   VIZ       B     
;

By using above dataset how to take frequncey as state wise and city wise final i want to get data like this 

 ID      STATE/CITY     A      B

101    AP                     2       4

               GUN             1       1

                VIJ                1       1

                 VIZ               0       2

102     TEL                    2        1

                  HYD            1         1

                  WAR           0          1

[PeterClemmensen]

Is STATE/CITY a single variable here?

And how is B=4 for ID=101? PLease be more specific about how the desired data set is structured

[thanikondharish]

yes STATE/CITY is same variable .I want state and city keep in one variable

[ballardw]

One way is:

proc tabulate data=c;
   class id state city coupon;
   table id*(state all=' ')*city,
         coupon=' '*n=' '
         / nocellmerge   misstext='0'
   ;
run;

Proc Tabulate by default will not use any record with a missing value for any of the class variables. So that may need to be checked before use.

[thanikondharish]

In this code nocellmerge notworking

[thanikondharish]

i want state and city keep in one variable how will we do?