topic Re: Reg:Export Data to Excel but formats are missing in SAS Procedures https://communities.sas.com/t5/SAS-Procedures/Reg-Export-Data-to-Excel-but-formats-are-missing/m-p/55808#M15582 Have you format the variable in the dataset forever?<BR /> Such as:<BR /> [pre]<BR /> filename area1 DDE 'excel|c:\[Op.xls]Sheet1!r2c2:r50c20';<BR /> filename area2 DDE 'excel|c:\[Op.xls]Sheet1!r2c30:r50c40';<BR /> data temp;<BR /> set sashelp.class;<BR /> format weight height dollar12.2;<BR /> run;<BR /> data _null_;<BR /> set temp;<BR /> file area1;<BR /> put name sex height weight;<BR /> file area2;<BR /> put name sex height weight;<BR /> run;<BR /> [/pre]<BR /> <BR /> <BR /> <BR /> Ksharp Tue, 27 Jul 2010 08:58:58 GMT Ksharp 2010-07-27T08:58:58Z Reg:Export Data to Excel but formats are missing https://communities.sas.com/t5/SAS-Procedures/Reg-Export-Data-to-Excel-but-formats-are-missing/m-p/55807#M15581 Hi i am having a dataset in this while exporting the dataset in to excel my formats are not coming .how can i do this.<BR /> for example in Date and percentages it was missing.<BR /> <BR /> date result<BR /> jun09 12.3%<BR /> <BR /> How can i bring the same in Excel as the formats are in SAS it should be expoerted in to excel Tue, 27 Jul 2010 07:29:38 GMT https://communities.sas.com/t5/SAS-Procedures/Reg-Export-Data-to-Excel-but-formats-are-missing/m-p/55807#M15581 deleted_user 2010-07-27T07:29:38Z Re: Reg:Export Data to Excel but formats are missing https://communities.sas.com/t5/SAS-Procedures/Reg-Export-Data-to-Excel-but-formats-are-missing/m-p/55808#M15582 Have you format the variable in the dataset forever?<BR /> Such as:<BR /> [pre]<BR /> filename area1 DDE 'excel|c:\[Op.xls]Sheet1!r2c2:r50c20';<BR /> filename area2 DDE 'excel|c:\[Op.xls]Sheet1!r2c30:r50c40';<BR /> data temp;<BR /> set sashelp.class;<BR /> format weight height dollar12.2;<BR /> run;<BR /> data _null_;<BR /> set temp;<BR /> file area1;<BR /> put name sex height weight;<BR /> file area2;<BR /> put name sex height weight;<BR /> run;<BR /> [/pre]<BR /> <BR /> <BR /> <BR /> Ksharp Tue, 27 Jul 2010 08:58:58 GMT https://communities.sas.com/t5/SAS-Procedures/Reg-Export-Data-to-Excel-but-formats-are-missing/m-p/55808#M15582 Ksharp 2010-07-27T08:58:58Z