Exploring, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

LASR table name standards

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 80
Accepted Solution

LASR table name standards

[ Edited ]

Hello everyone, I am in process of loading our first set of datasets into LASR tables from our SQL Server registered tables library.  I have been watching some of SAS video's and based on my reading on some of the blogs mostly adding and LASR extension to the name of LASR.  For example if my table name called T_Employee in LASR they name it T_Employee LASR.  Is there any reason for it and if I don't use a LASR would it be an issue in the future?

 

Thank you for your assistant

 


Accepted Solutions
Solution
‎05-02-2018 10:47 AM
Super User
Posts: 4,030

Re: LASR table name standards

Personally I can't see the point of renaming a table when loading it into LASR. Adding LASR as a suffix on LASR table name looks completely redundant to me as you can identify all LASR tables by the SAS library they are in.

 

We have a practice of preparing our LASR tables in a normal SAS library first, which we refer to as our LASR Staging library. Then we keep exactly the same table names when we load them into LASR. To me this a simple and obvious approach - changing table names unless there is a good business reason seems pointless. I can understand you would want to have different names if the table contents were different, for example if you were doing update-type loads rather than replacement-type loads, but if your load and LASR tables are identical I suggest keeping the names the same is good practice. 

View solution in original post


All Replies
Solution
‎05-02-2018 10:47 AM
Super User
Posts: 4,030

Re: LASR table name standards

Personally I can't see the point of renaming a table when loading it into LASR. Adding LASR as a suffix on LASR table name looks completely redundant to me as you can identify all LASR tables by the SAS library they are in.

 

We have a practice of preparing our LASR tables in a normal SAS library first, which we refer to as our LASR Staging library. Then we keep exactly the same table names when we load them into LASR. To me this a simple and obvious approach - changing table names unless there is a good business reason seems pointless. I can understand you would want to have different names if the table contents were different, for example if you were doing update-type loads rather than replacement-type loads, but if your load and LASR tables are identical I suggest keeping the names the same is good practice. 

Frequent Contributor
Posts: 80

Re: LASR table name standards

Thank you @SASKiwi for your help and info.  Much appreciated, the way I have ours setup is to using ODBC library straight to our DW and registered all of tables we want users to access from EG or SAS Studio.  Then based on the business requirement I am moving some of these tables into LASR to be used by our users in visual analytics.  I am assuming you "your LASR staging" is the same as my ODBC library. 

Again thanks for the info.

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 157 views
  • 1 like
  • 2 in conversation