return first non-zero value

Dear All, Suppose that I have this dataset

Code:

clear
input id x
1 .
1 0
1 3
1 4
2 0
2 . 
2 0
2 3
end

For each `id', I'd like to return the first non-zero value. Any suggesitons? Thanks.

Share on FacebookPlus on Google+