I used the code suggested but SAS is only reading the first sheet and not the other sheets. The solution to my initial problem was regarding the path I was using. I used the network path.
... View more
Hi Kurt, I am using SAS Enterprise guide 7.1. Even after successfully creating the active library, the excel sheets do not appear in the library that I have created.
... View more