Knowledge base
Workbench videos
- Coding perspective: Introduction to the coding environment
- Workflow perspective: Introduction to the workflow environment 🎥
- Coding perspective: Project tools
- Coding perspective: Code analysis
- Coding perspective: Code execution
- Coding perspective: Code templates and injection
Coding
- Stored compiled DATA steps
- DATA step views
- Introduction to the LIBNAME statement: SAS language libraries
- The LIBNAME statement: Specifying a database server or workbook
- Using ODS absolute layouts to create side-by-side text blocks
- Using the ODS REGION statement to place items on a page
Workflow
- Workflow: Importing data from Microsoft Excel
- Workflow: Importing data from a text file
- Workflow: Importing data from a permanent dataset
- Workflow: Creating dataset statistics using the Aggregate block
- Workflow: Grouping observations using the Binning block
- Workflow: Reducing the size of a dataset using the Filter block
Installation
- Applying a licence key using WPS Workbench
- Applying a licence key using the command line on Linux
- Applying a licence key using the command line on macOS
- Installing the WPS Analytics Jupyter kernel (macOS)
- Obtaining a WPS Analytics licence key
- Installing WPS Analytics on Windows
Databases
- Connecting to an Oracle database from WPS Analytics on Windows
- Connecting to an Oracle database from WPS Analytics on Linux
- Connecting to an SQL Server database from WPS Analytics on Windows
- Connecting to an SQL Server database from WPS Analytics on Linux
- Connecting to a DB2 database from WPS Analytics on Windows
- Connecting to a MySQL database from WPS Analytics on Windows