13274118709 发表于 2017-12-5 15:40
本人SAS小菜鸟,对于summary,大神能说的详细一些吗?
DATA X1;
INPUT FID$4. YEAR 8.;
CARDS;
1111 1988
1111 1987
1112 1955
1112 1961
1112 1983
1112 1987
1113 1988
1114 1955
1114 1985
1115 1973
1115 1977
1115 1998
1115 2003
;
RUN;
DATA X2;
SET X1;
IF YEAR<1949 THEN C=1;
IF YEAR>2000 THEN A=1;
IF YEAR >=1949 AND YEAR<=2000 THEN O=1;
RUN;
PROC SQL;
CREATE TABLE X3 AS SELECT FID , SUM(C) AS C ,SUM(O) AS O ,SUM(A) AS A
FROM X2
GROUP BY FID;
RUN;