Displaying 1 result from an estimated 1 matches for "ptname".
Did you mean:
ptsname
2012 Apr 16
3
Select rows based on condition
...o select rows of
my data based on a condition.
For example in the dataset below multiple observers recorded data at the
same point on the same date and the data was recorded on separate rows, but
I only need one of the rows of data. Is it possible to use grep to search
for rows that have matching PtName and Date and then select the row where
ObsID is the smallest with and if statement (i.e., keep the rows with an *
and remove the others)?
PtName Visit Date Obs ObsID
S2 1 6/8/2005 KB 3 *
S2 1 6/8/2005 JB...