we are creating a sas library of an excel file using "Libname PCFILES". Then we are deleting few sheets. Then we are deassigning the libref. But now when iam opening the excel i can see that, there was a column having superscript in it , now that is gone and simple letters are written. What to do?
previously data was :- abcd(1) and (1) as a superscript
now data is :- abcd(1) and (1) is coming simple plan letter.
Can you clarify what the issue is exactly. SAS has a structure where variables have a name, which can only be alphabetic, numeric or underscore and maximum of 32 characters. The variable can also have a label which can handle most standard characters. Looking at what you have posted, abcd(1) must be the label of the variable as () are not allowed in variable names, so your variable name would be abcd1 or abcd_1 (something like that). This is perfectly standard procedure for Any structured environment - superscript/subscript, wingdings, pictures and anything other than standard a-z, 1-0 characters will not be available.
If you want them to be superscript in your outputs then this is something you need to apply at report time, using escape codes.
Actually in my excel file , one cell has data with superscript. But after assigning libref using PCFILES and deleting other sheets, that superscript is gone.
If all you want to do is removing some sheets, consider using the right tool to automate MS Office (VBA).
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.