Hi,

I have two sets of exchange rates (pex and tex), and the dates corresponding to these two sets of exchange rates is 'exdate'. However, I need to extract these two types of exchange rates only for the dates listed under 'secdate'.


* Example generated by -dataex-. To install: ssc install dataex
clear
input float(exdate pex tex) long secdate
13163 8.6456 1.5457 13172
13164 8.6667 1.5386 13173
13165 8.6695 1.5305 13177
13166 8.6543 1.5218 13178
13167 8.6405 1.5105 13179
13168 8.6405 1.5105 13180
13169 8.6405 1.5105 13181
13170 8.6499 1.5149 13184
13171 8.6526 1.514 13185
13172 8.6627 1.513 13186
13173 8.6484 1.5147 13187
end
format %td exdate
format %d secdate


I tried using 'merge' but it didn't work. I appreciate if someone could advise me on how to achieve this.

Thank you

Ama