Hi all,
my dataset is like that:
id data time
1 01jan2018
1 01jan2018
1 03jan2018
1 03jan2018
1 03jan2018
1 06jan2018
.... ................
2 01jan2018
2 01jan2018
2 01jan2018
2 01jan2018
2 05jan2018
2 05jan2018
2 07jan2018
.... ................
so, I want that to become
id data time
1 01jan2018
1 02jan2018
1 03jan2018
1 04jan2018
1 05jan2018
1 06jan2018
.... ................
2 01jan2018
2 02jan2018
2 03jan2018
2 04jan2018
2 05jan2018
2 06jan2018
2 07jan2018
.... ................
Could anyone help me?
Thanks for each reply.
Related Posts with Manipulating datatime
Creating ratio variable from two independent variables for panel dataHi all. I am using educational attainment data and I have data on female tertiary enrolment(%), male…
2020 Swiss Stata Conference takes place virtuallyDue to the development of the situation, the Swiss Stata Conference on November 19 will take place v…
Generate random numbers with specific mean and standard deviation within a rangeHello, I am using STATA 14 and would like to generate some random numbers that have a specific mean …
All characters of a variable are not displayed when I import the excel data. only 1st 27 characters are shown. Please HELP!For example "AgeofPersonAnsweringtheQuest" , only AgeofPersonAnsweringtheQues is displayed when I im…
Difference-in-difference with categorical outcome variableHi everyone, I want to use the Diff command in Stata to run a propensity score matching diff-in-dif…
Subscribe to:
Post Comments (Atom)
0 Response to Manipulating datatime
Post a Comment