Information, Technology & Consulting

Knowledge Base Search

KB - Search Helper Text

Use the search box to look for specific articles, or use the topic filters to display results that are relevant to a particular subject. Use the "clear filters" button to reset all search terms and filters.

Use the search box to query for articles in the Knowledge Base, or use the categories on the left to narrow down what results you are interested in.

The search found 44 results in 0.015 seconds.

Search results

    Reading and Converting Data to Stata

    Details

    How do I read data from an Excel spreadsheet into Stata?

    Stata Commands

    Details

    General Commands

    • clear - clears data out of memory.
    • search - searches Stata help for matching strings. This allows you to find help on command statements and return codes which appear alongside of error messages. If you make a mistake with a Stata command, it may return an error message along with a return code {for example, r(199)}. The search command can be used to get a more detailed description of the return code.
    • generate - computes a new variable based on an expression.

    Stata Log Files

    Details

    Log files keep a record of the command statements you enter and Stata's output. Specifying a filename saves the log to a file; saving as a log format rather than the default SMCL format will allow you to open the log in other applications (such as Microsoft Word or Notepad).

    A log file can be opened or started in two ways:

    Stata Data Files

    Details

    Stata can read the following filetypes:

    .dta - a data file in Stata format
    .txt - data in ASCII (text) format
    .raw - data in ASCII (text) format
    .xls - a data file in Excel format

    Different command statements are used to load data sets in different file formats. Most commonly you'll issue the use command to read Stata formatted data sets.

Pages

Close
Information, Technology & Consulting