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;
... View more