topic Re: Retain character format when exporting to csv in SAS Enterprise Guide

Retain character format when exporting to csv

deleted_user — Thu, 11 Jan 2007 12:54:00 GMT

I am trying to export a $16 that is actually all numbers to .csv but on opening the file the string is exported as 3.0297E+19. I cannot export to exel as I do not have the facility. Is there a work around for this?

Re: Retain character format when exporting to csv

ChrisHemedinger — Thu, 11 Jan 2007 21:31:52 GMT

Is this related to Enterprise Guide or are you using PROC EXPORT? And from your message, it wasn't clear whether you don't have Excel or you don't have SAS/ACCESS to PC File Formats.

If using Enterprise Guide, you can do a "Send To Excel" (assuming that you have Microsoft Excel), and EG will automate Excel and populate a sheet with the formatted values. This does NOT require SAS/ACCESS to PC File Formats.

You can also Export data to an xls file from EG. That also does not require the SAS/ACCESS product.

Chris

Re: Retain character format when exporting to csv

deleted_user — Fri, 12 Jan 2007 13:48:16 GMT

for credit card numbers into excel, as text, see earlier posting in the forums at

http://support.sas.com/forums/thread.jspa?forumID=6&threadID=530&messageID=2028#2028 .

That started with numeric data, but the excel interpretation doesn't see the source, only the text passed along with the parameters for handling the string

Peter