Information about my dataset: I have three variables in my Stata dataset. "country" which has 20 country names, "period" which has years( in this format, 2010-03-31) and "value" which has values of FDI. The FDI values are quarterly given for each country, and I have 10 years of data. From just looking, I can see that Q1 values are the same as Q4. And the country name repeats after each quarter values.
Help: I want to create a line graph to see the growth of FDI for all the country for comparison, but I am having issues with changing the format of the date and dublicate values for Q1 and Q4. How can I plot the graph effectively here? Should I turn Q1,Q2,Q3,Q4 into one values as an indication for one year? How do I do that? Any other suggestions with the codes would be really appreciated! ChatGPT4 could not help to be honest.
Thank you for the help in advance!
Help: I want to create a line graph to see the growth of FDI for all the country for comparison, but I am having issues with changing the format of the date and dublicate values for Q1 and Q4. How can I plot the graph effectively here? Should I turn Q1,Q2,Q3,Q4 into one values as an indication for one year? How do I do that? Any other suggestions with the codes would be really appreciated! ChatGPT4 could not help to be honest.
Thank you for the help in advance!
Comment