tab not producing even lines after importing data from excel

[Forrest Owens]

Hello, I imported an excel data sheet into stata and everything looks fine except when I tab on countries. For some reason about a third of the way down, tab produces uneven lines and I'm not sure if this will cause a significant issue in my data. If it helps, there are 197 observations. An example of the issue is below

[Clyde Schechter]

It appears that there is, indeed, something wrong with the data. But it is hard to tell what that might be from the -tab- output. Better is to show an example of the Stata data set itself. Use the -dataex- command to do that. (Do not make up a table you type in, and above all, do not show a screenshot for this.) If you are running version 17, 16 or a fully updated version 15.1 or 14.2, -dataex- is already part of your official Stata installation. If not, run -ssc install dataex- to get it. Either way, run -help dataex- to read the simple instructions for using it. -dataex- will save you time; it is easier and quicker than typing out tables. It includes complete information about aspects of the data that are often critical to answering your question but cannot be seen from tabular displays or screenshots. It also makes it possible for those who want to help you to create a faithful representation of your example to try out their code, which in turn makes it more likely that their answer will actually work in your data.

In this case, it probably also will help if you post a screenshot of the Excel file from which this data was imported. In doing that, I recommend that when you take the screenshot, you have the cell containing the name of the country that is between Costa Rica and Croatia highlighted, and be sure the screenshot goes all the way up to the toolbar.