Hello SAS programming community,    I have a dataset that I have successfully used the catx function to create a new column called Active Holds. The issue now is a bit more complex for me. Most examples of the web for catx or any cat function illustrate how two column values can be combined into a new column. How do you combined two values from the same column? I created a fake dataset below to help illustrate my question. I would like to take values from the Active Holds column and combine Flex Advisement and Flex Orientation. Using the function catx(delimeter, column, column) does not give the results I need. How is this possible? Any help or guidance would be appreciated. Thank you in advance!   data sample_data; input STUID 'Active Holds'n& $21. 'Active Holds Date'n; format 'Active Hold Date'n mmddyy10.; datalines; 9007741 Flex Advisement 01/20/2022 9007741  Flex Orientation 01/20/2022 9008643 Cashier hold 01/20/2022 9011126 Admissions 01/07/2022 9013751 Cashier hold 12/19/2021 9024453 Admissions2 12/18/2021 ; run;  ... View more

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

Hello All!  I am somewhat new to SAS EG and came across this problem. Currently, I am moving a project from excel into SAS and I am trying to figure out a solution.  Essentially, I am trying to figure out a percent change from two specific periods. For example, the percent formula I am trying to re-create if (Fall 2019 DegreeCount) - (Fall 2018 DegreeCount) / (Fall 2018 DegreeCount). In excel it was done manually such as (G19-G20)/G20. How can I do that here in SAS enterprise guide?    Example Data: AcademicYr TermCode TermYear       School of Major         DegreeCount    CertCount 2019            201970     Fall 2019              School A                  500                        45 2019            201980     Spring 2020          School B                  120                        30 2019            201990     Summer 2020       School C                  5                           20 2018            201870      Fall 2018              School A                   2                            1 2018            201880      Spring 2019          School B                  6                           300 2018            201890      Summer 2019       School C                 2                          200         ... View more