There are 3 Excel files, DATAFILE1.XLS, DATAFILE2.XLS and DATAFILE3.XLS

Copy these files into the folder: C:\HW5\ Write the SAS codes to convert the 3 Excel files into SAS datasets whose SAS names are: DATAFILE1.SAS7BDAT DATAFILE2. SAS7BDAT DATAFILE3. SAS7BDAT, respectively.

First part of the HW6 is to use PROC IMPORT to import the 3 Excel files into 3 SAS data sets. (Note that you did this task already in HW5. However, now in HW6, you will write a MACRO to import the Excel files into SAS data sets). You can name these 3 newly created SAS data sets as DATAFILE1, DATAFILE2 and DATAFILE3, respectively.

I have to use proc import macro. Cannot figure out how to do this. HELP! Please!