This is my command:
Code:
import excel "/Users/salmanouh/Desktop/New_excel.xlsx", sheet("Sheet1") firstrow allstring clear
input str23 indid
"1812010001101"
"1812010002101"
"18120100021_180201"
"18120100021_180202"
"18120100021_180203"
"18120100021_180301"
"18120100021_180302"
"18120100021_180303"
"18120100021_180304"
"1812010003101"
"1812010003102"
"1812010003103"
"1812010003104"
"1812010004101"
"1812010004102"
"1812010004103"
"1812010004104"
"1812010004105"
"18120100041_180301"
"18120100041_180302"
"1812010005101"
"1812010005102"
"1812010005103"
"1812010005104"
"1812010005105"
"1812010006101"
"1812010006102"
"1812010006103"
"1812010006104"
"1812010006105"
"1812010006106"
"1812010006107"
"1812010006108"
"1812010006109"
"1812010006110"
"1812010006111"
"1812010008101"
"1812010008102"
"1812010008103"
"1812010008104"
"1812010009101"
"1812010009102"
"18120100091_180301"
"18120100091_180302"
"18120100091_180303"
"1812010010101"
"1812010010102"
"1812010010103"
"1812010010104"
"1812010010105"
"1812010010106"
"1812010011101"
"1812010011102"
"1812010011103"
"1812010011104"
"1812010011105"
"1812010012101"
"1812010012102"
"1812010012103"
"1812010012104"
"1812010013101"
"1812010013102"
"1812010013103"
"1812010013104"
"1812010013105"
"1812010013106"
"1812010014101"
"1812010014102"
"1812010014103"
"1812010014104"
"1812010014105"
"1812010015101"
"1812010015102"
"1812010015103"
"1812010015104"
"1812010017101"
"1812010017102"
"1812010017103"
"18120100171_180301"
"18120100171_180302"
"18120100171_180303"
"18120100171_180501"
"18120100171_180502"
"18120100171_180503"
"18120100171_180504"
"1812010018101"
"1812010018102"
"1812010019101"
"1812010019102"
"1812010019103"
"1812010019104"
"1812010019105"
"1812010019106"
"1812010019107"
"1812010024101"
"1812010024102"
"1812010024103"
"1812010024104"
"1812010024105"
"1812010024106"
end
The dataex doesn't show the observations that get rounded up, but in the remaining dataset, I have observations such as 1.81802210360e+16. Does anyone know how to exactly show the individual ID?
0 Response to Problem with individual ID when importing an excel sheet to stata
Post a Comment