topic Deploy SQL Server Views into SAS server with columns and tables that I have >32 in SAS Enterprise Guide

Deploy SQL Server Views into SAS server with columns and tables that I have >32

omanlap — Tue, 06 Mar 2018 23:55:57 GMT

Hi,

We have a Data Warehouse that consists of views maintained by the DW team. Currently, we are finding that we need to maintain two sets of views: one for our SQL server users and one for the SAS users in our company due to the character limitations in SAS.

We are looking to avoid having to maintain two seperate views and are hoping there is a way to deploy our SAS views without having to modify the tables names and columns as there are a great number of views and columns.

Does anyone have a best approach in dealing with this problem?

Thank you so much for any help that you can give regarding this issue.

Re: Deploy SQL Server Views into SAS server with columns and tables that I have >32

SASKiwi — Wed, 07 Mar 2018 00:23:53 GMT

This post gives a pretty good summary of your options:

https://communities.sas.com/t5/SAS-Data-Management/Long-SQL-Server-via-ODBC-table-names-amp-column-names/m-p/356253#M10679

What you are currently doing is really the only option if you want to show all these tables properly in the EG server list.

SAS have indicated that they are looking at providing better support for > 32 character table and column names but there has been no confirmation of when or if that may happen that I'm aware of.

Re: Deploy SQL Server Views into SAS server with columns and tables that I have >32

LinusH — Wed, 07 Mar 2018 12:04:45 GMT

I'm not sure what you are hoping to get as an answer.

Fact: SAS has a limitation for object names.

So what could possible be the solution?

1. Adopt your view accordingly

2. Have you users write SQL pass through queries.