Hi All, SAS Newbee.. I have a file having separate fields for amount and currency e.g. Amount1 Amount2 Currency There are 3 fixed currencies used inhere i.e. (INR-base, SGD, USD). No other currency type will ever be used. and they have the fixed value for exchange rate. Currently I was usign the approach, created an exchange rate file (with fields Currency and EXRATE) and then using the currency as key field, multiplied the amount in file1 as per the exchange rate recieved. I just wanted to know, if there's some other way round for this. Can we use PROC FORMAT or anyother way to make this happen in PROC SQL i.e. whenever I encounter SGD, multiply the amount field by exrate. Thanks.
... View more