The starting point for your SAS® and Viya™ projects
Discover technical articles from the community
Snippets & Tutorials
FAQ & Help
Business Use Cases
Full Catalog & Examples
Preparation Scripts
SAS & Python Integration
News, tech watch and site updates
Participate in the life of the site
Provides an action for performing variable clustering and providing undirected n...
Generates histogram bins and simple bin-based statistics for numeric variables....
The addTable action is a fundamental mechanism for transferring data from a clie...
The required parameters are 'fmtLibName', which specifies the format library name, and 'table', which specifies the settings for the input table.
You can use the `pred`, `resid`, `lcl` (lower credible limit), and `ucl` (upper credible limit) parameters to name the respective output statistics columns.
use the standard memory format.
Specifies the forecast input table for this level of the hierarchy. Alias: inputTable. The castable value can be one or more of the following: - caslib (string): Specifies the caslib for the input table. By default, the active caslib is used. - computedOnDemand (TRUE | FALSE, Default: FALSE): When set to True, creates the computed variables when the table is loaded instead of when the action begins. Alias: compOnDemand. - computedVars (casinvardesc): Specifies the names of the computed variables to create. Specify an expression for each variable in the computedVarsProgram parameter. Alias: compVars. - computedVarsProgram (string): Specifies an expression for each computed variable that you include in the computedVars parameter. Alias: compPgm. - dataSourceOptions (key-1=any-list-or-data-type-1): Specifies data source options. Aliases: options, dataSource. - groupByMode ("NOSORT" | "REDISTRIBUTE", Default: NOSORT): Specifies how to create groups. "NOSORT" groups data without sorting on each machine, then groups again on controller. "REDISTRIBUTE" transfers rows between nodes, guaranteeing ordering but is slower. - importOptions: Specifies the settings for reading a table from a data source. Alias: import. - name (table-name): Specifies the name of the input table. - singlePass (TRUE | FALSE, Default: FALSE): When set to True, does not create a transient table on the server. Can be efficient, but data might not have stable ordering upon repeated runs. - vars (casinvardesc): Specifies the variables to use in the action. - where (where-expression): Specifies an expression for subsetting the input data. - whereTable (groupbytable): Specifies an input table that contains rows to use as a WHERE filter.
Model selection is performed using the selection parameter, which accepts a selectionStatement structure. This includes options for method, candidates, choose, details, elasticNetOptions, fast, hierarchy, kappa, maxEffects, maxSteps, minEffects, orderSelect, plots, relaxed, select, slEntry, slStay, stop, and stopHorizon.