Variable Formats
Locked
 
|
I have a question about variable formats – how they
are saved in SPSS, how they are displayed in SPSS, and how they are “save
translated’ to Excel. T data I’m working with represent dollars and so the
customary level of detail is 2 decimal places. However, if I need to look
at the data viewer to dig around for something, I don’t need to see the
decimals and they end up being a distraction. So, I had started changing things
to F8.0 because it appeared that SPSS would still keep the “full detail”
of the variable stored internally. However, I noticed that when I do a
Save As Excel (2007), it cuts off the decimal detail. I know there is the
PRINT FORMATS and WRITE FORMATS commands, but I’m not familiar with the
nuances. Here’s what I’d like to accomplish: I would prefer
to not have the decimal detail displayed in the data viewer but if I export /
save as Excel, I would like the full detail to be there. Thanks for your help, -Eric Eric Langston Research Associate Office of Financial Aid DePaul University 55 E Jackson Blvd, Flr 11 Chicago, IL 60604 (312) 362-8120 |
|
|
Full precision values should be contained in the Excel file. For example, this works fine: data list free /var1 (dollar8.0) var2 (f8.0). begin data 123.456 123.456 end data. save translate /outfile='c:\temp\temp.xls' /fieldnames /replace. Excel preserves the SPSS format if possible; so the values in Excel are displayed without the decimals, but the full precision values are still there. You can see them in the Excel edit bar or if you change the Excel display format to show decimals positions.
I have a question about variable formats – how they are saved in SPSS, how they are displayed in SPSS, and how they are “save translated’ to Excel. T data I’m working with represent dollars and so the customary level of detail is 2 decimal places. However, if I need to look at the data viewer to dig around for something, I don’t need to see the decimals and they end up being a distraction. So, I had started changing things to F8.0 because it appeared that SPSS would still keep the “full detail” of the variable stored internally. However, I noticed that when I do a Save As Excel (2007), it cuts off the decimal detail. I know there is the PRINT FORMATS and WRITE FORMATS commands, but I’m not familiar with the nuances. Here’s what I’d like to accomplish: I would prefer to not have the decimal detail displayed in the data viewer but if I export / save as Excel, I would like the full detail to be there. Thanks for your help, -Eric Eric Langston Research Associate Office of Financial Aid DePaul University 55 E Jackson Blvd, Flr 11 Chicago, IL 60604 (312) 362-8120 |
|
|
Hello,
I'm afraid I already know the answer to this, but it doesn't hurt to ask....
I have a very large pdf file of SPSS output (crosstab tables) that were exported from SPSS into pdf. I need to do some analyses of these data. The rub is there are about 500 tables in this file (2200+ pages). So, if there is any way possible to somehow import these tables back into SPSS I would be delighted to learn how. BTW, I have Acrobat Professional, if that helps.
Thanks,
John |
Re: Reading tables into SPSS from a PDF file?
|
|
J P wrote:
> I'm afraid I already know the answer to this, but it doesn't hurt to > ask.... > > I have a very large pdf file of SPSS output (crosstab tables) that > were exported from SPSS into pdf. I need to do some analyses of > these data. The rub is there are about 500 tables in this file (2200+ > pages). So, if there is any way possible to somehow import these > tables back into SPSS I would be delighted to learn how. BTW, I have > Acrobat Professional, if that helps. > Hi JP: I can think of two ways (untested both): 1) Have you tried turning the PDF file into an Excel file and then importing the resulting Excel file into SPSS? You could try PDF to Excel Converter 2.4 (freeware) or this online system: http://www.pdftoexcelonline.com/ 2) If you have Acrobat professional indeed, you could try to use "Save as" and select other formats, like plain text, or xml (I have Acrobat 6.0, a rather old version, but it allows those two formats). You can then take them to Excel to do some cleaning before importing the Excel file into SPSS. Far from perfect but... HTH, Marta GG -- For miscellaneous SPSS related statistical stuff, visit: http://gjyp.nl/marta/ ===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (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 |
Re: Reading tables into SPSS from a PDF file?
|
|
In reply to this post by J P-6
If you open them in acrobat pro, right
click on the table, you should get an option to export to excel, and from there… Matthew Pirritano, Ph.D. Research Analyst IV Medical Services Initiative (MSI) Orange County Health Care Agency (714) 568-5648 From: SPSSX(r)
Discussion [mailto:[hidden email]] On
Behalf Of J P Hello, I'm afraid I already know the answer to this, but it doesn't hurt to
ask.... I have a very large pdf file of SPSS output (crosstab tables) that
were exported from SPSS into pdf. I need to do some analyses of
these data. The rub is there are about 500 tables in this file (2200+
pages). So, if there is any way possible to somehow import these tables back
into SPSS I would be delighted to learn how. BTW, I have Acrobat
Professional, if that helps. Thanks, John |
|
|
In reply to this post by Rick Oliver-3
Rick- Thanks for the quick response. The full detail is indeed kept
in Excel (97-2003) but it is not kept in Excel (2007). I’ll admit, I didn’t
realize that difference until I tested it just now – but I’m now wondering if
the behavior is more symptomatic of a bug. Do you think it might make sense
for me to follow this up with a support case? Since this might have an impact, I’m using PASW v17.0.2. Thanks again, -Eric From: Rick Oliver
[mailto:[hidden email]]
|
| Free forum by Nabble | Edit this page |