Hello! I have a set of 17 variables from a survey. I am running some tests, so I did a simple proc freq: proc freq data=sw1;
table Q20_1;
run; And I get this result: Q20_1 Frequency Percent CumulativeFrequency CumulativePercent 1 74 21.02 74 21.02 2 126 35.80 200 56.82 3 113 32.10 313 88.92 4 39 11.08 352 100.00 Frequency Missing = 668 Then I tried a proc tabulate because I needed to do further analysis with the data, and everything when alright: proc tabulate data=sw1;
class Q20_1;
table (n='Count'*f=7. pctn<Q20_1>='Test1'*f=pctfmt9.2),Q20_1;
run; Results are the same but transposed, and that's ok. But, when I added the rest of the variables to the code to start getting the tables, the results were messed up. proc tabulate data=sw1;
class Q20_1 Q20_2 Q20_3 Q20_4 Q20_5 Q20_6 Q20_7 Q20_8 Q20_9 Q20_10 Q20_11 Q20_12 Q20_13 Q20_14 Q20_15 Q20_16 Q20_17;
table (n='Count'*f=7. pctn<Q20_1>='Test1'*f=pctfmt9.2),Q20_1;
table (pctn<q20_2>='Test2'*f=pctfmt9.2),q20_2;
table (pctn<q20_3>='Test3'*f=pctfmt9.2),q20_3;
table (pctn<q20_4>='Test4'*f=pctfmt9.2),q20_4;
table (pctn<q20_5>='Test5'*f=pctfmt9.2),q20_5;
table (pctn<q20_6>='Test6'*f=pctfmt9.2),q20_6;
table (pctn<q20_7>='Test7'*f=pctfmt9.2),q20_7;
table (pctn<q20_8>='Test8'*f=pctfmt9.2),q20_8;
table (pctn<q20_9>='Test9'*f=pctfmt9.2),q20_9;
table (pctn<q20_10>='Test10'*f=pctfmt9.2),q20_10;
table (pctn<q20_11>='Test11'*f=pctfmt9.2),q20_11;
table (pctn<q20_12>='Test12'*f=pctfmt9.2),q20_12;
table (pctn<q20_13>='Test13'*f=pctfmt9.2),q20_13;
table (pctn<q20_14>='Test14'*f=pctfmt9.2),q20_14;
table (pctn<q20_15>='Test15'*f=pctfmt9.2),q20_15;
table (pctn<q20_16>='Test16'*f=pctfmt9.2),q20_16;
table (pctn<q20_17>='Test17'*f=pctfmt9.2),q20_17;
run; Output for test1: Q20_1 1 2 3 Count 3 1 2 Test1 50.00 16.67 33.33 Why is this "big" class statement affecting another statement where I am not calling the rest of the variables? Thanks for your time, and I appreciate your help. SAS EG 7.12 (7.100.2.3350) (64-bit)
... View more