topic Re: STP text output in excel in Developers

STP text output in excel

jplarios — Mon, 08 Jun 2009 12:43:10 GMT

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

Re: STP text output in excel

Vince_SAS — Mon, 08 Jun 2009 12:57:39 GMT

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

Vince
SAS R&D

Re: STP text output in excel

jplarios — Mon, 08 Jun 2009 13:01:27 GMT

Hi Vince,
example :

proc sql;

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

from tableA

quit;

Re: STP text output in excel

Vince_SAS — Mon, 08 Jun 2009 13:07:46 GMT

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

Re: STP text output in excel

jplarios — Mon, 08 Jun 2009 13:13:35 GMT

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

Re: STP text output in excel

Vince_SAS — Mon, 08 Jun 2009 13:38:17 GMT

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

Re: STP text output in excel

jplarios — Mon, 08 Jun 2009 13:50:18 GMT

Thanks Vince,
will do,
jp