topic Generate Crosstab in SAS in SAS Procedures

Generate Crosstab in SAS

PeterLee1012 — Thu, 28 Mar 2019 17:49:37 GMT

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.

Re: Generate Crosstab in SAS

sotojcr — Thu, 28 Mar 2019 20:23:15 GMT

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;

Re: Generate Crosstab in SAS

PeterLee1012 — Fri, 29 Mar 2019 13:19:10 GMT

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

Re: Generate Crosstab in SAS

PeterLee1012 — Fri, 29 Mar 2019 14:14:35 GMT

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