Hello Everybody, I am completely new to the world of SAS and I need to translate a SAS case stateemnt to SQL. here is the line of code WHEN (INDEX(UPCASE(SALES_STATUS), 'FORM RECEIVED')) >= 1 THEN 'Form Received' a) In English what is this line of code doing? b) how would I write this in SQL? I can't seem to get the functions or syntax to work in SQL. Any help would be much appreciated. Kind Regards Vinnie
... View more
