I am trying to call a stored procedure created in Oracle through SAS using pass-through but getting an error. The procedure is successfully getting executed in oracle. Below is my code and error   Code -  proc sql; CONNECT TO oracle (user=abc password='xyz' path=abcd); EXECUTE (execute del_stored_proc) BY oracle; EXECUTE (COMMIT) BY oracle; disconnect from oracle; QUIT;   Error -  ERROR: ORACLE execute error: ORA-06550: line 1, column 8:PLS-00905: object del_stored_proc is invalidORA-06550: line 1, column 8:PL/SQL: Statement ignored.   Stored proc - It is no parameter proc with just a delete statement in the body CREATE OR REPLACE PROCEDURE del_stored_proc () IS BEGIN DELETE FROM test WHERE date >= add_months(trunc(sysdate), -4); END del_stored_proc;   I have tried the pass-through for create/insert statements and they work fine. Not sure what I am doing wrong here.   Thanks for helping out. ... View more

Hello ,  I have a scenario where I join the data from pervious month to the current month. The format for the column is YYYYMM (202001). The condition is like below: input(YYYMM,6.)+1 = input(put(DATEPART(DATE),yymmn6.),6.)   I am unable to figure out how to make this condition work for 2021 . I have to fetch data where I join Dec 2020 data to Jan 2021, so I want the condition like this 202012 +1 = 202101 but the above condition will not fetch 202101 data but instead give 202012 +1 = 201213.   Thanks for helping . ... View more

Hello ,    I am trying to calculate a value where I have to pick the value of A of the current rank and divide it with column B value of previous rank i.e. to calculate value of Rank 2 (Column C) = 164/13610.  The calculation has to be done in proc sql.    Rank A B C 1 148 13610   2 164 14829 164/13610 3 219 19566 219/19566 4 247 24494 247/19566 5 475 26909 475/24494 6 576 31694 576/26909   Please help how to do the calculation for each rank . Thanks. ... View more