Proc tabulate

是 否 +2 论坛币

k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

送您一个全额奖学金名额~ !

立即领取

感谢您参与论坛问题回答

经管之家送您两个论坛币！

+2 论坛币

Data:
v1 v2 v3
1   1   .
2   .    1
1   2  3

How can I get results:
         Missing    1                 2        3
           N         N    %      N   %    N     %
V1        1         2  100%
V2        1        1    50%   1    50%  0   0%
V3        0         1     33%  1    33%  1   33%

有一列显示MISSING，但是计算百分比的时候，不算MISSING.

Thanks a lot!!!

扫码加我 拉你入群

请注明：姓名-公司-职位

以便审核进群资格，未注明则拒绝

分享0 收藏0 回帖

关键词：Tabulate Late Abu ATE tab 百分比

试试这个，有点繁琐。

1. data a;
   
2. input v1 v2 v3;
   
3. cards;
   
4. 1 2 1
   
5. 1 . 2
   
6. . 1 3
   
7. ;
   
8. run;
   
9. ods output summary=miss;
   
10. proc means data=a nmiss;
    
11. var v1 v2 v3;
    
12. run;
    
13. ods output off;
    
14. 
    
15. data miss1;
    
16. set miss;
    
17. run;      
    
18. 
    
19. ods output OneWayFreqs=b1;
    
20. proc freq data=a;
    
21. table v1/crosslist nocum ;
    
22. run;
    
23. ods output off;
    
24. data b11;
    
25. set b1;
    
26. keep table frequency percent;
    
27. table='v1';
    
28. run;
    
29. 
    
30. ods output OneWayFreqs=b2;
    
31. proc freq data=a;
    
32. table v2/crosslist nocum ;
    
33. run;
    
34. ods output off;
    
35. data b22;
    
36. set b2;
    
37. table='v2';
    
38. if v2=2 then do;
    
39. frequency1=frequency;
    
40. percent1=percent;
    
41. end;
    
42. keep table frequency percent frequency1 percent1;
    
43. format percent1 5.2;
    
44. where v2=2;
    
45. run;
    
46. ods output OneWayFreqs=b3;
    
47. proc freq data=a;
    
48. table v3/crosslist nocum ;
    
49. run;
    
50. ods output off;
    
51. data b33;
    
52. set b3;
    
53. table='v3';
    
54. retain frequency1;
    
55. retain percent1;
    
56. if v3=2 then do;
    
57. frequency1=frequency;
    
58. percent1=percent;
    
59. end;
    
60. if v3=3 then do;
    
61. frequency2=frequency;
    
62. percent2=percent;
    
63. end;
    
64. format percent1 percent2 5.2;
    
65. drop F_v3;
    
66. run;
    
67. data b33;
    
68. set b33;
    
69. where v3=3;
    
70. drop v3;
    
71. run;
    
72. data b;
    
73. set b11 b22 b33;
    
74. run;
    
75. data miss1;
    
76. set miss;
    
77. do i=1 to 3;
    
78. if i=1 then do;
    
79. v1_NMiss=v1_NMiss;
    
80. output;
    
81. end;
    
82. else if i=2 then do;
    
83. v1_NMiss=v2_NMiss;
    
84. output;
    
85. end;
    
86. else v1_NMiss=v3_NMiss;output;
    
87. end;
    
88. run;
    
89. data miss2;
    
90. set miss1;
    
91. by i;
    
92. if first.i=1;
    
93. keep VName_v1 v1_NMiss;
    
94. rename v1_NMiss=missing;
    
95. if i=1 then VName_v1 = 'v1';
    
96. else if i=2 then VName_v1='v2';
    
97. else VName_v1='v3';
    
98. run;
    
99. data final;
    
100. merge miss2(rename=(VName_v1=table)) b;
     
101. by table;
     
102. run;
     
103. 
     
104. options formchar="|----|+|---+=|-/\<>*" missing = " " nodate nonumber;
     
105. proc report data =final nowindows spacing = 1 headline ls = 101 ps = 15 split = "|"style(column)={just=center};
     
106. columns ("--" table missing
     
107.                 ("1|--"frequency percent)
     
108.                 ("2|--"frequency1 percent1)
     
109.                 ("3|--"frequency2 percent2));
     
110. define table/ "" center width=2;
     
111. define missing/ "Missing|N" width=7 center;
     
112. define frequency/ "N" center width=1;
     
113. define percent/ "%" center;
     
114. define frequency1/ "N" center width=1;
     
115. define percent1/ "%" center;
     
116. define frequency2/ "N" center width=1;
     
117. define percent2/ "%" center;
     
118. compute after _page_ / left;
     
119. contline = "-----------";
     
120. line @34 "------------------------------------";
     
121. endcomp;
     
122. run;

复制代码