Hello all, I am fairly new to SAS. I am attempting to create a missing data matrix, but I am running into this while using PROC FREQ: ERROR: N-way tables disallowed for N>50. I was thinking of simply dividing that part of the code into 2 separate steps, but then the final missing count I am looking for would be off in the resulting tables. Is there a way to run this procedure with more than 50 variables at a time? This is the code I am using... /* Missing data matrix */ data psm; set psm; array ori{*} age dxage rheumdx diseaseactivity web_gen web_rheum eligibility visit_fb_r visit_tw_r visit_ig_r visit_bl_r visit_oth_r view_fb_r view_tw_r view_ig_r view_bl_r view_oth_r viewreason1_r viewreason2_r viewreason3_r viewreason4_r viewreason5_r viewreason6_r viewreason7_r viewreason8_r viewreason9_r viewreason10_r viewreason11_r post_fb_r post_tw_r post_ig_r post_bl_r post_oth_r dx_specific_accnt_r postrheum_anon_r postreason1_r postreason2_r postreason3_r postreason4_r postreason5_r postreason6_r result1_r result2_r result3_r result4_r result5_r result6_r result7_r discuss_rheum_r discuss_family_r discuss_child_r nopostreason1 nopostreason2 nopostreason3 nopostreason4 nopostreason5 reasonshare1 reasonshare2 reasonshare3 reasonshare4 c_global1 c_global2 c_global3 c_global4 c_global5 c_global6 c_global7 p_global1 p_global2 p_global3 p_global4 p_global5 p_global6 p_global7 p_global8 p_global9 p_global10 p_informational1 p_informational2 p_informational3 p_informational4 p_informational5 p_informational6 p_informational7 p_informational8; array ind{*} xx1 xx2 xx3 xx4 xx5 xx6 xx7 xx8 xx9 xx10 xx11 xx12 xx13 xx14 xx15 xx16 xx17 xx18 xx19 xx20 xx21 xx22 xx23 xx24 xx25 xx26 xx27 xx28 xx29 xx30 xx31 xx32 xx33 xx34 xx35 xx36 xx37 xx38 xx39 xx40 xx41 xx42 xx43 xx44 xx45 xx46 xx47 xx48 xx49 xx50 xx51 xx52 xx53 xx54 xx55 xx56 xx57 xx58 xx59 xx60 xx61 xx62 xx63 xx64 xx65 xx66 xx67 xx68 xx69 xx70 xx71 xx72 xx73 xx74 xx75 xx76 xx77 xx78 xx79 xx80 xx81 xx82 xx83 xx84 xx85; do i=1 to dim(ori); if ori{i} in (999,.) then ind{i}=0; else ind{i}=1; end; run; proc freq data=psm noprint; tables xx1*xx2*xx3*xx4*xx5*xx6*xx7*xx8*xx9*xx10*xx11*xx12*xx13*xx14*xx15* xx16*xx17*xx18*xx19*xx20*xx21*xx22*xx23*xx24*xx25*xx26*xx27*xx28*xx29*xx30* xx31*xx32*xx33*xx34*xx35*xx36*xx37*xx38*xx39*xx40*xx41*xx42*xx43*xx44*xx45* xx46*xx47*xx48*xx49*xx50*xx51*xx52*xx53*xx54*xx55*xx56*xx57*xx58*xx59*xx60* xx61*xx62*xx63*xx64*xx65*xx66*xx67*xx68*xx69*xx70*xx71*xx72*xx73*xx74*xx75* xx76*xx77*xx78*xx79*xx80*xx81*xx82*xx83*xx84*xx85 / missing norow nocol nopercent out=psm_miss; run; proc print data=psm_miss; run;
... View more
