https://communities.sas.com/t5/SAS-Enterprise-Guide/Currency-conversion-helpppppppp/m-p/363734#M23865 <P>Left join, with your original dataset on the left. If your exchange rate table does not cover all combinations of currency&amp;date, you have to deal with that. Best by expanding the currency table.</P> Fri, 02 Jun 2017 09:33:59 GMT Kurt_Bremser 2017-06-02T09:33:59Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Currency-conversion-helpppppppp/m-p/363718#M23858 <P>i've got the data has different currency&nbsp;</P><P>need to calculate the amout of money that has been received for each order in aud</P><P>how could i do that?</P><P>&nbsp;<IMG src="https://communities.sas.com/t5/image/serverpage/image-id/9195iF9C70B47FE9F2659/image-size/original?v=1.0&amp;px=-1" border="0" alt="Screen Shot 2017-06-02 at 6.58.23 PM (2).png" title="Screen Shot 2017-06-02 at 6.58.23 PM (2).png" /></P> Fri, 02 Jun 2017 08:59:20 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Currency-conversion-helpppppppp/m-p/363718#M23858 s34831850 2017-06-02T08:59:20Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Currency-conversion-helpppppppp/m-p/363722#M23859 <P>You need a second table that contains currency, date and exchange rate. Then you can join on currency and date to retrieve the rate for the calculation.</P> Fri, 02 Jun 2017 09:11:17 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Currency-conversion-helpppppppp/m-p/363722#M23859 Kurt_Bremser 2017-06-02T09:11:17Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Currency-conversion-helpppppppp/m-p/363725#M23860 <P>you mean this data right?</P><P><IMG src="https://communities.sas.com/t5/image/serverpage/image-id/9197i2919363228342204/image-size/original?v=1.0&amp;px=-1" border="0" alt="Screen Shot 2017-06-02 at 7.14.15 PM (2).png" title="Screen Shot 2017-06-02 at 7.14.15 PM (2).png" /></P> Fri, 02 Jun 2017 09:14:50 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Currency-conversion-helpppppppp/m-p/363725#M23860 s34831850 2017-06-02T09:14:50Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Currency-conversion-helpppppppp/m-p/363726#M23861 <P>I don't see different currencies in your post - they are all NZD.</P> <P>&nbsp;</P> <P>In case you have realy different currencies, you have to look for currency rates per date -</P> <P>some external data or web tool.</P> Fri, 02 Jun 2017 09:15:18 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Currency-conversion-helpppppppp/m-p/363726#M23861 Shmuel 2017-06-02T09:15:18Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Currency-conversion-helpppppppp/m-p/363727#M23862 <P>You should have dataset for currency conversion .</P><P>This should contain currency conversion rate for all currency to AUD. This dataset should have rate on every day.&nbsp;</P><P>&nbsp;</P><P><STRONG>Currency Conversion</STRONG></P><P>DATE &nbsp; &nbsp;CURRENCY &nbsp; &nbsp;RATE</P><P>&nbsp;</P><P>Then you should join your Transaction table to Currency Conversion based on Date and Currency find the value in AUD.</P> Fri, 02 Jun 2017 09:15:22 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Currency-conversion-helpppppppp/m-p/363727#M23862 RahulG 2017-06-02T09:15:22Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Currency-conversion-helpppppppp/m-p/363729#M23863 <P><IMG src="https://communities.sas.com/t5/image/serverpage/image-id/9198iB869874C5782E13D/image-size/original?v=1.0&amp;px=-1" border="0" alt="Screen Shot 2017-06-02 at 7.14.15 PM (2).png" title="Screen Shot 2017-06-02 at 7.14.15 PM (2).png" /></P><P>&nbsp;</P><P>this one right?</P><P>using left join?&nbsp;</P><P>and then using rate*the amount</P> Fri, 02 Jun 2017 09:18:03 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Currency-conversion-helpppppppp/m-p/363729#M23863 s34831850 2017-06-02T09:18:03Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Currency-conversion-helpppppppp/m-p/363734#M23865 <P>Left join, with your original dataset on the left. If your exchange rate table does not cover all combinations of currency&amp;date, you have to deal with that. Best by expanding the currency table.</P> Fri, 02 Jun 2017 09:33:59 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Currency-conversion-helpppppppp/m-p/363734#M23865 Kurt_Bremser 2017-06-02T09:33:59Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Currency-conversion-helpppppppp/m-p/363735#M23866 got it!!! thxs Fri, 02 Jun 2017 09:34:47 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Currency-conversion-helpppppppp/m-p/363735#M23866 s34831850 2017-06-02T09:34:47Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Currency-conversion-helpppppppp/m-p/363737#M23867 what if i want to run a two sample t-test to compare money received for the two groups? Fri, 02 Jun 2017 09:38:22 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Currency-conversion-helpppppppp/m-p/363737#M23867 s34831850 2017-06-02T09:38:22Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Currency-conversion-helpppppppp/m-p/363743#M23868 <P>Can you be more illustrative about two sample t-test?</P><P>Which are the two groups on you want to run t-test?</P> Fri, 02 Jun 2017 09:52:57 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Currency-conversion-helpppppppp/m-p/363743#M23868 RahulG 2017-06-02T09:52:57Z