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.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: