Transcription of 316-2013: Maintaining Formats When Exporting Data from …
{{id}} {{{paragraph}}}
Paper 316-2013 Maintaining Formats when Exporting Datafrom SAS into microsoft excel Nate Derby, Stakana Analytics, Seattle, WAColleen McGahan, BC Cancer Agency, Vancouver, BCABSTRACTData Formats often get lost when Exporting from SAS into excel using common procedures such asPROCEXPORTor the ExcelXP tagset. In this paper we describe some tricks to retain those : SAS, excel , export, : Exporting DATA FROM SAS INTO EXCELMany typical ways of Exporting data from SAS to excel , such asPROC EXPORTor the ExcelXP tagset, destroythe data Formats . To illustrate this, we first create a formatted version of set, with onestudent s information set to missing:DATA class;SET ; format age 3.
Paper 316-2013 Maintaining Formats when Exporting Data from SAS® into Microsoft® Excel® Nate Derby, Stakana Analytics, Seattle, WA Colleen McGahan, BC Cancer Agency, Vancouver, BC
Domain:
Source:
Link to this page:
Please notify us if you found a problem with this document:
{{id}} {{{paragraph}}}
Introduction to Microsoft Excel 2007, Microsoft, 2007, Using Microsoft Excel, Using Microsoft Excel Introduction Microsoft Excel, Microsoft Excel VBA Free Training Manual, Microsoft Excel 2007, Excel 2007 Free Training Manual, Introduction to Microsoft Publisher, Microsoft Publisher 2007, Creating Stylish Multi-Sheet Microsoft Excel, 226 Moving Data and Results Between, Moving Data and Results Between, Microsoft Excel, Introduction to Macros and Visual, Excel