I imported an Excel file into Stata, with
"import excel using filename, firstrow clear" (This is the only line of code I have used after setting my working directory. )
The first row of the Excel file contains string values for some variables. Strangely, when I import into Stata, those string values are not being displayed. When I move the keyboard cursor over that column, the text shows up in the text bar of the Stata Data Editor. But the string itself is not being displayed. I have attached a screenshot if it helps.
I apologize for the huge screenshot - I did not find a way to reduce the size. If you scroll to the right, you'll see that the cell content is not being displayed in the cell, but is being displayed above (ABRASIVE MATERIALS, n.e.s.).
Some things I tried:
1. Some rows in the Excel file had "wrap text", so I unwrapped them and tried importing it again. I also updated Stata. The issue remains.
2. There does not seem to be an issue with the Excel file. I imported it into R and these columns were visible with their string contents. But I would prefer to work with it in Stata.
Regards,
Saunok
"import excel using filename, firstrow clear" (This is the only line of code I have used after setting my working directory. )
The first row of the Excel file contains string values for some variables. Strangely, when I import into Stata, those string values are not being displayed. When I move the keyboard cursor over that column, the text shows up in the text bar of the Stata Data Editor. But the string itself is not being displayed. I have attached a screenshot if it helps.
I apologize for the huge screenshot - I did not find a way to reduce the size. If you scroll to the right, you'll see that the cell content is not being displayed in the cell, but is being displayed above (ABRASIVE MATERIALS, n.e.s.).
Some things I tried:
1. Some rows in the Excel file had "wrap text", so I unwrapped them and tried importing it again. I also updated Stata. The issue remains.
2. There does not seem to be an issue with the Excel file. I imported it into R and these columns were visible with their string contents. But I would prefer to work with it in Stata.
Regards,
Saunok
Attached Files
Comment