RUclips recently changed the way my content will be monetised. My channel now needs 1,000 subscribers. So it would be amazing if you show your support by both watching my videos and subscribing to my channel if you haven’t done so already. Monetising my videos allows me to invest back into the channel with some new equipment so this small gesture from you will be extremely huge for me. Many thanks for your support….CrunchEconometrix loves to teach, help me stay online.
Hi Daniel, apologies for my very late response. You can employ the multiple imputation method which has its underlying assumptions. You may need to do a Google search on the procedure. Thanks.
Thank you, Dr. Your guidance helped me pass my dissertation with distinction. I followed your steps for the ARDL regression, and your support was invaluable. I truly appreciate it. God bless you!
First of all, thank you very much. Based on that, I followed the same approach directly in Stata using: drop if missing(CountryName) | missing(CountryCode) | missing(SeriesName) | missing(SeriesCode) egen id_C = group(CountryName) egen id_S = group(SeriesName) foreach var of varlist _all { replace `var' = "" if `var' == ".." } reshape long YR, i(id_C id_S) j(year) drop SeriesName SeriesCode reshape wide YR, i(id_C year) j(id_S)
Yes ooo proudly African, Victor😊. I'm humbled and encouraged by your positive feedback on my videos. Deeply appreciated! 🙏 Please may I know from where (location) you are reaching me?
@@CrunchEconometrix I'm in grad school at an Ivy league school in the US, but born and raised on the motherland. Believe me none of my professors can explain this!
Thanks Paul for your subscription. Deeply appreciated! I will really appreciate if you can help share the link to my RUclips Channel ruclips.net/user/CrunchEconometrix on your SM handles for awareness among my 9ja people and those in your network. Thanks again.
Hahahaha Hassaan, my Channel got you and every researcher out there covered. Good to know that the clip is helpful. Please share this with your cohorts, students and academic community...gracias! :)
@@armstrongasenavi719 Awesome Armstrong...I will appreciate if you can spread the word about my videos to your students and academic community in Kenya 🇰🇪! 💕 😊
Hahahaha Heath, thanks for the positive feedback on my video. Deeply appreciated! 💕 Kindly share my Channel link with your students and academic networks! May I know where you are reaching me from?
CrunchEconometrix I am an international masters student in economics currently studying in Norway. But I am from Pakistan. There’s a few things I need to ask you regarding stata. As I am currently in the process of writing my master thesis.
No problem. Simply post your queries on the comment section of the respective RUclips video for others to benefit from the discussion. I'll do my best to guide. Thanks
@@CrunchEconometrix Hi, I am also facing another issue regarding this video. I am doing an analysis on 20 countries across the world and I have a total of 12 variables and 10 years for each country. I followed all the steps you have listed in the videos but I eventually found a problem as I am missing 2 variables from my data set. Since I only have 10 years and 12 variables, when I go to rename my variables, 2 are missing. How can I fix this?
Greetings, please I have been trying to generate this command =if(B3=B2, A2, A2+1) on Excel but it does not work for me. Please could assist me... I have been doing it manually 😪😪😪
Hi prof Ngozi, i'm trying to import my data from excel to stata, but stata reads my annual time data as strings, please how Can i convert it to numeric data? Thanks in advance
Hi Asante, I have a dofile (DF005) that addresses that but it is available on my website for a token fee. Kindly visit the STORE www.cruncheconometrix.com.ng/shop/ to make the purchase, thanks.
Greetings crunch econometrics. I have an issue at the level of generating the s_id. At the level of inserting the formula it is refusing to apply the formula. What could be the problem. I need help
Can you please tell me how to select only six countries from the 46 countries in Stata? I usually use the filter tool in Excel to select the countries when I download data from the World Bank. But I want to do it in Stata but do not know the code to write. Kindly help. Thank you
I'm strugling with getting my data right. Instead of one variable with longitudinal data I have 11, so I can't put yr in front of the specific year ,since I need to do it for 11 variables. e.g. ENVyr1, SOCyr1
@@CrunchEconometrix yeah if i do that manually im formatting for 12hrs straight. Is there another way via stata, right now my data for 144 companies with a frame of 7 years is as follow: horizontal axes coloms: company, country, year, ESG, ROA, (control variables) vertical axes: year 2014-2020 (listed per company)
May thanks for the insightful videos. Please i would like to find out how to reshape string variables. Again, i would like to find out how to find averages in the long format.
Thank you very much for the video! I have a question: what should be the code in Stata if the date is not written in years , but in months and years, such as 1990/05 or may1990?
I'm not sure if you'll reply or not, but I was wondering if I can not drop series/indicators because I want them to show as columns. Instead can I just use j(series) while reshaping as wide? Thank you !
@@CrunchEconometrix I am trying to get the same results as you but I want the name of the indicators as variables and not yr1 yr2 and so on. Is there a way to do so?
Hi Junaid, I'm wondering why you want to combine QUART and YEAR both defines the time variable in the data. Please watch the clip again and adapt to suit your data pattern.
Hi Atus, due to abuse and unethical conduct datasets used in my videos are no longer free (some are free though) but available on my website upon payment. Here's the link cruncheconometrix.com/view/datashop.php
You are a great teacher. And i have actually enjoyed most of your videos, especially the panel data subject. However, i have one question, How does one solve for the unbalanced panel data problem in stata for different variables involved?
Hi Scora, thanks for the encouraging feedback. Deeply appreciated! Stata works perfectly with unbalanced data. Used several in my publications. Please may I know from where (location) you are reaching me?
@@CrunchEconometrix i am reaching you from South Africa, Cape Town. Also i have followed your Rehape video from excel to stata importation. however, my data is giving me problem with the reshape command. It keeps on saying this "reshape long YR i(idc INDICATORNAME ) j(YEAR) option i() required " how do i rectify this please
I get this error message: "variable id does not uniquely identify the observations Your data are currently wide. You are performing a reshape long. You specified i(s_id c_id) and j(year). In the current wide form, variable s_id c_id should uniquely identify the observations." do you know what to do?
Hi, first of all, I want to thank you for this useful video. I would like to ask a question about the problem I am facing. When I write to command row "reshape long yr, i (c_id s_id) j (year)" , there is no problem. But, when I write to command row "reshape wide yr, i(c_id year) j(s_id)" command, I am getting error that "variable s_id is string; specify string option". How can I solve this problem? Can you help me about this problem? I controlled my dataset and follow your this video's steps many times, but I couldn't solve this problem! If someone help me about this topic, I really will be glad.
Hi Cengiz, I honestly have not experienced this before. Perhaps, the issue is with the s_id column. Click on the Stata error on tips on how to fix it. Thanks.
Thanks for this amazing video. it's my first time using stata and also my first time dealing with panel data . so, I have some question. why have the identifiers been generated for both country and series? does matter or not if used space in the commands? how to forecast a missing obs. using stata?
Thank you for this video! It is quite helpful. Could there be any problem if I decide to extract financial data from bank statements and simply prepare it in a long format/shape without necessarily having it wide and later reshaping to long? Now what happens with the series/variable names, do I have to reshape them to wide to make sense if at all whether I suggested makes sense?
Hi Nyakoe, reshaping from W to L is the format allowed by Stata for panel data analysis. So, if your extraction yields a L-format data, then no need to reshape.
Thanks Doctor, I am blocked at the level of creating identifiers for my series... When I fit in the formula, it doesn't execute, rather it takes it as a text.
Great video and very helpful since I use stata for the first time. I have a similar dataset with countries and series and 3 years. I followe your video step by step but stata says there is an error "variable id does not uniquely identify the observations Your data are currently wide. You are performing a reshape long. You specified i(cid mid) and j(year). In the current wide form, variable cid mid should uniquely identify the observations. Remember this picture: ...." Can you please help me through it cause I dont understand what the problem is?
Hi Hidan, dataset is available upon payment of a token fee on my website cruncheconometrix.com.ng/shop/. But you can always practice along with yours. Thanks!
Thank you so much for that video it helped me a lot, I have a question: If i have dates in the excel format dd/mm/yyyy and I would like to use the day as they are in the same year what would I add as prefix. In the video because your dates where years you added yr do I just need to add d? or day?
Hi Patick, thanks for the positive feedback. Deeply appreciated! Unfortunately I have not tried the code on a different date variant so may not be able to guide appropriately. My sincere apologies. Please may I know from where (location) you are reaching me?
Hi George, thanks for watching my videos, deeply appreciated! Regarding your query, not exactly sure what the error is, but I'll say that you start all over and use my coding structure. Just do as I did.
how i can use the Loop command to rename the multiple year names in one go. For example, we download a GDP of USA for Year 2000 to 2017, then how i can use the loop command to rename the year (2000, 2001, 2002) into (fy2000, fy2001, fy2002) in order to reshape the data. Please guide me.
Prof, would you please guide me that how to enter "Quarterly" data i.e. Each year have 4 quarters, e.g. Q1 2018, Q2 2018, Q3 2018, Q4 2018. For banking level data.
RUclips recently changed the way my content will be monetised. My channel now needs 1,000 subscribers. So it would be amazing if you show your support by both watching my videos and subscribing to my channel if you haven’t done so already. Monetising my videos allows me to invest back into the channel with some new equipment so this small gesture from you will be extremely huge for me. Many thanks for your support….CrunchEconometrix loves to teach, help me stay online.
Hi Daniel, apologies for my very late response. You can employ the multiple imputation method which has its underlying assumptions. You may need to do a Google search on the procedure. Thanks.
Thank you so much! I spent 17 hours last week trying to organize all my data manually, this just saved me
Glad it helped Natalie!
Thank you, Dr. Your guidance helped me pass my dissertation with distinction. I followed your steps for the ARDL regression, and your support was invaluable. I truly appreciate it. God bless you!
Glad it helped! I really appreciate your positive feedback... deeply appreciated! 🥰🙏
This is the first time I am stumbling on a Nigerian doing stata analysis on RUclips. Thank you so much for this.
You are welcome, Erinne. Please may I know from where (location) you are reaching me? Thanks.
This video has been a lifesaver 😭. LITERALLY. THANK YOU SO MUCH!
Glad you find it helpful, Matilda...thanks for your encouraging feedback! 🥰🙏
This is a very useful video to reshape the dataset. Proud of you, professor.
Thanks so much for your encouraging feedback, Doc! 🥰🙏
This just saved my life and honors thesis, THANK YOU SO MUCH!!!!!!
Glad you found this helpful! 🙏
First of all, thank you very much. Based on that, I followed the same approach directly in Stata using:
drop if missing(CountryName) | missing(CountryCode) | missing(SeriesName) | missing(SeriesCode)
egen id_C = group(CountryName)
egen id_S = group(SeriesName)
foreach var of varlist _all {
replace `var' = "" if `var' == ".."
}
reshape long YR, i(id_C id_S) j(year)
drop SeriesName SeriesCode
reshape wide YR, i(id_C year) j(id_S)
U're welcome 🙏
I am highly grateful to you, Professor.
Your video helps me a lot to conduct both my undergraduate research and MSS thesis.
Huge respect for you ❣️
Thanks, Mahinur for your encouraging feedback. Deeply appreciated 🥰🙏
I love that you're from Africa! This is the by far the best videos I've seen on this, thank you so much for the great content!
Yes ooo proudly African, Victor😊. I'm humbled and encouraged by your positive feedback on my videos. Deeply appreciated! 🙏 Please may I know from where (location) you are reaching me?
@@CrunchEconometrix I'm in grad school at an Ivy league school in the US, but born and raised on the motherland. Believe me none of my professors can explain this!
I was struggling with this since 2 days, you just made it very simple and I did it in 10 minutes, thank you so much, lots of love and regards ❤️❤️❤️❤️
Thanks, Manoo for the encouraging feedback. Deeply appreciated! 💗🙏
Subscribed! Thanks alot for your detailed and simple explanations! It also feels awesome hearing these things explained in a Nigerian accent! Thanks
Thanks Paul for your subscription. Deeply appreciated! I will really appreciate if you can help share the link to my RUclips Channel ruclips.net/user/CrunchEconometrix on your SM handles for awareness among my 9ja people and those in your network. Thanks again.
yoo is spent two days sorting my data thanks prof for this yooo am very grateful... from now on i will be using this for my panel data...
U're welcome, Msizi!🥰🙏
I was stuck with getting Series into the wide format for so long. Thank you a ton!
Glad to be of help, Simon!
I'm so grateful for this video. I always refer back to it because it has simplified the process and made things so much easier for me. Thank you!
Thanks Crawford, for the encouraging feedback. May God bless you!!!
this is life-saving. I was doing the manual mess and here I go enjoying the day because of this trick. thanks!
U're welcome, Meney! Kindly tell others too!!!
Thank you for this video and the GMM series. Saved me time and helped my thesis 💐💐
You are welcome, Zoey🥰
wow i'm definitely watching all your videos
Thanks for your encouraging feedback, deeply appreciated! 🥰🙏
You are amazing! You have helped me out so much in both of my thesis. Thank you so much for your insights!!
Happy to help, Matteo! Please tell others too, thanks!
YA'LL DOIN THE LORD'S WORK. TYSM FOR THIS U ARE SAVING MY THESIS!!!
U're so welcome, Punch!
I have been working on this exact problrm for 2 days straight, THANK YOU
Happy to hear this, Gustii! 🥰
Very brilliant and detailed explanation, here is to hoping you carry on!
Thanks David, for the positive feedback and remarks on my video. Deeply appreciated! 😀
Thank you so much for this tutorial. Helps me a lot. God bless you
You are welcome, Kevin. Glad you find this very helpful 🙏🥰
I used quarterly data to test sticky cost (weiss, 2010). I have an osiris database that uses quarter data.
Hi Junaid, that shouldn't be a problem. Follow the same steps to reshape the data and replace "year" with "quart" if "quart" is the time variable.
Thank you very much Prof. this is very important to me.
Thanks so much for your positive feedback, deeply appreciated! ☺
Thank you so much. Love and respect from Beijing China
U're welcome, Rain-Walker...kindly share my RUclips Channel link with your students, friends and academic community in China 🇨🇳. Thanks! 💕 😊
@@CrunchEconometrix Of course, i did. Thank you again.
@@Dr_Shiny Deeply grateful, R-W! 💕 😊
thank you so much professor for your kind and prompt suggestion and reply
My humble pleasure, Debasis. Please may I know from where (location) you are reaching me?
Thank you so much prof for your educative videos. You are doing a good job. very helpful indeed!
Thanks for the good feedback, Morris...deeply appreciated! 💕 Kindly share my videos with your friends and academic community😊
This video saved me!! Thank you so much for posting :)
Thanks for the encouraging feedback, Jovana. Deeply appreciated! Please may I know from where (location) you are reaching me?
CrunchEconometrix I’m from Canada!🇨🇦😊
This is great! Thanks! Coming from a Jamaican!
Awesome and thanks, Alvin! Kindly share my RUclips Channel link with your students, friends and academic community in Jamaica 🇯🇲! 💕 😊
Thank you soo much Prof. i was exactly looking for this. stay blessed...
Hahahaha Hassaan, my Channel got you and every researcher out there covered. Good to know that the clip is helpful. Please share this with your cohorts, students and academic community...gracias! :)
Thanks you for your help, it's very fantastic. That's just intelligent work.
Thanks, Pham for the encouraging feedback. Deeply appreciated!
You're literally amazing cheers crunch haha
Thanks for the positive feedback, Rowan...appreciated!
Thank you so much for making this video, I do learn alot from this. :-)
Hi Hai, thanks for the encouraging feedback. Deeply appreciated! Please may I know from where (location) you are reaching me?
Thanks for this tutorial! It saved me lots of time.
I'm encouraged by your feedback, Armstrong...love ya!!! May I know from where (location) you are reaching me?
@@CrunchEconometrix Nairobi, Kenya
@@armstrongasenavi719 Awesome Armstrong...I will appreciate if you can spread the word about my videos to your students and academic community in Kenya 🇰🇪! 💕 😊
Thanks man.. you are a saviour..
U're welcome, Bhaloo! 🥰🙏
Great help. Thanks a lot
You are welcome, Sir.
Very helpful. Thank you so much
You're very welcome, Sir!
Nice explanation ,would you mind making video making aranging pannel data only using excell nto through Stata?
I have a video on BUILDING A PANEL DATA.
Thank you, this is really helpful!
Thanks for the encouraging feedback, Avesta!
In case you really download WDI/World Bank data, you can actually define how you wanna have the data - you find that under "Layout"
That's correct, Julian. Thanks
Thank you so much, this is incredibly helpful!!
U're welcome, Hanna...may I know from where (location) you are reaching me?
Currently I'm studying in the Netherlands :)
My love to all Netherlanders...please tell your students, colleagues and academic community about my YT Channel!😍
Thank you so much! Your video really help
You're welcome, Miriam!
really very helpful
Thanks Muhd, for the encouraging feedback... deeply appreciated!
Brilliant! Thank you!
Hahahaha Heath, thanks for the positive feedback on my video. Deeply appreciated! 💕 Kindly share my Channel link with your students and academic networks! May I know where you are reaching me from?
Very helpful, thanx!
You are welcome, Diogo!
Thanks! Very helpful :)
Glad it helped, Markus!
God Bless you professor
You too, Big Boss!!! Please may I know from where (location) you are reaching me?
CrunchEconometrix I am an international masters student in economics currently studying in Norway. But I am from Pakistan. There’s a few things I need to ask you regarding stata. As I am currently in the process of writing my master thesis.
No problem. Simply post your queries on the comment section of the respective RUclips video for others to benefit from the discussion. I'll do my best to guide. Thanks
@@CrunchEconometrix Hi, I am also facing another issue regarding this video. I am doing an analysis on 20 countries across the world and I have a total of 12 variables and 10 years for each country. I followed all the steps you have listed in the videos but I eventually found a problem as I am missing 2 variables from my data set. Since I only have 10 years and 12 variables, when I go to rename my variables, 2 are missing. How can I fix this?
@@diamonddogsgaming7059 I believe that you were able to get this sorted. Well done! 👏🏽
Thank you very much. Is there a way to download this data in the Stata form? Have you uploaded it?
You are welcome, Anais... but the answer is no.
How to do monthly data? I tried to do analogically but my months are not in chronological order in stata
You should sort out your monthly data in Excel before importing to Stata to reshape.
thank! . this is awesome!
U're welcome 😊...glad to be of help! May I know from where (location) you are reaching me?
U're welcome 😊...glad to be of help! May I know from where (location) you are reaching me?
Greetings, please I have been trying to generate this command =if(B3=B2, A2, A2+1) on Excel but it does not work for me.
Please could assist me... I have been doing it manually 😪😪😪
Hi Micheal, the excel syntax works if your data is properly sorted and without errors.
Hi prof Ngozi, i'm trying to import my data from excel to stata, but stata reads my annual time data as strings, please how Can i convert it to numeric data? Thanks in advance
Hi Asante, I have a dofile (DF005) that addresses that but it is available on my website for a token fee. Kindly visit the STORE
www.cruncheconometrix.com.ng/shop/ to make the purchase, thanks.
@@CrunchEconometrix thanks very much
Greetings crunch econometrics. I have an issue at the level of generating the s_id.
At the level of inserting the formula it is refusing to apply the formula.
What could be the problem. I need help
Hi Samuel, if there are errors within your data, the code won't work. You should sort your variables first, then use the EXCEL formula.
Can you please tell me how to select only six countries from the 46 countries in Stata? I usually use the filter tool in Excel to select the countries when I download data from the World Bank. But I want to do it in Stata but do not know the code to write. Kindly help. Thank you
Dino, do it in excel.
Good video and very helpful , please can you do a video on missen data estimation ? Notably by imputation. Thanks
I'll do my best to do that video, Asante. Thanks for watching my videos...keep sharing too for more awareness😀
Thank you very much. You are doing an outstanding job.
would you please post a video on how to get data from IMF and World Bank
Thanks Thomas for the positive feedback...deeply appreciated! I will log this request and do a video on it. Thanks!
whenever I try to export my excel data to stata it shows the "unexpected attribute" and can not load the excel sheet, please advise.
Nasir, I honestly have no idea what the issue could be. You may want to check the underlying excel sheet for errors before importing to Stata.
I'm strugling with getting my data right. Instead of one variable with longitudinal data I have 11, so I can't put yr in front of the specific year ,since I need to do it for 11 variables. e.g. ENVyr1, SOCyr1
Jari, ensure your excel format is the same as mine.
@@CrunchEconometrix yeah if i do that manually im formatting for 12hrs straight. Is there another way via stata, right now my data for 144 companies with a frame of 7 years is as follow:
horizontal axes coloms: company, country, year, ESG, ROA, (control variables)
vertical axes: year 2014-2020 (listed per company)
Jari, it is advisable to download the data in the appropriate excel format before reshaping in Stata.
@@CrunchEconometrix I used Refinitiv workspace, according the refinitiv support service of our university I can only extra it via excel in one format.
Thanks so much for the tutorial. Is there a continuation?
Thanks for the positive feedback, Cyril. Deeply appreciated! This is a standalone clip. Kind regards.
Thanks please how can I upload my half year data to Stata.
Hi Fatima, same way you upload any data.
May thanks for the insightful videos. Please i would like to find out how to reshape string variables. Again, i would like to find out how to find averages in the long format.
Have you tried out this procedure to reshape your string data? I don't quite understand the 2nd query?
Thank you very much for the video! I have a question: what should be the code in Stata if the date is not written in years , but in months and years, such as 1990/05 or may1990?
Hi Lligramm, please what code are you referring to?
I'm not sure if you'll reply or not, but I was wondering if I can not drop series/indicators because I want them to show as columns. Instead can I just use j(series) while reshaping as wide? Thank you !
I don't quite get what you're trying to do, but you can try out your suggestion.
@@CrunchEconometrix I am trying to get the same results as you but I want the name of the indicators as variables and not yr1 yr2 and so on. Is there a way to do so?
Rename the variables
It is great video. How if I use quarter data Sir? I look in stata quarter symbol is quart, but I can't combain quater and year. Please help me Sir
Hi Junaid, I'm wondering why you want to combine QUART and YEAR both defines the time variable in the data. Please watch the clip again and adapt to suit your data pattern.
Thank you Prof
U're welcome, Darcy😊
Thank You!
You are welcome, Esayas!🥰🙏
A nice video, the URL for your dataset is not opening, will you kindly help.
Hi Atus, due to abuse and unethical conduct datasets used in my videos are no longer free (some are free though) but available on my website upon payment. Here's the link cruncheconometrix.com/view/datashop.php
I have too much dates on the first row for this as I have daily data instead of yearly, so State gives an error. Any suggestions?
Hi Patrick, click on the error code and follow the guide on how to fix the problem.
I love you. Really.
Hahahhaha Paul, love you too for enjoying my video. Deeply grateful. May I know from where (location) you are reaching me?
CrunchEconometrix Burmese in Hong Kong. I had a hard time transferring data to Stata. Thx to you. I can move to other things.
@@paulluhan Good to know Paul...I will greatly appreciate if you share my YT Channel link with your students and academic community. Thanks!
CrunchEconometrix sure. I am still an undergraduate student.
Hello! What if it’s one country, is an id needed? If yes, how to go about it please?
No.
@@CrunchEconometrix thank you
The biggest LIKE
Appreciated, Ayman... thanks! 🙏
You are a great teacher. And i have actually enjoyed most of your videos, especially the panel data subject. However, i have one question, How does one solve for the unbalanced panel data problem in stata for different variables involved?
Hi Scora, thanks for the encouraging feedback. Deeply appreciated! Stata works perfectly with unbalanced data. Used several in my publications. Please may I know from where (location) you are reaching me?
@@CrunchEconometrix i am reaching you from South Africa, Cape Town. Also i have followed your Rehape video from excel to stata importation. however, my data is giving me problem with the reshape command. It keeps on saying this
"reshape long YR i(idc INDICATORNAME ) j(YEAR)
option i() required
"
how do i rectify this please
It appears you did not generate id for the cross-sections. In my video, I created country id called c_id.
I get this error message:
"variable id does not uniquely identify the observations
Your data are currently wide. You are performing a reshape long. You specified i(s_id c_id) and j(year). In the
current wide form, variable s_id c_id should uniquely identify the observations."
do you know what to do?
Hi Stefanny, not an issue. Follow the Stata for guides on how to correct the problem.
I get the exact same error message and I have not been able to solve it. Could you please help me?
Please help me. What do i write in place of year if my data is like jul-2018 and its monthly???
First, ensure your data is in the right TIME format, then modify the code to relect MONTH.
@@CrunchEconometrix thanks a lot
@@CrunchEconometrix thanks . Do you know how to get long run coefficient of cross section in panel ardl in eviews?
Not at all.
Hi, first of all, I want to thank you for this useful video. I would like to ask a question about the problem I am facing. When I write to command row "reshape long yr, i (c_id s_id) j (year)" , there is no problem. But, when I write to command row "reshape wide yr, i(c_id year) j(s_id)" command, I am getting error that "variable s_id is string; specify string option". How can I solve this problem? Can you help me about this problem?
I controlled my dataset and follow your this video's steps many times, but I couldn't solve this problem! If someone help me about this topic, I really will be glad.
Hi Cengiz, I honestly have not experienced this before. Perhaps, the issue is with the s_id column. Click on the Stata error on tips on how to fix it. Thanks.
Thanks for this amazing video. it's my first time using stata and also my first time dealing with panel data .
so, I have some question. why have the identifiers been generated for both country and series?
does matter or not if used space in the commands?
how to forecast a missing obs. using stata?
Hi Eman, thanks for the encouraging feedback. Deeply appreciated! Stata will not execute w/o identifiers. I explained that.
sir what problem we face if number of countries is greater than number of years?
You will need to read about the technique you want to deploy to find out the econometric implications if you use the wrong panel data structure.
Thank you for this video! It is quite helpful. Could there be any problem if I decide to extract financial data from bank statements and simply prepare it in a long format/shape without necessarily having it wide and later reshaping to long? Now what happens with the series/variable names, do I have to reshape them to wide to make sense if at all whether I suggested makes sense?
Hi Nyakoe, reshaping from W to L is the format allowed by Stata for panel data analysis. So, if your extraction yields a L-format data, then no need to reshape.
Thanks Doctor, I am blocked at the level of creating identifiers for my series... When I fit in the formula, it doesn't execute, rather it takes it as a text.
Hi Wawah, perhaps the coding is wrong. Pls do it again.
Great
Glad you find this helpful! 🥰
Thank you
Glad you liked the video! 🙏🥰
Please make video transposing data without stata
Ok.
if i have monthly data what will be the code in stata?
Simplify YEAR to MONTH.
Thank you very very much!
You're very welcome😊🙏
Thanks! Very helpful
Thanks Lessa!!!..and please tell others about my YT Channel...
Thanks Dr. Please the code to generate c_id is very tiny. I cannot see it. Can you assist with the code?
Hi Ifeanyi, aside typing the code, I also called out the cell names. Here is it: =if(B3=B2,A2,A2+1).
Thank you.
U're welcome, Chiranjibi! 🥰
How do i get the series data vertically in excel? I have it horizontal just like you have years, i can not assign a series id to them in this way
I suppose that is how you downloaded it from the source. Then, you can use the TRANSPOSE command in Excel.
Great video and very helpful since I use stata for the first time. I have a similar dataset with countries and series and 3 years. I followe your video step by step but stata says there is an error "variable id does not uniquely identify the observations
Your data are currently wide. You are performing a reshape long. You
specified i(cid mid) and j(year). In the current wide form, variable cid
mid should uniquely identify the observations. Remember this picture:
...."
Can you please help me through it cause I dont understand what the problem is?
What is your "mid"?
@@CrunchEconometrix mid is your s_id! Specifically, it is some hr metrics like working hours, layoffs, etc
@@eleftheriachadouli7139 Does it uniquely identify the cs? Because my series id (s_id) does just that.
could u pls link the xlsx dataset again? Would be great! Great vid thx man.
Hi Hidan, dataset is available upon payment of a token fee on my website cruncheconometrix.com.ng/shop/. But you can always practice along with yours. Thanks!
Thank you so much for that video it helped me a lot, I have a question: If i have dates in the excel format dd/mm/yyyy and I would like to use the day as they are in the same year what would I add as prefix. In the video because your dates where years you added yr do I just need to add d? or day?
Hi Patick, thanks for the positive feedback. Deeply appreciated! Unfortunately I have not tried the code on a different date variant so may not be able to guide appropriately. My sincere apologies. Please may I know from where (location) you are reaching me?
@@CrunchEconometrix
Hey, okay thank you very much for your answer anyway, I am currently in China.
Great video thank you! I am however stuck at the part where we reshape. Stata tells me: "option i incorrectly specified" could you help me with this?
Hi George, thanks for watching my videos, deeply appreciated! Regarding your query, not exactly sure what the error is, but I'll say that you start all over and use my coding structure. Just do as I did.
@@CrunchEconometrix are the country codes (the cc) important for stata?
@@CrunchEconometrix for some reason mine only worked with curved brackets and not square brackets (for the reshape command)
@@ECHTisaconcept Good to hear that it finally worked!
Can we do this for EViews also ??
Hi Rajat, I'm not sure. I use Stata to reshape my data. Thanks
Great video. please can someone help me on how to classify countries by low income and middle income in excel? Thank you in advance
Bobbie, you have to do it manually. Watch my video on "Building a Panel Data" on how to go about it.
how i can use the Loop command to rename the multiple year names in one go. For example, we download a GDP of USA for Year 2000 to 2017, then how i can use the loop command to rename the year (2000, 2001, 2002) into (fy2000, fy2001, fy2002) in order to reshape the data. Please guide me.
No idea.
Thanks for your support, by the way i learn the STATA command to do it one go...@@CrunchEconometrix
@@WithDrImran Can you give me the command?
Prof, would you please guide me that how to enter "Quarterly" data i.e. Each year have 4 quarters, e.g. Q1 2018, Q2 2018, Q3 2018, Q4 2018. For banking level data.
If the downloaded data is in quarterly, all you need to do is enter them as ditto for yearly data.
@@CrunchEconometrix Thank you Prof. Would you please share any youtube link for such Pannel quarterly data treatment?
Unfortunately, none that I know of. Except you do an online search.
Thank You very much. It would be a great help to me if you do the same by taking data from prowess.
Subal, thanks for the positive feedback. What do you imply by "taking data from prowess"?
@@CrunchEconometrix A database on Indian listed and unlisted companies.
You can apply the knowledge to any data source.
thanks a lot
You are welcome, Linara! 💕🙏
Thank u thank u
You are very welcome.