Transcription of 316-2013: Maintaining Formats When Exporting …
{{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 .
Figure 4: Our formatted data set work.classwith the ExcelXP tagset formatted as text. THE EXCELXP TAGSET Actually, we can preserve data formats with the ExcelXP tagset!
Domain:
Source:
Link to this page:
Please notify us if you found a problem with this document:
{{id}} {{{paragraph}}}