316-2013: Maintaining Formats When Exporting Data ... - SAS

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. height weight ;IF name = 'Thomas' THEN age = .;RUN;In Figure 1, we can compare the original data (left) with our revised one above, (right). We see that in contrast to the original one, the new one has two decimal places for the variablesheightandweight. We also have a missing age for Thomas, to illustrate what happens when we export missing datainto that we have our new data set, we export it withPROC EXPORTand with the ExcelXP tagset (explainedin many papers such as DelGobbo (2006, 2007, 2008, 2009, 2010, 2011, 2012) and Gebhart (2006, 2007a,b,2008)).

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

Loading..

Tags:

  Maintaining, Format, When, Exporting, Maintaining formats when exporting

Information

Related search queries