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.
This post gives a pretty good summary of your options:
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.
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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.