In Stata, how do I import a fixed-format ASCII file?

The Stata .infix command reads an ASCII file in fixed format. You need to specify column locations of data items and/or data types, for example:

  . infix id 1-4 str name 5-19 byte male 20 stat 21-25 using class.txt

Stata reads a float variable id from columns 1 through 4, a string variable name from columns 5 through 19, a byte variable male at column 20, and a float variable stat from columns 21 through 25.

Alternatively, you may write a data dictionary file (ASCII text format), class.dct, as follows:

  infix dictionary using class.txt {
       float    id      1-4
       str      name    5-19
       byte     male    20-20
       float    stat    21-25
}

Then, run the .infix command with the dictionary file.

  . infix using class.dct

If you have questions about using statistical and mathematical software at Indiana University, contact Research Analytics. Research Analytics is located on the IU Bloomington campus at Woodburn Hall 200; staff are available for consultation Monday-Friday 9am-noon and by appointment.

This is document arkl in the Knowledge Base.
Last modified on 2015-06-23 00:00:00.

Contact us

For help or to comment, email the UITS Support Center.