@Reeza @novinosrin I'm having difficulties in the currency conversion. The conversion from a local currency to USD is a two-step process: 1. from local currency to GBP and from GBP to USD. So for instance, to convert HKD to USD, WRDS uses this code: proc sql; SELECT a.datadate, a.exratd AS hkd_exratd, b.exratd AS usd_exratd, ( 1 / a.exratd ) * b.exratd AS exchange_rate FROM comp.g_exrt_dly a, comp.g_exrt_dly b WHERE ( a.tocurd = 'HKD' ) AND ( a.fromcurd = 'GBP' ) AND ( b.tocurd = 'USD' ) AND ( b.fromcurd = 'GBP' ) AND a.datadate = b.datadate order by datadate desc; quit; The code above will give you a table that looks like this: datadate exchange rate daily exchange rate daily exhange_rate 20140222 12.9430 1.6687 0.128926833 So, if I'm not mistaken 'exchange_rate' is the rate between HKD and USD, the rate to use in the conversion. My question is do I have to write a separate code for all the countries separately or I can write one code to incorporate all. And how do I then use this to finally convert my data from local currencies into USD ? Thank you.
... View more