My suggestion would be to use the Teradata ODBC driver since you are already licensed for SAS Access to ODBC. ... View more

Hi @karthic2612   What SAS Access engine(s) do you have licensed ?     ... View more

Hi @karthic2612   As a starting point, see below. I've assumed SAS 9.4 on Linux.   Configuration: http://support.sas.com/documentation/installcenter/en/ikfdtnlaxsr/66396/PDF/default/sreq.pdf - Page 19   Usage: https://go.documentation.sas.com/api/collections/pgmsascdc/9.4_3.4/docsets/acreldb/content/acreldb.pdf?locale=en#nameddest=titlepage - Page 1021 ... View more

Hi team,   It's been 2+ years since the last update. Does anyone have some recent F5 experiences to share ? ... View more

So it seems like we're dealing with two different things here:   1.) Starting and stopping a SAS Workspace Server 2.) Setting some variables within the session once it running    Is this correct ? ... View more

Hi @FrancisDsa   Why do you need it to be done via code ? ... View more

Fully agree with @SASKiwi.   We have long moved from SAS 9.3 to SAS 9.4 and we're already well on our way with SAS Viya. Also keep in mind, it's not only application software like SAS that moves forward, it's the entire ecosystem of OS, DBs, utility software, etc.   Just some thoughts.....   ... View more

Hi @vkrishna   If you have lost the password for SharedServices, then maybe try the actions in the below link:   https://www.aii-3.com/wp-content/uploads/2017/09/How-to-manually-update-the-SharedServices-dbmsowners-password-in-PostgreSQL.pdf     ... View more

Hi @helannivas88   I agree with @Kurt_Bremser. The user must have write access to the file to be able to generate the file. Maybe to try and mitigate the risk, you could always move the logs to a secure location as soon as the SAS job finishes. This only leaves a window period from when the log was last written to, to the time being moved. E.g. put in a check to move the file as soon as the Workspace server PID dies.   But on another level, if you are dealing with cases where users are editing logs files as to alter the details of e.g. a query, then IMHO you are dealing with a case of fraud. If so, I would really suggest that you engage with your IT security to investigate.  ... View more