>> Home >> Products >> Features >> Data management
Order Stata

Data management

Importing/exporting data

  • Import and export data from Excel .xls and .xlsx files Updated
  • 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) Updated
  • Import and export fixed-format data using a dictionary
  • Import and export any type of text data Updated
  • Unicode (UTF-8) support, including conversion from/to extended ASCII Updated
  • Import EBCDIC data and convert EBCDIC to ASCII
  • Import and export data in the format required by the FDA for NDA submittals
  • Import and export SAS Transport XPORT files
  • Import from Haver Analytics databases
  • Import and export XML-formatted data files, including those produced by Microsoft Excel
  • 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
  • Programmatic access to create Word documents

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 New

Built-in spreadsheet editor Updated

  • 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 Updated

  • Change storage types, names, and formats
  • Add and edit value labels
  • Attach notes to variables
  • Filter variables
  • For Windows , Mac , and Unix


  • Statistical functions Updated
  • Mathematical functions
  • Trigonometric functions
  • String functions Updated
  • Unicode functions New
  • Regular expressions
  • Date and time functions
  • Time-series functions
  • Random-number functions Updated
  • Matrix functions
  • Programming functions Updated

Data reorganization

  • Row–column transposition
  • Data reshaping
  • Stacking of variables
  • Collapsing into means, totals, etc.

Unicode support New

  • UTF-8
  • Translation of extended ASCII to UTF-8
  • Unicode-aware string functions
  • Locale-based sorting and string comparison


  • 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 Updated


  • Extensive notes can be attached to a dataset

Data snapshots

  • Allow multiple levels of undo to modified datasets

Automatic memory management


  • Ascending or descending sorts
  • Multiple-key sorts
  • Numeric and string sorts
  • Locale-aware Unicode string sorting and comparison New

Combining datasets

  • Merge datasets
    • By key variables
    • By observations
  • Join datasets
  • Outer join
  • Append datasets
  • Append time series

Special datasets

PDF and image output

  • Export results to PDF files on Windows, Mac, and Unix Updated
  • Export results to PostScript files
  • Save graphs as PDFs on Windows, Mac, and Unix Updated
  • Save graphs to EPS or TIF files for publication
  • Save graphs to PNG files for the web


  • Compress (make dataset as small as possible without loss of accuracy)
  • Count number of observations that satisify specified conditions
  • Formatted and unformatted disk I/O
  • Zip-file support
  • Unicode conversion from/to extended ASCII New
  • Custom filters to manipulate text files

Variable management

  • Generation of new variables
  • Replacement of existing variables
  • Renaming variables
  • Encoding and decoding string variables
  • Reordering variables in dataset

Dataset utilities

  • Flexible description of variables, labels, and types
  • List values of variables
  • Data signatures to verify the integrity of datasets
  • Codebooks for variables
  • Value-label reports
  • Duplicates and missing values tables

Variable types

  • Numeric storage types
    • Byte
    • Integer (int)
    • Long
    • Float
    • Double
  • String (including Unicode, very long strings and BLOBs) Updated
  • Dates and times
  • Business calendars

Long string support

  • Up to 2 billion character long strings
  • Coalescing of duplicate values to save memory
  • Binary 'strings' (BLOBs)
  • Import and export entire files into long strings/BLOBs
  • Unicode (UTF-8) strings New

Stored results

  • Save results to disk for later use
  • Store estimation results in memory
  • Create tables to compare results

Additional resources

See New in Stata 14 for more about what was added in Stata 14.





The Stata Blog: Not Elsewhere Classified Find us on Facebook Follow us on Twitter LinkedIn Google+ YouTube
© Copyright 1996–2017 StataCorp LLC   •   Terms of use   •   Privacy   •   Contact us