Dear all,
I am importing data from CSV that comes from ODK into Stata (I tried on 15/IC and 14/IC). I have multiple variables that are numeric but import as string. The issue is, I cannot destring these variables. There appears to be some hidden string, that `strtrim()` or `stritrim()` cannot help. If I use force with destring, they all go missing.
I am attaching a snippet of the data in CSV file which will not destring after importing:
Note that I need the data to import with utf-8 encoding because there are some Arabic/Persian text.
Thanks in advance for your help.
I am importing data from CSV that comes from ODK into Stata (I tried on 15/IC and 14/IC). I have multiple variables that are numeric but import as string. The issue is, I cannot destring these variables. There appears to be some hidden string, that `strtrim()` or `stritrim()` cannot help. If I use force with destring, they all go missing.
I am attaching a snippet of the data in CSV file which will not destring after importing:
Code:
import delimited "~/Downloads/cannot_destring.csv", varnames(1) encoding(utf-8) case(preserve) clear
Thanks in advance for your help.
Comment