Good evening,
I just downloaded a dataset containing over a million observations and more than 60 variables. I am currently using Stata SE 16.1. I have two issues that I haven't been able to resolve. Firstly, I have several variable with dates. I have imported the file as a .CVS. Once I do so, the dataset converts the date variables into string variables. I have used the command date(string, td%) and format %tdMDY in order to convert them. It is not working. Could someone help me? I believe the reason it is not working is because I have two formats for the dates in the same variable (that is how the dataset comes), M/D/YY or M/D/YYYY. Could I fix it?
The second problem I have is that I have a variable that contains prices. But the variable price was imported as a string variable. I tried to use the command destring(str1), gen(Price). But it is not working. I believe it is because the variable has commas. It appears as for example 17,567,289 or 1,254, etc... Could someone help me fix it?
I tried to do it before in Excel but the dataset is too large for Excel to handle and when I tried to import it to Stata it didn't allow me. I also used Numbers, but it takes to long to format the variable (I have been doing it for over 10 hours and it seems the app is not responding anymore). Even if I manage to do so in Excel, I cannot copy and paste as the memory use is too great.
I would really appreciate if someone could help me.
Thanks
Related Posts with String Variables to Numeric
Difference in months between dates in year-month formatHi, I am a beginner in learning stata. I have data where I have a column for month in numbers 1 to …
Wide to Long Reshaping Hi all, I have data in the following format: Code: * Example generated by -dataex-. For mo…
Struggling with hbarI've been working to finalize my code for a figure, and I'm struggling to be able to see the entiret…
keeping observation with lowest value and get the median of thatHello, I have a panel data and I want to keep the observation with the minimum value of Days for eac…
Transpose between row and columnHi all, I know there are lots of posts about transpose, but I still find troubles with my table. I h…
Subscribe to:
Post Comments (Atom)
0 Response to String Variables to Numeric
Post a Comment