标题: 错误的错误？ [打印本页] 作者: shiyiming 时间: 2010-6-24 22:57 标题: 错误的错误？ [code:213i6lii]PROC SQL;
CREATE TABLE _PlotCD4 AS
SELECT DISTINCT _PseudoID_,
PUT(_PseudoID_, Z3.) AS _ID,
MAX(StartStudy)-MAX(DATE0) AS _DaysCD4BL2RAL,
MAX(DATE)-MIN(DATE) AS _DaysCD4Fup,
MAX(DATE)-MIN(StartStudy) AS _DaysRALbl2lastCD4,
COUNT(*) AS _TimesCD4,
IFC(_rm ='10', 'R-M', 'R+M') AS _GROUP
FROM CD4_PLOT GROUP BY _PseudoID_;
QUIT;[/code:213i6lii]
[quote:213i6lii]2953 PROC SQL;
2954 CREATE TABLE _PlotCD4 AS
2955 SELECT DISTINCT _PseudoID_,
2956 PUT(_PseudoID_, Z3.)
2956! AS _ID,
2957 MAX(StartStudy)-MAX(DATE0) AS
2957! _DaysCD4BL2RAL,
2958 MAX(DATE)-MIN(DATE) AS
2958! _DaysCD4Fup,
2959 MAX(DATE)-MIN(StartStudy) AS
2959! _DaysRALbl2lastCD4,
2960 _t G???? COUNT(*)
-
[color=#800000:213i6lii]22
202[/color:213i6lii]
2960! AS _TimesCD4,
[color=#800000:213i6lii]ERROR 22-322: Syntax error, expecting one of the following: a quoted string, !,
!!, &, (, *, **, +, ',', -, '.', /, <, <=, <>, =, >, >=, ?, AND,
AS, BETWEEN, CONTAINS, EQ, EQT, FORMAT, FROM, GE, GET, GT, GTT,
IN, INFORMAT, INTO, IS, LABEL, LE, LEN, LENGTH, LET, LIKE, LT,
LTT, NE, NET, NOT, NOTIN, OR, TRANSCODE, ^, ^=, |, ||, ~, ~=.
ERROR 202-322: The option or parameter is not recognized and will be ignored.[/color:213i6lii]
2961 IFC(_rm ='10', 'R-M', 'R+M')
2961! AS _GROUP
2962 FROM CD4_PLOT GROUP BY _PseudoID_;
2963 QUIT;
[color=#0000FF:213i6lii]NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE SQL used (Total process time):
real time 0.00 seconds
cpu time 0.01 seconds[/color:213i6lii][/quote:213i6lii]