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
- Introduction to the DATA step: Reading from and writing to external files
- Introduction to the DATA step: Reading from and writing to databases
- Introduction to the DATA step
- Introduction to the DATA step statements
- Stored compiled DATA steps
- DATA step views
Workflow
- Creating new custom variables in a Workflow
- Using the Deduplicate block to remove duplicate rows from a dataset
- Using the Text Transform block to manipulate a variable in a dataset
- Workflow: Importing data from Microsoft Excel
- Workflow: Importing data from a text file
- Workflow: Importing data from a permanent dataset
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
- Coding perspective: Connecting to an IBM Spectrum LSF cluster
- Installing the Snowflake SnowSQL utility on Linux
- Connecting to a Snowflake database from WPS Analytics on Linux
- Installing the Snowflake SnowSQL utility on Windows
- Connecting to a Snowflake database from WPS Analytics on Windows
- Connecting to an Oracle database from WPS Analytics on Windows