Hi,   I have been using the below query to save my sas logs. However, while I run the code, I can not view the live log. Please help.   proc printto log="C:\Reports\LK55_&sysdate..txt" New; run;   option obs=max; proc import datafile= "//<<path>>/LK.xlsx" out=LK dbms=xlsx replace; run;   I have also used Proc printo;run; before import query, this is giving the live log but the saved logs is having NIL data in this case.Is there any way to actually get both the logs..? ... View more

Hi,   I am facing a problem in deleting matching observations in a dataset that are in match with another. I have used the below but they did not work:   Data set A: ID 1 2 3 Data set B 2 3   want data set C ID 1   I used: /*************************************************/ proc sql; create table tableC as select a.* from tableA as a, tableB as b where a.id^=b.id; quit; /**************did not work***********************************/ and /*************************************************/ proc sql; delete from work.tableA where ID IN (select ID from work.tableB); quit; /***************did not work**********************************/ and I also tried deleting them directly /*************************************************/ proc sql; delete from tableA where ID in ("2","3"); quit; /*********************did not work****************************/   I also tried atleast selecting the common Ids proc sql; select * from tableA where ID in ("2","3"); quit; this also did not work (but there are common IDs, I am sure. I dont understand the issue here. Please help. There are no errors in the log, the queries are just not deleting the common IDs.   Regards.. ... View more