Dear Members,
I am looking for a solution of attached format in SAS Guide (Entpr)
There are 2 seprate excel file with below defined format
File 1 has below format (Sample Data)
DATE | USD | AUD | SGD |
202001 | 31.64 | 27.021 | 4.3239 |
202002 | 30.25 | 27.021 | 4.3148 |
202003 | 30.62 | 27.03 | 4.2265 |
202004 | 31.38 | 26.922 | 4.2224 |
File 2 has below format (Sample Data)
Currency_Code | Company | Country_Name |
USD | ABC | US |
SGD | ABC | Singapore |
AUD | ABC | Australia |
Final Output is needed in below format (Expected)
Key_Col | Curr_Rate | FILENAME | DummyCol |
ABCUS_202001 | 31.64 | $RATES | |
ABCUS_202002 | 30.25 | $RATES | |
ABCUS_202003 | 30.62 | $RATES | |
ABCUS_202004 | 31.38 | $RATES | |
I am looking for solution of the final output table as mention above.
Your quick help would be really appriciated/
Regards,