topic how to display the order of the sheets as they are in xlsx file? in SAS Programming

how to display the order of the sheets as they are in xlsx file?

tianerhu — Wed, 02 Jun 2021 18:58:42 GMT

libname te xlsx 'C:\practice everyday\input\input01.xlsx';
proc contents data = te._all_;
run;

output:

order : SHEET BB SHEETA SHEETC ,

but in xlsx file , order is following:

Re: how to display the order of the sheets as they are in xlsx file?

ballardw — Wed, 02 Jun 2021 19:59:45 GMT

SAS doesn't "care" about the "order" of data sets in any library. Proc Contents reports on them alphabetically by name. If you must have one procedure, Proc Contents, report them in a specific order, then name the sheets alphabetically.

Please describe the "need" for matching the order in the Xlsx file. What process are you attempting that will fail if not processed in that manner?

Re: how to display the order of the sheets as they are in xlsx file?

tianerhu — Wed, 02 Jun 2021 21:25:09 GMT

Thank you for your help.