topic Re: TAKE FREQUENCY STATE WISE AND CITY WISE in SAS Programming

TAKE FREQUENCY STATE WISE AND CITY WISE

thanikondharish — Thu, 26 Jul 2018 13:58:20 GMT

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

Re: TAKE FREQUENCY STATE WISE AND CITY WISE

PeterClemmensen — Thu, 26 Jul 2018 14:07:27 GMT

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

Re: TAKE FREQUENCY STATE WISE AND CITY WISE

ballardw — Thu, 26 Jul 2018 18:56:16 GMT

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.

Re: TAKE FREQUENCY STATE WISE AND CITY WISE

thanikondharish — Thu, 26 Jul 2018 16:48:42 GMT

In this code nocellmerge notworking

Re: TAKE FREQUENCY STATE WISE AND CITY WISE

thanikondharish — Thu, 26 Jul 2018 17:00:42 GMT

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

Re: TAKE FREQUENCY STATE WISE AND CITY WISE

thanikondharish — Fri, 27 Jul 2018 02:05:21 GMT

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