proc sql; create table import1 as select I,J,ENTRY,avg(Height CMDS CBSDL CBSDS CBSDRNharvest SRNumber SRMass FSRYield Groundbiomass TBMass Hindex Dmcontent BCarotene PPD1w PPD2w) as avg_Y,AVGH from import1 group by I,J,ENTRY; title "Griffing model 1 method 4"; %DialAnalFixModel(NUM_P=6,method=4,Yvar=Height CMDS CBSDL CBSDS CBSDRNharvest SRNumber SRMass FSRYield Groundbiomass TBMass Hindex Dmcontent BCarotene PPD1w PPD2w,ENV=2,rep=3,dsn=import1); run; quit results with error: 79 proc sql; 80 create table import1 as 81 select I,J,ENTRY,avg(Height CMDS CBSDL CBSDS CBSDRNharvest SRNumber SRMass FSRYield Groundbiomass TBMass Hindex Dmcontent ____ 22 76 81 ! BCarotene PPD1w PPD2w) as avg_Y,AVGH ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, (, ), *, **, +, ',', -, '.', /, <, <=, <>, =, >, >=, ?, AND, BETWEEN, CONTAINS, EQ, EQT, GE, GET, GT, GTT, IN, IS, LE, LET, LIKE, LT, LTT, NE, NET, NOT, NOTIN, OR, ^, ^=, |, ||, ~, ~=. ERROR 76-322: Syntax error, statement will be ignored. 82 from import1 83 group by I,J,ENTRY; NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements. 84 title "Griffing model 1 method 4"; WARNING: Apparent invocation of macro DIALANALFIXMODEL not resolved. 85 %DialAnalFixModel(NUM_P=6,method=4,Yvar=Height CMDS CBSDL CBSDS CBSDRNharvest SRNumber SRMass FSRYield Groundbiomass _ 180 85 ! TBMass Hindex Dmcontent BCarotene PPD1w PPD2w,ENV=2,rep=3,dsn=import1); ERROR 180-322: Statement is not valid or it is used out of proper order. 86 run; NOTE: PROC SQL statements are executed immediately; The RUN statement has no effect. 87 quit 88 89 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE SQL used (Total process time): real time 0.01 seconds cpu time 0.02 seconds ##- Please type your reply above this line. Simple formatting, no attachments. -##
... View more