Hi all,
I have a dataset with 52,000 observation in which I have a variable called "edate" and another variable called "station".
I ran isid command and the output give me an error:
variables station edate do not uniquely identify the observations
after this, I ran .duplicates list station edate:
+----------------------------------------------+
| group: obs: station edate |
|----------------------------------------------|
| 1 4542 1019 13jun2012 |
| 1 4627 1019 13jun2012 |
| 2 5657 1019 16jun2012 |
| 2 5744 1019 16jun2012 |
| 3 37923 1019 01sep2012 |
|------------------------------------------------|
| 3 38022 1019 01sep2012 |
| 4 38926 1019 03sep2012 |
| 4 39028 1019 03sep2012 |
| 5 19382 1059 17jul2012 |
| 5 19620 1059 17jul2012 |
|------------------------------------------------|
| 6 26169 1059 04aug2012 |
| 6 26377 1059 04aug2012 |
| 7 33291 1059 23aug2012 |
| 7 33345 1059 23aug2012 |
| 8 33868 1059 24aug2012 |
|------------------------------------------------|
| 8 33921 1059 24aug2012 |
| 8 33935 1059 24aug2012 |
| 9 37869 1059 01sep2012 |
| 9 38209 1059 01sep2012 |
| 10 39411 1059 04sep2012 |
|------------------------------------------------|
| 10 39676 1059 04sep2012 |
now, for example, station 1019 is repeated twice for some days and I want to keep only one of these observations.
thanks for your help and I apologize for my English
I have a dataset with 52,000 observation in which I have a variable called "edate" and another variable called "station".
I ran isid command and the output give me an error:
variables station edate do not uniquely identify the observations
after this, I ran .duplicates list station edate:
+----------------------------------------------+
| group: obs: station edate |
|----------------------------------------------|
| 1 4542 1019 13jun2012 |
| 1 4627 1019 13jun2012 |
| 2 5657 1019 16jun2012 |
| 2 5744 1019 16jun2012 |
| 3 37923 1019 01sep2012 |
|------------------------------------------------|
| 3 38022 1019 01sep2012 |
| 4 38926 1019 03sep2012 |
| 4 39028 1019 03sep2012 |
| 5 19382 1059 17jul2012 |
| 5 19620 1059 17jul2012 |
|------------------------------------------------|
| 6 26169 1059 04aug2012 |
| 6 26377 1059 04aug2012 |
| 7 33291 1059 23aug2012 |
| 7 33345 1059 23aug2012 |
| 8 33868 1059 24aug2012 |
|------------------------------------------------|
| 8 33921 1059 24aug2012 |
| 8 33935 1059 24aug2012 |
| 9 37869 1059 01sep2012 |
| 9 38209 1059 01sep2012 |
| 10 39411 1059 04sep2012 |
|------------------------------------------------|
| 10 39676 1059 04sep2012 |
now, for example, station 1019 is repeated twice for some days and I want to keep only one of these observations.
thanks for your help and I apologize for my English
Comment