I am a newbie in SAS programming. I was wondering if it is possible to open a SAS file in a macro and use its variables to do some calculations? to be more specific, I am trying to write a macro for changing currencies to AUD but not the current rates to get it from a live data source rather I need historical rates. So I have the historical exchange rates downloaded from Reserve bank of Australia and already imported to SAS. But have not yet figured out how to write a macro to open the file and use its values. Something that I have tried is the following: %macro convert_currency(x,CUR,Date); %let fopen(exchange_rates,I); %IF exchange_rates.date=&date %then Rate=&CUR; %let &x._convert=&x*rate; run; %mend convert_currency; I will be thankful if someone can help.
... View more