Importing/exporting data

• Import and export data from Excel .xls and .xlsx files
• Import and export CSV and delimited data Updated
• Copy/paste data from spreadsheets
• Input data in spreadsheet editor
• Read from and write to SQL sources with ODBC (see below)
• Import and export fixed-format data using a dictionary
• Import and export any type of text data
• Unicode (UTF-8) support, including conversion from/to extended ASCII
• Import EBCDIC data and convert EBCDIC to ASCII
• Import SAS files
• Import SPSS files
• Import and export data in the format required by the FDA for NDA submittals
• Import and export SAS Transport XPORT files
• Import Federal Reserve Economic Data
• Import from Haver Analytics databases
• Import data from Wharton Research Data Services (WRDS) via ODBC
• Import and export dBase files
• High-level import/export of full Excel worksheets
• Low-level cell-by-cell access to write results to and read data from Excel, including graphs, formulas, date formats, currency formats, bold, italics, and more Updated

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