Can't find sheet with a " ' " in name in Sashelp.table

[Reeza]

It works for me with the XLSX engine, I'm on SAS 9.4 M3

[art297]

I'm not sure about the vtable view, but you could create the macro variables using proc sql accessing dictionary.tables (e.g.:

libname xlfiles xlsx "/folders/myfolders/test.xlsx";
proc sql;
select *
from dictionary.tables
where libname eq 'XLFILES';
;
quit;

The result of the above is shown in the attached jpg

Art, CEO, AnalystFinder.com

[art297]

What are you trying to do with your prxchange calls? You dont include any prxparse calls that define either re or re2.

Art, CEO, AnalystFinder.com

[fbl204653]

Hi art, I removed the prxparse part because I think it's not revelant. Thanks for your suggestion! I will try dictionary table in sql..

Thanks!