SAS Studio Import node - name output tables after XLS sheet names

[paul_e]

Hello, when importing an Excel file with more then worksheets in SAS Studio (on Viya 4) SAS Studio will give the different output tables cryptic names (such as _flw1235456846856). How do I make SAS Studio give the work files names according to the original worksheet names?

[ballardw]

What are the exact sheet names of the spreadsheets in question?

Many sheet names are not valid for SAS data set names.People put spaces, ( ) and other characters not valid in names.

You might be able to get closer by setting the system option VALIDMEMNAME=extend;

But that will require you for any name that is not a valid SAS name consisting only of letters, digits and underscore characters to use names like "This stupid*name"n with quotes and the N every time you want to use that set and have to make sure the validmemname setting is extend.

Even then you may have issues if some has placed one or more quotes into the sheet name.

[paul_e]

The sheet names are all valid SAS dataset names. The issue is that the import node doesn't seem to even consider naming the output tables after the worksheets. The nodes are named after them but the physical tables aren't and there doesn't seem to be a way to change the configuration of the import node.

[paul_e]

Any solution to this? Another complication is that the tables will get different names each time the flow file is reopened. So I can't even build a consistent mapping renaming the files to their intended names.