ERROR: Subquery evaluated to more than one row.

andimo89 — Thu, 02 Sep 2021 20:44:42 GMT

Hello All,

I recently started to code in sas and I need to figure out a specific difference. Example: (new number - old number)/ Old number = % Diff

This is my solution. I could not figure it out any other way but I keep getting this error. What does this mean? I am not sure if I understand what this means.

PROC SQL;
CREATE TABLE VS_Final_Grad_Rates_T2T AS
SELECT *,
((Certificate_Term-
(select Certificate_Term from
TERM_GRADS_ADD_TOT WHERE School_of_Major = a.School_of_Major AND
Num_Term_Sequence = a.Num_Term_Sequence-3))/(select Certificate_Term from
TERM_GRADS_ADD_TOT WHERE School_of_Major = a.School_of_Major AND
Num_Term_Sequence = a.Num_Term_Sequence - 3)) AS
Cert_Term_Difference format = percent8.2,
((Degree_Term-
(select Degree_Term from
TERM_GRADS_ADD_TOT WHERE School_of_Major = a.School_of_Major AND
Num_Term_Sequence = a.Num_Term_Sequence-3))/(select Degree_Term from
TERM_GRADS_ADD_TOT WHERE School_of_Major = a.School_of_Major AND
Num_Term_Sequence = a.Num_Term_Sequence - 3)) AS
Degree_Term_Difference format = percent8.2,
((Total_Grads_Term-
(select Total_Grads_Term from
TERM_GRADS_ADD_TOT WHERE School_of_Major = a.School_of_Major AND
Num_Term_Sequence = a.Num_Term_Sequence-3))/(select Total_Grads_Term from
TERM_GRADS_ADD_TOT WHERE School_of_Major = a.School_of_Major AND
Num_Term_Sequence = a.Num_Term_Sequence - 3)) AS
Total_Awards_Term_Difference format = percent8.2
FROM WORK.TERM_GRADS_ADD_TOT AS a;
Quit;

Re: ERROR: Subquery evaluated to more than one row.

PaigeMiller — Thu, 02 Sep 2021 20:56:35 GMT

When you get an error in the log, show us the log. Specifically, we need to see the ENTIRE log for this PROC, all of it, every single character, nothing chopped out.

Please copy the log as text and paste it into the window that appears when you click on the </> icon. DO NOT SKIP THIS STEP.

And, please, from now on show us the log whenever you get errors in the log, don't make us ask for it.

Re: ERROR: Subquery evaluated to more than one row.

andimo89 — Thu, 02 Sep 2021 20:58:21 GMT

As this is my third question, on this community. I apologize for not having the wherewithal to post the log. I will do so shortly.

topic Re: ERROR: Subquery evaluated to more than one row. in SAS Programming

ERROR: Subquery evaluated to more than one row.

Re: ERROR: Subquery evaluated to more than one row.

Re: ERROR: Subquery evaluated to more than one row.