SAS Viya. Kevin D. Smith

Caslib and CAS Table Visibility

       The Active Caslib

       Uploading Data Files to CAS Tables

       Uploading Data from URLs to CAS Tables

       Uploading Data from a Pandas DataFrame to a CAS Table

       Using Data Message Handlers

       The HTML Data Message Handler

       The Excel Data Message Handler

       The PandasDataFrame Data Message Handler

       Using Data Message Handlers with Databases

       Writing Your Own Data Message Handlers

       Variable Definition Details

       Adding Data Transformers

       Managing Caslibs

       Creating a Caslib

       Setting an Active Caslib

       Dropping a Caslib

       Conclusion

       Chapter 5: The CASAction and CASTable Objects

       Getting Started with the CASAction Objects

       Setting Nested Parameters

       Setting Parameters as Attributes

       Retrieving and Removing Action Parameters

       First Steps with the CASTable Object

       Manually Creating a CASTable Object

       CASTable Action Interface

       Setting CASTable Parameters

       Managing Parameters Using the Method Interface

       Managing Parameters Using the Attribute Interface

       Materializing CASTable Parameters

       Conclusion

       Chapter 6: Working with CAS Tables

       Using CASTable Objects like a DataFrame

       CAS Table Introspection

       Computing Simple Statistics

       Creating Plots from CASTable Data

       Exporting CASTables to Other Formats

       Sorting, Data Selection, and Iteration

       Fetching Data with a Sort Order

       Iterating through Columns and Rows

       Techniques for Indexing and Selecting Data

       Data Wrangling on the Fly

       Creating Computed Columns

       BY-Group Processing

       Conclusion

       Chapter 7: Data Exploration and Summary Statistics

       Overview

       Summarizing Continuous Variables

       Descriptive Statistics

       Histograms

       Percentiles

       Correlations

       Summarizing Categorical Variables

       Distinct Counts

       Frequency

       Top K

       Cross Tabulations

       Variable Transformation and Dimension Reduction

       Variable Binning

       Variable Imputation

       Conclusion

       Chapter 8: Modeling Continuous Variables

       Linear Regressions

       Extensions of Ordinary Linear Regression

       Generalized Linear Models