05-24-2016 08:50 AM
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.
05-24-2016 09:01 AM
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.
05-24-2016 09:36 AM
If all you want to do is removing some sheets, consider using the right tool to automate MS Office (VBA).