Your SAS programs, embedded in web apps and elsewhere

STP text output in excel

Reply
Regular Contributor
Posts: 163

STP text output in excel

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
SAS Employee
Posts: 285

Re: STP text output in excel

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

Vince
SAS R&D
Regular Contributor
Posts: 163

Re: STP text output in excel

Hi Vince,
example :

proc sql;

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

from tableA

quit;
SAS Employee
Posts: 285

Re: STP text output in excel

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
Regular Contributor
Posts: 163

Re: STP text output in excel

Vince,
I use the Add-in to output in CSV-result type.
SAS Employee
Posts: 285

Re: STP text output in excel

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
Regular Contributor
Posts: 163

Re: STP text output in excel

Thanks Vince,
will do,
jp
Ask a Question
Discussion stats
  • 6 replies
  • 285 views
  • 0 likes
  • 2 in conversation