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.
A quick shot, using a format:
proc format library=work;
invalue exch
'INR' = 1.5
'SGD' = 2.5
'USD' = 0.8
;
run;
data have;
input curr $ amount;
cards;
INR 100
SGD 200
USD 50
;
run;
data want;
set have;
internal = amount * input(curr,exch.);
run;
One might also consider using a hash object to store the exchange rates, but to me the format method is simpler.
A quick shot, using a format:
proc format library=work;
invalue exch
'INR' = 1.5
'SGD' = 2.5
'USD' = 0.8
;
run;
data have;
input curr $ amount;
cards;
INR 100
SGD 200
USD 50
;
run;
data want;
set have;
internal = amount * input(curr,exch.);
run;
One might also consider using a hash object to store the exchange rates, but to me the format method is simpler.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.