PCFILES libname removing superscript

Reply
Contributor
Posts: 22

PCFILES libname removing superscript

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.

Esteemed Advisor
Esteemed Advisor
Posts: 7,217

Re: PCFILES libname removing superscript

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. 

Contributor
Posts: 22

Re: PCFILES libname removing superscript

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.

Esteemed Advisor
Posts: 6,661

Re: PCFILES libname removing superscript

If all you want to do is removing some sheets, consider using the right tool to automate MS Office (VBA).

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Ask a Question
Discussion stats
  • 3 replies
  • 260 views
  • 0 likes
  • 3 in conversation