Data Management: Data Input and Output

These are features of the program operation of importing data into the program and exporting data from LIMDEP to other programs - the read (import) and write (export) operations. You can also transform and examine the data within the program.

Read (import data)

  • ASCII, XLS, WKS, binary, DIF, CSV
  • LIMDEP is supported by DBMS/Copy and Stat/Transfer
  • Merge individual and group level data in a panel data set
  • Recode alphanumeric data to numeric values on input
  • Observation labels in spreadsheet files
  • Up to 3,000,000 observations
  • Blanks and other nonnumerics automatically converted to missing values
  • SAS ‘.’ automatically converted to missing values
  • Merge data with command files for scripts
  • Fortran formatted
  • Append observations to existing variables (stack multiple files)
  • Format by observations (rows) or by variables (columns) - transpose

Write (export data)

  • ASCII
  • CSV (can be read directly into Excel, Lotus)
  • DIF
  • Binary
  • WKS
  • LIMDEP system files can be read by Stat/Transfer and DBMS/Copy
  • Matrices may be written as exported data files

Spreadsheet style data editor

Transformations: algebraic, recoding, sorting, existing or new variables

Random number generators for random sampling

List observations

Sample selection and definition: include, reject, sample

Read from and write to output window on the screen