I have SAS macro ready which consumes Dir, file, var, data as input from user. But I have number of files and have to add these inputs manually which is time consuming when have to process 100s of file with macro. So, I have created excel sheet whose headers are same as macro's input and want to create SAS code which can read my excel and parse that data to macro and then macro will get triggered and I can get final outcome.   Dir file var data Dir1 file1 var1 data1 Dir2 file2 var2 data2 Dir3 file3 var3 data3 Dir4 file4 var4 data4 I have excel like above and have SAS macro ready. ... View more