Cross Sectional Data Analysis

[Haile Girma]

How can I formulate a spreadsheet from cross-sectional data that is compatible for analysis by STATA?

Regards.

[George Ford]

variables names on top row.

import excel using datafile.xlsx, firstrow clear

[Haile Girma]

The file is here below, but when I insert it in STATA it is unrecocnized. So, is there any solution?
the title is "determinants of migration"

Regards.

[George Ford]

I can import it and looks exactly like the spreadsheet.

The data is a mess with strings for the first few variables. You'd have to clean that up.

If the data you have comes in that format, then you're better cleaning it in STATA so there's a full record.

[Haile Girma]

Ok, Thanks!

[George Ford]

import excel using "cause of migration.xlsx", firstrow clear