Hello! I'd like to ask how to drop observations in such follwing dataset.
See the pic below for dataset.
ID is the identifier of participants, visit is the visit namely visit 1 or visit 2.
Some participants are missing at visit 1 and some are at visit 2, and some values for Blood and urine are missing.
I want to drop all participants if they have missing value both for Blood and urine at visit 1.
I'd like to know if there can be some straightforward and simple method in doing that.
And I can only use the simple code to list the ID by : list ID if Blood==. & urine==.
But since it's a large dataset, it is not practical and also not clever to delete them one after one, like drop if ID==512125 and so on... also with more than 100 variables also not possible for reshaping.
Thanks for help!!!
Array
Related Posts with Questions for "drop" participants in long data format for repeated mesurements.
Event Study in Corporate FinanceHi all, I have two questions about how I should run an event study. First, I have a staggered imple…
Generating variable based on two groupsHello, I'm working with a dataset from Comtrade, which include information about import, export and…
Ranking in descending order Code: * Example generated by -dataex-. To install: ssc install dataex clear input int(clientid part…
Variable labels and frmttableI am using frmttable to generate a summary table. As far as I can see the option varlabels should au…
Baseline hazard function for Piecewise constant modelI need to plot baseline hazard functions for a piecewise constant model. The problem I find is that …
Subscribe to:
Post Comments (Atom)
0 Response to Questions for "drop" participants in long data format for repeated mesurements.
Post a Comment