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;
data want ;
set have ;
target1 = (a1=5) * (a2=9) ;
etc ;
run ;
Richard
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.