topic Re: Problem exporting numeric data to Excel in Microsoft Integration with SAS https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Problem-exporting-numeric-data-to-Excel/m-p/9597#M338 If you append a leading "'" (single quote mark) to any CSV-formatted cell/column value, Excel automatically treats it as character, as-is, where-is. It's up to you to perform the DATA MANIPULATION using a Data Step technique, with a PUT function in a SAS variable assignment statement.<BR /> <BR /> Scott Barry<BR /> SBBWorks, Inc. Fri, 30 Oct 2009 02:51:12 GMT sbb 2009-10-30T02:51:12Z Problem exporting numeric data to Excel https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Problem-exporting-numeric-data-to-Excel/m-p/9596#M337 We need to send a comma-delimited file to another party, the recipients are not technically sophisticated. We need the certain numeric data (stored in SAS char variables) to have the leading zeroes preserved and be displayed as text in the CSV file. We're using Excel 2003 and if the number of rows is under the limit I can use proc export to excel and get the desired result. However, the number of rows is usually above the limit and I have not found a workable solution. I'd like to find a solution where SAS will generate the file in the desired format and neither I nor the users will have to spend time converting it to something usable. Thu, 29 Oct 2009 21:06:57 GMT https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Problem-exporting-numeric-data-to-Excel/m-p/9596#M337 jim_snider 2009-10-29T21:06:57Z Re: Problem exporting numeric data to Excel https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Problem-exporting-numeric-data-to-Excel/m-p/9597#M338 If you append a leading "'" (single quote mark) to any CSV-formatted cell/column value, Excel automatically treats it as character, as-is, where-is. It's up to you to perform the DATA MANIPULATION using a Data Step technique, with a PUT function in a SAS variable assignment statement.<BR /> <BR /> Scott Barry<BR /> SBBWorks, Inc. Fri, 30 Oct 2009 02:51:12 GMT https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Problem-exporting-numeric-data-to-Excel/m-p/9597#M338 sbb 2009-10-30T02:51:12Z