Question: how to import excel with multiple sheets into sas?
Answer: This first method is using DDE (Dynamic Data Exchange). The second method is using a simple macro program to import the multiple spreadsheets one by one. This third method is setting up the excel file as a SAS library and bring in each sheet as a member in the library.