I am using SAS Management Console 9.4, I have created an oracle connection and set up a library within Data Library Manager, within this library there are 100+ views when setting access to read for all sasusers on the library this does not change the table permissions, the only way I have managed to do this is by right clicking on each table and changing the permissions. Would anyone know of a quick easier way to do this?   Thanks ... View more

I am trying to submit this code   proc sql; connect to odbc as mycon (datasrc='xxxx' user='xxxx' password='xxxx' BULKLOAD=YES); create table Table01 AS select * from connection to mycon (select * from xxx.REQUEST where DT_TRAN_CREATED >= "&maxdate"dt); disconnect from mycon; quit;   &maxdate is defined as 28MAR2018:14:12:48.00.   When I run this code I get this error RROR: PROC SQL requires any created table to have at least 1 column. Any ideas on a solution - Thanks in advance     ... View more

I currently use the below code to insert data from work into a permanent table.  I was wondering if there is a more efficient way of doing this? The process is: Import CSV Check to see if transaction ID is in Permanent SAS table if not insert Data Work.temp; Set Lib.Permanent_Table (firstobs=30000000); Keep Transaction_ID; Run; Proc sql; INSERT INTO Lib.Permanent_Table SELECT * FROM WORK.Table01 WHERE 'Transaction_Id'n NOT IN (SELECT 'Transaction_Id'n FROM work.temp) ; drop table work.temp ; QUIT;   The Permanent table has 41,995,622 observations and I am inserting another 150k every day with 90 columns.   Thanks       ... View more

I am using the below macro to check for a lock every 15 seconds for 30 minutes.    %macro trylock(member=, timeout=); %local starttime; %let starttime = %sysfunc(datetime()); %do %until (&syslckrc = 0 or %sysevalf(%sysfunc(datetime()) > (&starttime + &timeout))); %put trying to open ...; %put trying lock ...;   lock &member; %if &syslckrc ne 0 %then %let rc=%sysfunc(sleep(15)); %put syslckrc=&syslckrc; %end; %mend trylock;   if the file is locked the macro will keep running either for 30 minutes or until a lock is available.  It will write to the log every time it attempts to lock the file   Below is an example   ERROR: A lock is not available for <Data> syslckrc=70031 trying to open ... trying lock ... ERROR: A lock is not available for <Data> syslckrc=70031 trying to open ... trying lock ... NOTE: <Data>  is now locked for exclusive access by you. syslckrc=0 17           Is there a way I can just get the last entry written to the log rather than all entries?   ... View more