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.
... View more