SPSS Reporting and “OLAP cubes”

Here we list our experience with the Reports tab in SPSS: From SPSS > Choose Analyze > Reporting > OLAP Cube: Choose the continuous and grouping variables as follows, and choose the statistical ( summary) functions for each continuous variable, default is SUM: Result will be as follows: Unfortunately nothing like the Excel pivot tables.[…]

SAS Regresesion Analysis

SAS provides the capability to build regression models to analyze ordinal data correlations and use this model to predict out-of-sample values. Here is the process: Open SAS Studio > Go Tasks > Linear Regression > the following window will open: Input Data settings: Model settings: One can add simple variables to the indepedent variables set.[…]

SAS: Using Differencing for ARIMA

Data Differencing is achieved by creating a new series which is D = Yt – Y[t-1]. Differencing aims at removing the non-stationarity in the time series, a pre-requisite for using ARIMA models against a time series. Here we explore the configuration of differencing and its impact on ACF and PACF: ARIMA configuration with D=0 Configuration[…]

SAS: Table Analysis

This feature enables creating whats known as Pivot tables. From SAS studio, select Statistics > Table Analysis. From Data Tab: From Data section: choose your table. Roles section: Choose the attributes you want to show in your pivot table rows and columns. Strata Variables section: choose the measures to put in the values section. Options[…]