I imported several csv files with "birthdate" as one of the variables into Stata and then I appended the files to produce one dataset. However, dates from some of the constituent datasets did not show up at all.
To solve this problem, I used the command "tostring birthdate" before appending The hitherto missing dates now show up but as figures, some positive, others negative.
I have tried various manipulations, but these dates do not convert to the actual birthdates from the csv files.
After formatting as dates, they mostly default to 1960 as the birth year. But that is not the birthday in the original file.
Please kindly help me solve this problem.
Related Posts with Dates from Excel/CSV not correctly displaying in Stata
Tracking a particular variable in a panel dataset over timeHi everyone, I have the following panel dataset. I would like to track ASINs that change from being…
xtpoisson fixed effects when both endogenous variable and IV are binaryDear all, I am using Stata 15.1 and I would like to conduct panel poisson iv regressions for 67 cou…
Label variable list (varlist) based on labels of another varlistI want to label a list of variables using the same labels as another list of variables. In the table…
help with calculating the means for long form dataHi, I'm working with long form data which contains information on financial outcomes (income, total…
Different variables with different datesHello, I want to make the portfolio sort analysis and extract the idiosyncratic volatility, However…
Subscribe to:
Post Comments (Atom)
0 Response to Dates from Excel/CSV not correctly displaying in Stata
Post a Comment