10/27/2023 0 Comments Import data from excel to stata 13![]() I expect if you review the original data that was imported into Excel, you will see that the ids that end in three digits do not all end in three zeros. It appears that when your data was imported into Excel, Excel was not instructed to import the id as a string (which should always be used for "numbers" that are not meant for arithmetic operations) and instead, when Excel detected a number, did the best it could, which apparently was to import the leftmost 15 digits correctly and then (effectively) multiply it by 10 3 to get it to the right order of magnitude. Note that the string however ends "05X" which suggests that perhaps some of the numeric values may also have had digits other than 0 in characters 16-18. ![]() ![]() For more info, type help dataexġ5232419811015005XIn the example data, all of the numeric values are 18 digits long and end in "000".
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |