作者MOONY135 (谈无慾)
看板Statistics
标题Re: [程式] SAS proc means 垂直加总
时间Tue May 12 14:49:14 2015
※ 引述《andersonhaha (好山好水 多健康)》之铭言：
: id condition 1997 1998 1999 2010
: 1 A 0 0 0 1
: 1 B 0 1 1 1
: 1 C 0 0 2 2
: 加总 0 1 3 4
: 2 A
: 2 B .. .. .. .. ..
: [程式范例]:
: proc means data=a sum;
: class id condition;
: var 1997-2010
: output out=b; run; 是这样吗？SAS好像跑不太动..(windows full)..
: 谢谢指教！！
data step1;
set demo_data;
forsort='1';
format condition $char100.;
run;
PROC SQL;
CREATE TABLE step2 AS
SELECT distinct id,
"总合" as condition,
sum('1997'n) as '1997'n,
sum('1998'n) as '1998'n,
sum('1999'n) as '1999'n,
sum('2000'n) as '2000'n,
'2' as forsort
FROM WORK.DEMO_DATA
group by id;
QUIT;
data final;
set step1 step2;
run;
PROC SORT DATA= final OUT= final; BY id forsort;
RUN;
顺便请问一下要怎样在data set里面改栏位长度
--
※ 发信站: 批踢踢实业坊(ptt.cc), 来自: 114.35.215.137
※ 文章网址: https://webptt.com/cn.aspx?n=bbs/Statistics/M.1431413356.A.F85.html