Importing/exporting data

JDBC support
New
- Import data from Oracle, Microsoft SQL Server, MySQL, Amazon Redshift,
Snowflake, and other databases
- Export data to an existing database table
- Execute SQL statements on a database
- Create data source names to store connection settings
- Support for CLOBs, BLOBs, and Unicode
ODBC support 
- Import data from any ODBC data source, such as Oracle, SQL Server, Access,
Excel, MySQL, and DB2
- Export data to new or existing ODBC tables
- Execute custom SQL commands individually or in batches
- Customize ODBC connection strings
- Support for ODBC
- Support for VARCHARs/CLOBs and BLOBs
- Support for Unicode
Built-in spreadsheet editor
- Clipboard Preview Tool lets you control how data will be pasted
- Manage variables with the Variables Tool
- For Windows
, Mac
, and Unix 
Properties window
- Manage variables
- Manage dataset properties
- For Windows
, Mac
, and Unix 
Variables Manager
- Change storage types, names, and formats
- Add and edit value labels
- Attach notes to variables
- Filter variables
- For Windows
, Mac
, and Unix 
Functions 
- Statistical functions
- Mathematical functions

- Trigonometric functions

- String functions
- Unicode functions
- Regular expressions

- Date and time functions
Updated
- Time-series functions

- Random-number functions
- 18 functions
- Stream random numbers
- Matrix functions

- Programming functions
Data reorganization
- Row–column transposition

- Data reshaping

- Stacking of variables

- Collapsing into means, totals, etc.
Updated
Unicode support
- UTF-8
- Translation of extended ASCII to UTF-8

- Unicode-aware string functions

- Locale-based sorting and string comparison

Labels 
- Dataset labels
- Variable labels
- Value labels (e.g., male and female for 0 and 1)
- Ability to switch between multiple sets of data, variable, and value labels
- Missing-value labels
- Support for multiple languages, including Unicode support
Notes 
- Extensive notes can be attached to a dataset
Data snapshots 
- Allow multiple levels of undo to modified datasets
See New in Stata 17 to learn about what was added in Stata 17.