https://communities.sas.com/t5/SAS-Programming/Get-case-sensitive-worksheet-names-from-xlsx/m-p/903591#M357035 Thanks Jedi master. Exactly what was needed. Fri, 17 Nov 2023 02:17:04 GMT RichardAD 2023-11-17T02:17:04Z https://communities.sas.com/t5/SAS-Programming/Get-case-sensitive-worksheet-names-from-xlsx/m-p/903589#M357033 <P>I have tabs named like: MealsServed, SamplesTaken, VisitorsRefused, DailyMedicationAdministered</P><P>When using the XLSX engine Proc SQL DICTIONARY.TABLES shows the tabs as memnames in all UPCASE.&nbsp; The memlabel column is blank.</P><P>&nbsp;</P><P>(Using Linux) How can the case sensitive worksheet names be retrieved from a .xlsx ?</P><P>&nbsp;</P><P>&nbsp;</P> Fri, 17 Nov 2023 00:47:23 GMT https://communities.sas.com/t5/SAS-Programming/Get-case-sensitive-worksheet-names-from-xlsx/m-p/903589#M357033 RichardAD 2023-11-17T00:47:23Z https://communities.sas.com/t5/SAS-Programming/Get-case-sensitive-worksheet-names-from-xlsx/m-p/903590#M357034 <P>Have you tried the&nbsp;<A href="https://go.documentation.sas.com/doc/en/pgmsascdc/v_045/acreldb/n1qsjn9a18pja2n1gdctb7mc1ik8.htm" target="_self">PRESERVE_TAB_NAMES= LIBNAME Statement Option?</A></P> <P>&nbsp;</P> Fri, 17 Nov 2023 02:07:48 GMT https://communities.sas.com/t5/SAS-Programming/Get-case-sensitive-worksheet-names-from-xlsx/m-p/903590#M357034 SASJedi 2023-11-17T02:07:48Z https://communities.sas.com/t5/SAS-Programming/Get-case-sensitive-worksheet-names-from-xlsx/m-p/903591#M357035 Thanks Jedi master. Exactly what was needed. Fri, 17 Nov 2023 02:17:04 GMT https://communities.sas.com/t5/SAS-Programming/Get-case-sensitive-worksheet-names-from-xlsx/m-p/903591#M357035 RichardAD 2023-11-17T02:17:04Z