Data management | Stata

Stata 19 is here—explore all the features.

Search stata.com

items in cart
Stata/BE network 2-year maintenance

Quantity:

196 Users

Qty: 1

$11,763.00
Subtotal: $0.00

Products

Purchase

Learn

Support

Company

Home / Products / Features / Data management

Order

Data management

See what's new in data management.

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

Watch Import FRED (Import Federal Reserve Economic Data).

Watch Input simple datasets into Stata.
Watch Import datasets from the Internet into Stata.
Watch Import Excel^® data into Stata.
Watch Copy/Paste from Excel^® into Stata.
Watch Importing delimited data.
Watch Export results to Excel^® using Stata.

Watch Import SAS datasets into Stata.
Watch Import data from SPSS and SAS.

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

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

Watch Features in the Data Editor.

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

Watch Label variables.
Watch Label the values of categorical variables.
Watch Change the display format of a variable.
Watch Add notes to a variable.
Watch Change the display format of a variable.

Statistical functions
Mathematical functions
Trigonometric functions
String functions
Unicode functions
Regular expressions

Advanced regular expression functions

Date and time functions

Time-series functions
Random-number functions

18 functions
Stream random numbers

Matrix functions
Programming functions

Watch Round a continuous variable.

Data reorganization

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

Watch Reshape data from wide format to long format.
Watch Reshape data from long format to wide format.

Unicode support

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

Watch Unicode in Stata.

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

Watch Label variables.
Watch Label the values of categorical variables.

Notes

Extensive notes can be attached to a dataset

Watch Add notes to a variable.

Data snapshots

Allow multiple levels of undo to modified datasets

Multiple datasets in memory (frames)

Link frames
Copy data between frames
Access data in other frames
Post simulation results to frame
Manipulate frames
Access frames from Mata
Access frames from Mata
Save, load, describe multiple frames Updated

Watch Working with multiple datasets in memory.
Watch Alias variables across frames.

Read The Stata Blog: Fun with frames.

Automatic memory management

Terabytes of RAM supported
Up to 120,000 variables in Stata/MP; up to 32,767 variables
in Stata/SE
20 billion or more observations in Stata/MP
Up to 2.1 billion observations in Stata/SE and Stata/BE

Sorting

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

Combining datasets

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

Watch How to merge files into a single dataset.
Watch How to append files into a single dataset.

Special datasets

Utilities

Count number of observations that satisfy specified conditions
Formatted and unformatted disk I/O
Zip-file support
Unicode conversion from/to extended ASCII
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
Variables Manager

Watch Create a new variable that is calculated from other variables.
Watch Convert categorical string variables to labeled numeric variables.
Watch Create a categorical variable from a continuous variable.
Watch Convert a string variable to a numeric variable.
Watch Identify and replace unusual data values.
Watch Convert missing value codes to missing values.

Dataset utilities

Flexible description of variables, labels, and types
List values of variables Updated
Data signatures to verify the integrity of datasets
Codebooks for variables
Value-label reports
Duplicates and missing values tables
Compress (make dataset as small as possible without loss of accuracy)

Watch Optimize the storage of variables.
Watch Identify and remove duplicate observations.

Variable types

Numeric storage types

Byte
Integer (int)
Long
Float
Double

String (including Unicode, very long strings and BLOBs)
Dates and times
Business calendars

Watch Create a date variable from a date stored as a string.

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

Stored results

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

Additional resources

See New in Stata 19 to learn about what was added in Stata 19.

Products

New in Stata 19

Why Stata

All features

Disciplines

Stata/MP

StataNow

Order Stata

Purchase

Order Stata

Bookstore

Stata Press

Stata Journal

Gift Shop

Learn

Free webinars

NetCourses

Classroom and web training

Organizational training

Video tutorials

Third-party courses

Web resources

Teaching with Stata

Support

Training

Video tutorials

FAQs

Statalist: The Stata Forum

Resources

Technical support

Customer service

Alerts

Company

Contact us

News and events

Customer service

Careers

Search

×

We use cookies

We use cookies to ensure that we give you the best experience on our website—to enhance site navigation, to analyze usage, and to assist in our marketing efforts. By continuing to use our site, you consent to the storing of cookies on your device and agree to delivery of content, including web fonts and JavaScript, from third party web services.

Cookie Settings

Privacy policy

Last updated: 16 November 2022

StataCorp LLC (StataCorp) strives to provide our users with exceptional products and services. To do so, we must collect personal information from you. This information is necessary to conduct business with our existing and potential customers. We collect and use this information only where we may legally do so. This policy explains what personal information we collect, how we use it, and what rights you have to that information.

Required cookies

Advertising cookies

Required cookies

These cookies are essential for our website to function and do not store any personally identifiable information. These cookies cannot be disabled.
Advertising and performance cookies

This website uses cookies to provide you with a better user experience. A cookie is a small piece of data our website stores on a site visitor's hard drive and accesses each time you visit so we can improve your access to our site, better understand how you use our site, and serve you content that may be of interest to you. For instance, we store a cookie when you log in to our shopping cart so that we can maintain your shopping cart should you not complete checkout. These cookies do not directly store your personal information, but they do support the ability to uniquely identify your internet browser and device.

Please note: Clearing your browser cookies at any time will undo preferences saved here. The option selected here will apply only to the device you are currently using.

Accept Cookies