Post Your Answer

File format needs to be considered while loading data into STATA. Different file formats use different commands to load the data. If the file format is STATA, then you can use the command ‘use’. While using this command the file extension (*.dta) can be omitted.

Vinay, if the file format is fixed format or free format ASCII, then make use of infix and infile version 1 command.

Infile version2, import delimited and import excel is used if the file format is fixed format ASCII with dictionary, text delimited and excel. You can also convert different file formats into STATA file format and then use the command for STATA file format. https://www.stata.com/support/faqs/data-management/converting-excel-files/ This link guides you on how to convert the file format.