Generate Crosstab in SAS

[PeterLee1012]

Hi experts,

I just start to use SAS and have a task to create a crosstab table. The table 1 below is the dataset with all dummy variables and how could I use SAS to generate the table like table 2? Table 2 shows that how many observation have both A&B or B&C or A&C.

[sotojcr · Accepted solution]

Hi!
Do you know anything about statistics?
in this case the crosstab  =  table of the sums of squares and crossproducts he sums of squares and crossproducts 

data TEST;
input A B C;
datalines;
1 0 1
0 1 0
0 0 1
1 0 1
1 1 1
0 1 1
1 0 1
1 0 0
0 1 0
0 1 1
;
run;

proc corr data=TEST SSCP  outp=SSCP noprint;
var A B C;
run;

or a cleaner code (without unnecessary columns)

proc corr data=TEST SSCP  outp=SSCP(drop = INTERCEPT where=(_TYPE_ ="SSCP" and _NAME_ ne "Intercept")) noprint;
var A B C;
run;

[PeterLee1012]

Thank you so much for your response, that solve the problem perfectly.

[PeterLee1012]

So do I have any chance to reorder the SSCP table? Like reorder A B C by their frequency.