I am using the below code to call a DB procedure from Sas. Sas is calling the procedure 2 times for one execution. Please help why it is calling the procedure 2 times.   %macro exsetup %put &sysuserid; proc sql; connect to oracle(path=<<service>> user=<<username>> password=<<password>>); libname l123 oracle user=<<username>> password=<<password>> path=<<service>> dbconinit = "begin pkg.procedure_name(1234); end;"; quit; %mend exsetup; %exsetup; ... View more

I am researching on how to compare 2 RTF files. There are many solutions. I don't find the one I am looking for.  My thought process was to convert the 2 RTF files into 2 datasets and compare the datasets using proc compare. Is this the right approach. If yes, how to convert a RTF file to Sas dataset? ... View more

Hi there, I would like to know if there is a way to find out if the program or macro is currently used by any other user.   For Example: There is a macro with the name macro1.sas. It is currently opened for edititing in a Sas studio or Sas EG. How to find out that macro1.sas is opened for edititng. Please suggest a programmatic way to do this. I am assuming there might a procedure or macro that helps me achieve this.   Thanks for your help!   Regards, Ajay ... View more