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,
... View more