STP text output in excel

[jplarios]

Hi:
I have a stp that outputs in Excel. One type of character value that it outputs is MAR2011. Eventhough this is character , Excel transforms this into a date of Mar/20/2011. Is there a way to output an STP in text ? Or someway for the character value not to be converted into this Excel date?
Thanks,
jp

[Vince_SAS]

What technique are you using to output the SAS output to Excel? Can you post a simplified code sample?

Vince
SAS R&D

[jplarios]

Hi Vince,
example :

proc sql;

select column_name label ='00'x
/* label '00'x because need no column headers*/

from tableA

quit;

[Vince_SAS]

That code creates output in the Output window/lst file. How does it get to Excel? As HTML, CSV or other?

Vince
SAS R&D

[jplarios]

Vince,
I use the Add-in to output in CSV-result type.

[Vince_SAS]

You might want to try posting to the Integration with Microsoft Office Forum:
http://support.sas.com/forums/forum.jspa?forumID=7

Be sure to indicate in your subject that you are using the SAS Add-In for Microsoft Office.

Vince
SAS R&D

[jplarios]

Thanks Vince,
will do,
jp