topic Re: LIBNAME mode when using Process Flow in SAS Enterprise Guide

LIBNAME mode when using Process Flow

RPYee — Wed, 21 Feb 2024 16:42:14 GMT

History:

I use SAS Enterprise Guide 8.3 to connect to a Teradata Database. I DO NOT CODE. I create a new process flow, drag and drop tables, then build a query with them. I may do a series of queries from the results of the original query. I will often do Summary Tables.

Issue:

Apparently, I am connecting to the Teradata database using the mode ANSI. My peers all code in SAS EG, never using the process flow. They are able to alter the LIBNAME statement for each of their projects to set the mode to TERA, or TERADATA, whatever the case may be. I do not have this option when using the process that I follow.

Question:

Can anyone tell me how to change the connection mode for my SAS EG to Teradata database when using the process flow/query wizard options?

If I cannot figure this out shortly, I will lose my connectivity as the dba has announced he will cut all ANSI connections!

I appreciate any help you can provide. My SAS administrator here has no answers for me.

Re: LIBNAME mode when using Process Flow

SASKiwi — Wed, 21 Feb 2024 20:28:10 GMT

So how are you creating your Teradata database connection or does the connection already exist in your EG Servers window under Libraries? If so, posting a screenshot of Properties of that Library will be helpful.

Re: LIBNAME mode when using Process Flow

RPYee — Wed, 21 Feb 2024 21:35:49 GMT

I have a SAS Metadata Repository profile that I log into when I open the software:

Once I log in, my database is listed in the Servers list:

If I right-click on the database that I want to use and select "Properties", it shows an area under "Options" that looks like I might be able to define a new connection mode, but I have no idea where this statement holds its information. (see below)

Hope this gives you some ideas what I'm working with. I appreciate your help!

Re: LIBNAME mode when using Process Flow

SASKiwi — Wed, 21 Feb 2024 23:09:30 GMT

OK, It's obvious that that library definition is stored in SAS metadata. This is something that your SAS administrator maintains. So all it requires is for the SAS administrator to edit the library properties in SAS Management Console and add this option in this screen:

Note this the same as doing the MODE option in a LIBNAME statement.

Re: LIBNAME mode when using Process Flow

Patrick — Thu, 22 Feb 2024 00:26:20 GMT

The ideal scenario for you is for your SAS Admin to change the metadata library definition as already proposed by @SASKiwi .

Depending on your environment and its use such a change could require significant regression testing due to its potential impact.

Should you get too much push-back for implementation of this change to the metadata library definitions then a still low code alternative option for you could be:

1. Get the libname statements your colleagues are using

2. Per EG project add these libname statements as script that gets executed once when you connect to a SAS server. Any libname statement in this script will replace the libname definition from SAS metadata with the same libref. After that everything else will look and behave the same.

Setting SAS Program and Editor Options / Submit SAS code when server is connected

Re: LIBNAME mode when using Process Flow

RPYee — Thu, 22 Feb 2024 15:51:04 GMT

I sent your suggestion to my administrator. He said he'd take care of it. I am using the custom option selection in the meantime. Thanks for your input!

Re: LIBNAME mode when using Process Flow

RPYee — Thu, 22 Feb 2024 15:52:42 GMT

This WORKED LIKE A CHARM!! At least, I did what you said and my programs ran fine. Now, I'm just waiting for the DBA to confirm the success, but I'm confident it's working. I appreciate your help!