Help me with summary on combination of variables' value

hhchenfx — Tue, 13 Aug 2013 13:20:12 GMT

Hi Everyone,

I have a dataset that have a Target Variable and a number of independent variables, say a1 a2 … a6 as below.

I want to create a summary file of the target value for each combination of independent variable and their value.

Basically the summary will answer the question:

If a1=5 and a2=9, how many observations have target=0 and how many have target=1.

If a1=4 and a2=1, how many observations have target=0 and how many have target=1.

…

If a1=5 and a3=1, how many observations have target=0 and how many have target=1.

…..

I really appreciate it if you could help me with this problem.

Thank you,

HHC

data have;

input target a1 a2 a3 a4 a5 a6;

datalines;

0 5 9 1 0 8 1

1 4 0 1 1 5 0

1 8 1 2 3 1 1

1 3 3 0 2 0 6

0 4 1 1 7 0 0

0 3 3 0 9 0 3

1 2 1 1 2 1 2

0 1 2 0 3 0 4

;run;

Re: Help me with summary on combination of variables' value

RichardinOz — Tue, 13 Aug 2013 13:33:46 GMT

data want ;

set have ;

target1 = (a1=5) * (a2=9) ;

etc ;

run ;

Richard