I want to call an Oracle user-defined function within SAS EG. The function is to be called as a column output from a table and uses parameters from the said table as well. I tried to do it as a computed column but SAS EG said it wasn't a valid. I would normally call the function from SQL as follows:
SELECT TBRACCD_PIDM ,TBRACCD_TERM_CODE ,BANINST1.F_CALC_REGISTRATION_HOURS(TBRACCD_PIDM,TBRACCD_TERM_CODE, 'TOTAL', 'CREDIT') AS Total_Credit_Hours FROM TBRACCD WHERE TBRACCD_BALANCE != 0 AND TBRACCD_TERM_CODE NOT IN ('ARTERM')
I pulled in TBRACCD from my library and used Query Builder to select the columns I want as output and add the necessary filters but just can't get the function call in. Is it possible from SAS EG?
... View more