Hi,


I have a panel data set. I want to extract a specific observation number to a local, to be used later. I want to get the observation number for the first observation for a new ID. In this example the observation number in bold.

Code:
* Example generated by -dataex-. To install: ssc install dataex
clear
input str15 ID double date float obs
"Sweden" 21147  1
"Sweden" 21150  2
"Sweden" 21151  3
"Sweden" 21152  4
"Sweden" 21153  5
"Sweden" 21154  6
"Sweden" 21157  7
"Sweden" 21158  8
"Sweden" 21159  9
"Sweden" 21160 10
"Sweden" 21161 11
"Sweden" 21164 12
"Sweden" 21165 13
"Sweden" 21166 14
"Sweden" 21167 15
"Sweden" 21168 16
"Sweden" 21171 17
"Sweden" 21172 18
"Sweden" 21173 19
"Sweden" 21174 20
"Sweden" 21175 21
"Sweden" 21180 22
"Sweden" 21181 23
"US"     20809  1
"US"     20810  2
"US"     20811  3
"US"     20815  4
"US"     20816  5
"US"     20817  6
"US"     20818  7
"US"     20821  8
"US"     20822  9
"US"     20823 10
"US"     20824 11
"US"     20825 12
"US"     20828 13
"US"     20829 14
"US"     20830 15
"US"     20831 16
"US"     20832 17
"US"     20835 18
"US"     20836 19
"US"     20837 20
"US"     20838 21
"US"     20839 22
end
format %td date
Any ideas?