BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
fatso33
Obsidian | Level 7

Dear all 

 

I am trying to run the following code and I am getting a strange error message that I cannot debug. please help me solve it....

 

ods output parameterestimates=parameterestimates5;
proc nlmixed data=ELISAcalibration4 noad qpoints=15;
num= bottom-top;
den= 1 + exp(slope*(logconc - c50));
expect= top + num/den;
model DO~normal(expect,var);
predict top + num/den out=fitted_values;
ods output ParameterEstimates=parm_est_repl;
ods output CovMatParmEst=cov_parm;
run;

* Data set containing parameter estimates;
data b;
set parm_est_repl;
where parameter in (’top’,’bottom’,’c50’,’slope’);
keep estimate;
run;
* Data set containing the covariance matrix of the parameter estimates;
data covb;
set cov_parm;
where parameter in (’top’,’bottom’,’c50’,’slope’);
keep top bottom c50 slope;
run;
proc sql noprint;
select distinct estimate into: sigma_sq from parm_est_repl where parameter=’var’;
select min(logconc) into: minconc from ELISAcalibration4 where logconc>0;
select max(logconc) into: maxconc from ELISAcalibration4;
run;
quit;

 

heres the error:

 

605 * Data set containing parameter estimates;
606 data b;
607 set parm_est_repl;
608 where parameter in (’top’,’bottom’,’c50’,’slope’);
-
22
76
ERROR: Syntax error while parsing WHERE clause.
ERROR 22-322: Syntax error, expecting one of the following: a quoted string, a numeric constant,
a datetime constant, a missing value, -.

ERROR 76-322: Syntax error, statement will be ignored.

609 keep estimate;
610 run;

NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set WORK.B may be incomplete. When this step was stopped there were 0 observations
and 1 variables.
WARNING: Data set WORK.B was not replaced because this step was stopped.
NOTE: DATA statement used (Total process time):
real time 0.03 seconds
cpu time 0.03 seconds


611 * Data set containing the covariance matrix of the parameter estimates;
612 data covb;
613 set cov_parm;
614 where parameter in (’top’,’bottom’,’c50’,’slope’);
-
22
76
ERROR: Syntax error while parsing WHERE clause.
ERROR 22-322: Syntax error, expecting one of the following: a quoted string, a numeric constant,
a datetime constant, a missing value, -.

ERROR 76-322: Syntax error, statement will be ignored.

615 keep top bottom c50 slope;
616 run;

NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set WORK.COVB may be incomplete. When this step was stopped there were 0
observations and 4 variables.
WARNING: Data set WORK.COVB was not replaced because this step was stopped.
NOTE: DATA statement used (Total process time):
real time 0.03 seconds
cpu time 0.03 seconds


617 proc sql noprint;
618 select distinct estimate into: sigma_sq from parm_est_repl where parameter=’var’;
-
22
200
ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string,
a numeric constant, a datetime constant, a missing value, (, *, +, -, ALL, ANY, BTRIM,
CALCULATED, CASE, INPUT, PUT, SELECT, SOME, SUBSTRING, TRANSLATE, USER.

ERROR 200-322: The symbol is not recognized and will be ignored.

 

1 ACCEPTED SOLUTION

Accepted Solutions
fatso33
Obsidian | Level 7

thank you very much kurt

View solution in original post

3 REPLIES 3
Kurt_Bremser
Super User

You have invalid (slanted) single quotes in your code, probably from editing outside of SAS with a word processor.

Single quotes must be this character: '

fatso33
Obsidian | Level 7

thank you very much kurt

fatso33
Obsidian | Level 7

Kurt it really worked. you are an expert thanks so much....no more errors

sas-innovate-2024.png

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

Register now!

Discussion stats
  • 3 replies
  • 724 views
  • 0 likes
  • 2 in conversation