The available methods include 'ADDWINTERS', 'BEST', 'BESTN', 'BESTS', 'DAMPTREND', 'DOUBLE', 'LINEAR', 'MULTSEASONAL', 'SEASONAL', 'SIMPLE', and 'WINTERS'. The default is 'BEST'....
You can use the 'nThreads' parameter to specify the number of threads used per worker node. Setting it to 0 uses the maximum number of licensed cores....
The 'outFor' table contains the forecast time series components, including actual values, predicted values, lower and upper confidence limits, prediction errors, and prediction standard errors....
The 'sMethod' parameter accepts 'RMSDF' (weighted root mean square), 'SMVLUE' (minimum variance linear unbiased estimate), or 'SNOWEIGHT' (unweighted estimate). The default is 'SNOWEIGHT'....
The action can generate a 'chartsTable' (charts summary), an 'outLimitsTable' (control limits), and other tables specified in the 'outputTables' parameter....
You can use the 'validateOnly' parameter. When set to TRUE, it validates the query syntax and returns without executing the query. The default value is FALSE....
You can use the 'method' parameter (set to TRUE) to print a brief description of the query plan, or the 'showPlan' parameter (set to TRUE) to print an XML tree representing the query plan....
You can use the 'cntl' parameter list and set 'requireFullPassThrough' to TRUE. This stops processing if FedSQL implicit pass-through of the full query cannot be achieved, preventing data loading into CAS....
In the 'cntl' parameter, you can set 'optimizeVarcharPrecision' or 'optimizeVarbinaryPrecision' to TRUE. This optimizes the precision to be appropriate for the actual data instead of using the declared precision....
Yes, by setting 'preserveJoinOrder' to TRUE in the 'cntl' parameter, you can force the tables to be joined in the specified order instead of the order chosen by the FedSQL query optimizer....
You can set the 'showStages' parameter to TRUE (either as a top-level parameter or within the 'cntl' list) to print a brief description of FedSQL query plans along with details of query execution....
The 'rangeWindowLength' parameter is required to specify the window length used for the range calculation. It accepts a 64-bit integer with a minimum value of 1....
Yes, you can use the 'casOut' parameter to specify the output table settings, such as the table name and caslib, to store the expected range values....
The 'expectedRangeWindowLength' parameter is a required 64-bit integer (minimum 1) that specifies the window length for the expected range calculation....
It specifies the distinct count limit. If this limit is exceeded and the misraGries parameter is set to True, the Misra-Gries frequency sketch algorithm is used to estimate the frequency distribution. The default value is 10000....
When set to True (which is the default), the misraGries parameter enables the use of the Misra-Gries algorithm for frequency distribution estimation if the distinct count limit is exceeded....
The available statistics are ENTROPY, MI (Mutual Information, default), NORMMI (Normalized Mutual Information), PEARSON, and SU (Symmetric Uncertainty)....
When set to True, the singlePass parameter prevents the creation of a transient table on the server. This can be efficient, but the data might not have stable ordering upon repeated runs. The default is FALSE....
The casOut parameter specifies the CAS table where the analysis results will be stored. It can include options such as the caslib, index variables, lifetime, memory format, name, promote status, replace status, and table redistribution policy....
SAS and all other SAS Institute Inc. product or service names are registered trademarks or trademarks of SAS Institute Inc. in the USA and other countries. ® indicates USA registration. WeAreCAS is an independent community site and is not affiliated with SAS Institute Inc.
This site uses technical and analytical cookies to improve your experience.
Read more.