I am not really sure they are not duplicates since every value is similar for corresponding variables and also am getting combinations similar to Hutchinson's Vs Hutchinson's I have a similar dataset as below Type Site Gender COUNT
Hutchinson's Head M 1
Hutchinson's Neck M 35
Nodular Head M 4
Nodular Neck M 31
Superficial Head M 1
Superficial Neck M 38
Hutchinson's Neck F 36
Nodular Neck F 36
Superficial Neck F 36
Hutchinson's Head M 1
Hutchinson's Neck M 11
Nodular Head M 1
Nodular Neck M 15
Superficial Head M 1
Superficial Neck M 15
Hutchinson's Neck F 12
Nodular Neck F 12
Superficial Head F 1
Superficial Neck F 11 and when I am performing fisher exact as similar to chisquare am not getting the desired output %macro Pairwise_Chisq(data=, group=, outcome=,count=); proc freq data=&data noprint; by gender; table &group/out=out_group; run; data groupID; set out_group; GID=_n_; run; data _null_; set groupID nobs=nobs; call symput('num_group', compress(put(nobs, 11.))); stop; run; data fish; stop; run; %Do group1=1 %to &num_group-1; *for each pair obtain fish stat; %Do group2=&group1+1 %to &num_group; data group_pair; set groupID; if GID EQ &group1 then call symput('name_group1', &group); if GID EQ &group2 then call symput('name_group2', &group); run; ods output RiskDiffCol2=pcr_diff(where=(Row="Difference")); proc freq data=&data; by gender; tables &group*&outcome / riskdiff(cl=exact) ; exact riskdiff; where &group in ("&name_group1", "&name_group2"); weight &count; run; data diff1; set pcr_diff (where=(row="Difference")); PAIR_COMPARED="&name_group1"||" vs "||"&name_group2"; run; data fish; set fish diff1; run; %End; %End; data fish; set fish; keep gender type LowerCL UpperCL pair_compared Risk; run; %mend Pairwise_Chisq; Please kindly suggest Thanks
... View more