1 item has been added to your cart.

Importing/exporting data

• Import and export data from Excel .xls and .xlsx files
• Import and export CSV and delimited data
• 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 from Haver Analytics Cloud servers New
• Import data from Wharton Research Data Services (WRDS) via JDBC
• 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
• Export data to SPSS New

JDBC support

• 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
• Import data using GUI New

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
• Pinnable rows and columns New
• Resizable cell editor for string data New
• Tool tips for truncated text New
• Proportional width font supportNew
• Columns can be resized and are preserved when saving the dataset
• Show variable labels in column header New
• Keyboard shortcut for hiding and showing value labels New

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 Updated
• Advanced regular expression functions New
• Date and time functions Updated
• Durations, relative dates, datetime components
• Week-related functions New
• 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.

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