SAS数据交叉表去除美元符号$$$
代码:
/*导入数据*/
%web_drop_table(WORK.IMPORT);
FILENAME REFFILE '/home/u62484233/统计分析软件/201605北京二手房数据.xls';
PROC IMPORT DATAFILE=REFFILE
DBMS=XLS
OUT=WORK.IMPORT;
GETNAMES=YES;
RUN;
/*绘制表1*/
PROC TABULATE DATA = WORK.IMPORT FORMAT=DOLLAR9.2;
CLASS bedrooms school floor;
VAR price;
TABLE bedrooms*school,floor*(price*(N MEAN)) all;
RUN;
结果:
解决进度:暂未解决