below is the complete log of the line. hopefully this would be helpful     ;*';*";*/;quit;run; 2 OPTIONS PAGENO=MIN; 3 %LET _CLIENTTASKLABEL='Program'; 4 %LET _CLIENTPROCESSFLOWNAME='Standalone Not In Project'; 5 %LET _CLIENTPROJECTPATH=''; 6 %LET _CLIENTPROJECTPATHHOST=''; 7 %LET _CLIENTPROJECTNAME=''; 8 %LET _SASPROGRAMFILE=''; 9 %LET _SASPROGRAMFILEHOST=''; 10 11 ODS _ALL_ CLOSE; 12 OPTIONS DEV=SVG; 13 GOPTIONS XPIXELS=0 YPIXELS=0; 14 %macro HTML5AccessibleGraphSupported; 15 %if %_SAS_VERCOMP_FV(9,4,4, 0,0,0) >= 0 %then ACCESSIBLE_GRAPH; 16 %mend; 17 FILENAME EGHTML TEMP; 18 ODS HTML5(ID=EGHTML) FILE=EGHTML 19 OPTIONS(BITMAP_MODE='INLINE') 20 %HTML5AccessibleGraphSupported 21 ENCODING='utf-8' 22 STYLE=HTMLBlue 23 NOGTITLE 24 NOGFOOTNOTE 25 GPATH=&sasworklocation 26 ; NOTE: Writing HTML5(EGHTML) Body file: EGHTML 27 28 data ora_work.testTableau_new;set ora_work.provider;keep npcod;run; NOTE: SAS variable labels, formats, and lengths are not written to DBMS tables. ERROR: Error attempting to CREATE a DBMS table. ERROR: ORACLE execute error: ORA-01031: insufficient privileges.. NOTE: The DATA step has been abnormally terminated. NOTE: The SAS System stopped processing this step because of errors. WARNING: The data set ORA_WORK.TESTTABLEAU_NEW may be incomplete. When this step was stopped there were 0 observations and 1 variables. ERROR: ROLLBACK issued due to errors for data set ORA_WORK.TESTTABLEAU_NEW.DATA. NOTE: DATA statement used (Total process time): real time 0.30 seconds cpu time 0.00 seconds 29 30 31 %LET _CLIENTTASKLABEL=; 32 %LET _CLIENTPROCESSFLOWNAME=; 33 %LET _CLIENTPROJECTPATH=; 34 %LET _CLIENTPROJECTPATHHOST=; 35 %LET _CLIENTPROJECTNAME=; 36 %LET _SASPROGRAMFILE=; 37 %LET _SASPROGRAMFILEHOST=; 38 39 ;*';*";*/;quit;run; 40 ODS _ALL_ CLOSE; 41 42 43 QUIT; RUN; 44 ... View more

I was successfully able to assign the ODBC library however now i have a different problem as follows   first i wrote a line to assign the library given to me by the admins   libname ODBCWORK odbc user=work pwd='MYPWSD' datasrc='EGYDBACT-WORK';   Then i wrote the following code to create a test table   DATA ODBCWORK.TESTTABLEAU; SET TEST;RUN;   then i found that all the tables that were in the library were replaced by only the table i created. and if i opened a new session i can see the original database again   Before Defing the the Library              After Defing the the Library      this also here is a photo of the proprieties of the DB for your reference         ... View more

Hi SASKiwi,   thank you for your reply. i checked with the administrator and they said they have removed the time limit (not sure if they doing it right though).   however the issue persists. in another operation connected to the same DB they use the below code to reconnect to the library   libname KSACT oracle user=WORK pass=TEST path=GMACT schema=work;   however when i only know the libname and i don't know what to write in the rest of the fields (User, Pass,Path & Schema) could you guide me how to acquire these info from SAS or if their a similar approach to this code to reconnect to the libname.   Thank you,           ... View more