These for import 5 CSV files into SAS proc import datafile="C:\Users\Coputer15\Desktop\Sub-Broker active AM Report\RAD1.csv" out=work.RAD1 dbms=csv replace; run; proc import datafile="C:\Users\Coputer15\Desktop\Sub-Broker active AM Report\RAD2.csv" out=work.RAD2 dbms=csv replace; run; proc import datafile="C:\Users\Coputer15\Desktop\Sub-Broker active AM Report\RAD3.csv" out=work.RAD3 dbms=csv replace; run; proc import datafile="C:\Users\Coputer15\Desktop\Sub-Broker active AM Report\RAD4.csv" out=work.RAD4 dbms=csv replace; run; proc import datafile="C:\Users\Coputer15\Desktop\Sub-Broker active AM Report\RAD5.csv" out=work.RAD5 dbms=csv replace; run; these code for import 1 excel file into SAS. %macro import(file,dname); proc import datafile="&file" out=&dname dbms=excel replace; getnames=yes; run; %mend; %import(C:\Users\Coputer15\Desktop\Sub-Broker active AM Report\RAD6.xls,RAD6); please write a programme how to get that required output...
... View more