Hi , Plz help with the below scenario I wan to know the first Sheet name (order of creation) in an excel sheet. Is there any way. Somebody suggested using XML (i.e consider excel as xml) Use the below code but getting error: Code: filename src ZIP 'C:\Users\pooja\Desktop\Try2.xlsx' member='xl/workbook.xml'; filename des temp; data _null_; rc=fcopy('src','des'); run; filename srcmap temp; libname des xmlv2 xmlmap=srcmap automap=reuse; data sheet_names; set des.sheet; run; proc print width= min; run; Error: libname des xmlv2 xmlmap=srcmap automap=reuse; ERROR: With the AUTOMAP= option, the specified XML document must exist. ERROR: Error in the LIBNAME statement.
... View more