LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (December 2011)Back to main SPSSX-L pageJoin or leave SPSSX-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Tue, 13 Dec 2011 00:31:55 -0800
Reply-To:     Albert-Jan Roskam <fomcl@yahoo.com>
Sender:       "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From:         Albert-Jan Roskam <fomcl@yahoo.com>
Subject:      Re: Truncation of values after Decimal when exporting
              to Excel
Comments: To: Ruben van den Berg <ruben_van_den_berg@hotmail.com>
In-Reply-To:  <SNT110-W41A57FBB261A6952C56813FABD0@phx.gbl>
Content-Type: multipart/alternative;

hi Matthew,   You didn't post your syntax. What did you mean by 'Excel file'? Simply an .xls file, or  a .csv file? Both open MS Excel when you double-click them. If an excel file is saved as .csv from within excel, the display format is what is saved, ie. the numbers may be rounded. Not sure if something similar happens when spss is used. I'd hope not. Cheers!! Albert-Jan ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ All right, but apart from the sanitation, the medicine, education, wine, public order, irrigation, roads, a fresh water system, and public health, what have the Romans ever done for us? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ >________________________________ >From: Ruben van den Berg <ruben_van_den_berg@hotmail.com> >To: SPSSX-L@LISTSERV.UGA.EDU >Sent: Tuesday, December 13, 2011 8:58 AM >Subject: Re: [SPSSX-L] Truncation of values after Decimal when exporting to Excel > > >Dear Matthew, > > >First, let's not talk about any truncation anymore. I haven't observed any form of truncation taking place in any of the posts I've seen on this thread. Numbers have been rounded rather than truncated and this was done correctly. Case closed. > > >Second, some members correctly suggested that the format of your variables in SPSS will affect the number of decimal places that will be exported into EXCEL. So if you have a variable "v1", you could write > > >formats v1(f8.2). > > >in order to see 2 decimals or > > >formats v1(f8.4). > > >in order to see 4 decimals. Apart from any speculations on differences between versions, did you try to modify the variable formats before the SAVE TRANSLATE command? If no, please give it a shot. If yes, please let us know what happened and whether it solves the issue. > > >Best, > > >Ruben > > > > > > >> Date: Mon, 12 Dec 2011 22:53:06 +0000 >> From: mpoes@UILLINOIS.EDU >> Subject: Re: Truncation of values after Decimal when exporting to Excel >> To: SPSSX-L@LISTSERV.UGA.EDU >> >> Comments like this are simply reflecting the imprecision caused by any form of rounding. Rounding was not meant to be the point of my post, it was about what was causing the saving of an SPSS data file to Excel, and having the number of decimal places truncated. The specifics of rounding were unimportant. >> >> I've looked into the issue considering the relevant responses, and found that these are not the issue I'm experiencing. As mentioned, this same program was run on other computers in the office, and found to export all decimal places to excel, regardless of what the SPSS program indicated. The other computer it was run on is running version 19, whereas I'm running version 18, however, that user indicated to me that they were fairly sure such truncating issues had never shown up in the past. We have checked the settings, and nothing appears to be different. >> >> The comment about rounding was meant to A) question why 6.547 would become 6.5 instead of 6.6 (that was answered already), B) note that this issue was causing an early rounding problem, but that its impact in this scenario was inconsequential. >> >> It was mentioned that it was unclear what form of "exporting" was being used, so here is a response. >> The data file is aggregated into a new data file at a different level, from person to school. This new data file is translated to excel format using the following syntax: >> >> SAVE TRANSLATE OUTFILE='C:Excel_file.xlsx' >> /TYPE=XLS >> /VERSION=12 >> /MAP >> /REPLACE >> /FIELDNAMES >> /CELLS=LABELS. >> >> Matthew J Poes >> Research Data Specialist >> Center for Prevention Research and Development >> University of Illinois >> >> >> -----Original Message----- >> From: SPSSX(r) Discussion [mailto:SPSSX-L@LISTSERV.UGA.EDU] On Behalf Of David Marso >> Sent: Monday, December 12, 2011 3:54 PM >> To: SPSSX-L@LISTSERV.UGA.EDU >> Subject: Re: Truncation of values after Decimal when exporting to Excel >> >> "Now obviously in my example, .54 would have 4 less than 5, but the next digit is 7. Why don't you round the 4 up to a 5, based on that 7, and then round the .5 to a .6? " >> >> Ever thought about a career in banking? >> >> >> -- >> View this message in context: http://spssx-discussion.1045642.n5.nabble.com/Truncation-of-values-after-Decimal-when-exporting-to-Excel-tp5068824p5069666.html >> Sent from the SPSSX Discussion mailing list archive at Nabble.com. >> >> ===================== >> To manage your subscription to SPSSX-L, send a message to LISTSERV@LISTSERV.UGA.EDU (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD >> >> ===================== >> To manage your subscription to SPSSX-L, send a message to >> LISTSERV@LISTSERV.UGA.EDU (not to SPSSX-L), with no body text except the >> command. To leave the list, send the command >> SIGNOFF SPSSX-L >> For a list of commands to manage subscriptions, send the command >> INFO REFCARD > > >


[text/html]


Back to: Top of message | Previous page | Main SPSSX-L page