Hello! I am looking at the results of a survey in which some respondents submitted a response prematurely and then later submitted a full response. I would like to drop the earlier response, but when I drop duplicates by name, it drops the later response instead (e.g. I have two observations from Joe Smith and I want to drop the response from 2 p.m. but Stata drops the response from 5 p.m. of the same day and keeps the 2 p.m. observation).
Since there's not too many, I decided to do it manually but my timestamp is automatically converted to type double, format %tc and so I'm having trouble figuring out how to use it in an if-statment. For example:
drop if (Timestamp == "05sep2019 15:51:41" & Name == "Joe Smith")
drop if (Timestamp == 05sep2019 15:51:41 & Name == "Joe Smith")
Both return a type mismatch and I don't know how to address this. Converting to an int or string lost data. Alternately, if there's a better way to drop duplicates in a "Name" variable by the *earlier* datetime, I'd really appreciate any suggestions on that.
Thank you!
Related Posts with Using datetime in an expression? (Or dropping duplicates with an *earlier* datetime?)
Help with Master Thesis | Fixed EffectsDear forum, I have a urgent question. I am writing my thesis about cross-border M&A. Hence, I u…
Invalid syntax error after using args commandI am in the process of replicating the Stata code of some researchers. The code snippet below is fro…
nana …
Line break in coding returns me with error message after using Rcall packageCode: rcall: out1 <- att_gt(yname="ln_incwage", tname="year", gname="treat_1", xformla=~male + a…
Whether saving the do file when STATA is running affects STATA performance?I am quite new to STATA. I am running a set of code. At the same time, I also fixed some code in oth…
Subscribe to:
Post Comments (Atom)
0 Response to Using datetime in an expression? (Or dropping duplicates with an *earlier* datetime?)
Post a Comment