Desktop productivity for business analysts and programmers

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

Reply
Occasional Learner
Posts: 1

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

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. 

Super User
Posts: 4,030

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

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-n...

 

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.

Super User
Posts: 5,920

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

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.

Data never sleeps
Ask a Question
Discussion stats
  • 2 replies
  • 113 views
  • 0 likes
  • 3 in conversation