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?
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.
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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.