Question
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
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!
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started