Data management: How to create a date variable from a string

This video demonstrates how to create a date variable from a string in Stata using the date() function.
www.stata.com
Copyright 2011-2019 StataCorp LLC. All rights reserved.

[@nip5554]

OH MY GOD!!!!! YOU ARE THE REAL MVP!!! THANK YOU! THANK YOU! THANK YOU!

[@Sirprises]

Chuck you're awesome. Thanks for saving my ass on my Master Thesis!

[@StephenGakuoMaina]

so helpful Chuck

[@gloryths]

Great video. Thanks.

[@julianparodi6411]

and for Year? what is it instead of MDY? tried Y, YY, CCYY everything, nothing works

[@abdullahalmamun-kk5bb]

this really helped me

[@gbolahantoluwalope1409]

This is help...Thank you

[@Inagawakun]

This is really helpful. Thank you!

[@joyluzingu4324]

Amazing!

[@palidin400]

LIFE CHANGING

[@sinamen516]

soooooooo helpful!!!! thanks stata people

[@blackangelofthedead]

Thanks a lot

[@yararefaat7802]

very helpful, Thank you

[@aminaahmedalibelal5676]

bless you

[@baloo5949]

Hey! Im desperately in need of your help!!! My data set is string daily (without the weekends) I've tried formatting the data using the command: generate time=date(date, "MDY") but it keeps responding with "missing values generated". Please help me i've tried everything and nothing works. My data is 01/01/1991 (MDY) and its called date but i dont know why it isnt working

[@lauraiesue905]

this is the same problem I have...it just generates all missing values

[@TheRamsey582]

same problem here, have you managed to fix it?

[@baloo5949]

@@TheRamsey582 hi! I wasn’t able to fix it myself so I reached out to STATA professionals to help me out. Sorry for not being any help :(

[@jl031094]

After you have done this and you want to group this variables by age is this possible and how? Because recode command does not work

[@prakashrajpaudel2370]

I have a little question regarding the date conversion, I have a data and date is stored as a string and the format is "1976-01-06", and I have tried to convert it to the date but everytime it generate missing value, could you have any suggestion

[@12artyom]

The same problem, can anyone help?

[@nithin.m2675]

hi.. i have a yearly variable stored in the format 1996-97, 1997-98 etc. how can i convert this to stata recognisable format? like for 1996-97 (thats the financial year in India) how can i get 1996 and so on?

[@soufieneassidi3238]

I have data from data stream and I need to change a panel data. what are the steps

[@joyjunial1080]

Please help ... Describe shows my date format is "int" --- does it matter.

[@toniweigl9783]

What could be the issue, when Stata makes out of "200001" (=01.2000) to "317707" (=07.3177) and not to 01.2000?

[@statacorp]

Could you please email us at [e-mail] with the commands you are running and the change you would like to make. We are unclear about the change you want to make based on your question.

[@alishaaslam5715]

I am having a problem to import the data

[@ashwinsivakumar13]

i love you