横轴带有两级分类变量的cluster bar chart

proc sgplot data=yourfile;
vbar group/response=rowpercent group=location groupdisplay=cluster;
run;

farmman60 发表于 2013-12-5 21:29
proc sgplot data=yourfile;
vbar group/response=rowpercent group=location groupdisplay=cluster;
run ...

呵呵，你少了一个CITY.

webgu 发表于 2013-12-5 15:11
SHOW 一下？

好吧，我也贴出很烂的一种方法。。ps:可能要在sas9.3里面run.

1. data y;
   
2. input  city location RowPercent group ;
   
3. cards;
   
4. 8 1 31.14256825 1
   
5. 8 2 50.36649215 1
   
6. 9 1 49.07508161 1
   
7. 9 2 49.18918919 1
   
8. 11 1 46.84343434 1
   
9. 11 2 50.35714286 1
   
10. 12 1 37.12260436 1
    
11. 12 2 38.72071598 1
    
12. 13 1 45.23690773 2
    
13. 13 2 53.47416645 2
    
14. 14 1 42.39492995 2
    
15. 14 2 39.86676017 2
    
16. 15 1 38.63028357 2
    
17. 15 2 38.81401617 2
    
18. 16 1 48.17444219 2
    
19. 16 2 38.11931244 2
    
20. 17 1 31.59509202 3
    
21. 17 2 25.31522793 3
    
22. 18 1 45.62558796 3
    
23. 18 2 39.9078341 3
    
24. 19 1 35.46511628 3
    
25. 19 2 22.08333333 3
    
26. 20 1 46.20462046 3
    
27. 20 2 21.28309572 3
    
28. ;
    
29. run;
    
30. proc sort data = y; by city group;run;
    
31. proc transpose data=y out=y1;
    
32. by city group;
    
33. id location;
    
34. var rowpercent;
    
35. run;
    
36. 
    
37. data y2;
    
38. set y1;
    
39. if group=2 then city=city+2;
    
40. else if group=3 then city=city+4;
    
41. run;
    
42. 
    
43. proc sql;
    
44. insert into y2(city,_1,_2)
    
45.       values (13,0,0)
    
46.           values(14,0,0)
    
47.            values (19,0,0)
    
48.             values (20,0,0);
    
49. quit;
    
50. 
    
51. proc template;
    
52.    define statgraph example;
    
53.    begingraph;
    
54.    layout overlay/cycleattrs=true;
    
55.    barchart y=_1 x=city/barwidth=0.3 discreteoffset=-0.15 ;
    
56.    barchart y=_2 x=city/barwidth=0.3 discreteoffset=+0.15;
    
57.    endlayout;
    
58.    endgraph;
    
59.    end;
    
60.    run;
    
61.   proc sgrender data=y2 template=example;
    
62.   run;

复制代码

proc sgpanel data = test;
        panelby group/layout=columnlattice onepanel novarname noborder colheaderpos=top;
        vbar city/group = location response = rowpercent stat = mean groupdisplay=cluster;
run;

谢谢楼上两位，确实给了一些思路。不过，横坐标的GROUP间的间隙的显示还是差点意思。

@爱美丽高 给出了一个比较好的代码：

proc sgpanel data = y;
    panelby group/layout=columnlattice  spacing=20   uniscale=row   novarname noborder onepanel colheaderpos=top;
    vbar city/group = location response = rowpercent stat = mean groupdisplay=cluster;
run;

缺限就是一加SPACEING 横轴断裂。可惜没有找到相应的控制选项。

yuerqieqie 发表于 2013-12-6 00:06
proc sgpanel data = test;
        panelby group/layout=columnlattice onepanel novarname noborder colheader ...

uniscale=row ，spacing两个选项做一下设置。

webgu 发表于 2013-12-7 09:41
uniscale=row ，spacing两个选项做一下设置。

不加spacing的话x轴就不会断掉，只是group之间的间距小了一些