Using SAS LASR Analytic Server Libraries

Default Library

During installation, the SAS Deployment Wizard registers a library for SAS LASR Analytic Server. This library is available for use in the SAS Folders tree, and it is located in /Shared Data/SAS Visual Analytics/Public/Visual Analytics Public LASR.

Input Libraries

When you select a SAS LASR Analytic Server table as an input table, be aware of the following best practices if the table is large. If the table is not large, then using it for input requires no special considerations.
Here are the considerations for using a large SAS LASR Analytic Server table as an input table:
  • A WHERE clause is processed in memory by the server if no aggregations or joins are used. Specify a filter on the Where tab so that you use only the rows that you want.
  • If you want to join the table, then create one data query that copies the data from the server to the same library as the table that you want to join it with. Specify a filter on the Where tab, if applicable. Then, create another data query that performs the join.
    Tip
    As an alternative, you can create a LASR star schema so that the table is joined in memory with other in-memory tables.
  • You cannot join two tables from the SAS LASR Analytic Server and then transfer the output table back to the same server. Create a LASR Star Schema instead.

Output Libraries

A SAS LASR Analytic Server library is initially configured as the default output library. When you run a data query, you can click Visual exploration Explore Results to explore the table immediately.
You can select the Append data check box on the Properties tab to add rows to an in-memory table. However, this option is not available if you use a SAS Data in HDFS library as a staging library. Instead, for deployments that use HDFS, you can use the data query to append rows, and then save the in-memory table to HDFS.