Copying SPSS Output into a Word Document



Copying SPSS Output to a Word DocumentIn the SPSS output window select the entire Output and then right-click and select Copy – then just locate the cursor at the paste location in the Word document and hit CTRL-V (hold down the CTRL key while hitting the V key or hit the paste icon. Zap, your output is copied into your Word document.Another option is to click File, Export in the SPSS output window. You will get a new window like this:Browse your way to the folder where you want the exported document, give it a name, and then click OK.Here is an example of a copied or exported output document. Notice that the syntax is included as is the “Notes” table (which is not displayed in the SPSS output viewer). I ask my students to delete all of the Notes tables and to put the SPSS output after their summary statement, not before it. Here is a simple way to suppress the inclusion of the Notes tables in the exported output. I do not want to have to scroll through a bunch of SPSS output to read the summary statement. If all is well with the summary statement, I do not need to look at the SPSS output.CORRELATIONS /VARIABLES=Gender Ideal Statoph Nucoph SATM /PRINT=TWOTAIL NOSIG /MISSING=PAIRWISE .CorrelationsNotes – Delete this stupid tableOutput Created25-May-2010 19:32:56Comments InputDataC:\D\StatData\IntroQ\IntroQ.savActive DatasetDataSet1Filter<none>Weight<none>Split File<none>N of Rows in Working Data File614Missing Value HandlingDefinition of MissingUser-defined missing values are treated as missing.Cases UsedStatistics for each pair of variables are based on all the cases with valid data for that pair.SyntaxCORRELATIONS /VARIABLES=Gender Ideal Statoph Nucoph SATM /PRINT=TWOTAIL NOSIG /MISSING=PAIRWISE .ResourcesProcessor Time00:00:00.000Elapsed Time00:00:00.016[DataSet1] C:\D\StatData\IntroQ\IntroQ.savCorrelationsGenderIdealStatophNucophSATMGenderPearson Correlation1-.570**-.145**-.075.067Sig. (2-tailed).000.000.064.138N614609613613492IdealPearson Correlation-.570**1.093*.084*-.039Sig. (2-tailed).000.022.038.384N609609608608490StatophPearson Correlation-.145**.093*1-.001-.337**Sig. (2-tailed).000.022.982.000N613608613613491NucophPearson Correlation-.075.084*-.0011.043Sig. (2-tailed).064.038.982.343N613608613613491SATMPearson Correlation.067-.039-.337**.0431Sig. (2-tailed).138.384.000.343N492490491491492**. Correlation is significant at the 0.01 level (2-tailed).*. Correlation is significant at the 0.05 level (2-tailed).GRAPH /LINE(SIMPLE)=MEAN(Nucoph) BY Year .GraphNotes – Delete this stupid tableOutput Created25-May-2010 19:32:56Comments InputDataC:\D\StatData\IntroQ\IntroQ.savActive DatasetDataSet1Filter<none>Weight<none>Split File<none>N of Rows in Working Data File614SyntaxGRAPH /LINE(SIMPLE)=MEAN(Nucoph) BY Year .ResourcesProcessor Time00:00:00.329Elapsed Time00:00:00.344[DataSet1] C:\D\StatData\IntroQ\IntroQ.savSometimes the SPSS output is so wide that part of it on the right will be cut off during the copy or export process. This is true, for example, with the output from independent t test output. To avoid this you will need to open your Word document in landscape mode or select landscape mode when exporting from SPSS,Click “Page Setup for Export.”Here I have changed the “Orientation” to “Landscape.” You might also want to reduce the left and right margins to accommodate very wide output.You can also export the output to one of several other different types of documents, including htm and pdf. If you export to htm each graphic will be put in a jpg file that is pulled by the htm file. Do not send me htm or pdf files. I need your output in a Word document so I can use track changes to give you feedback on any error you might have made.*docx or *rtf ?When exporting the output to “Word/RTF (*.doc), it indicates that the file produced will be a *doc file, but it will not. It will be a *.rtf file. An *.rtf file can be read and edited with Word just fine, but it often is many times larger (in terms of how much space it takes up on storage media such as your hard drive). Accordingly, you should convert the *.rtf file to an*.docx file. Bring the exported output document into Word, edit it as desired, and then save it as a *.docx file. Since it came in as an *.rtf file, Word will, by default, save it as an *.rtf file. You need to change that default during the process of saving the file.Here is a snapshot of a directory to which SPSS output has been exported:Note that it appears to be a *doc file, but it is, in fact, a *rtf file. I open it with Word, make whatever edits I wish to make, and then start saving it (File, Save As).Oh, my, look at the “File name.” It is revealed that it is actually an *rtf file. Change it to a Word *.docx file. Simply active the drop down menu and select *.docxKarl L. Wuensch, Department of Psychology, East Carolina University, November, 2022.Return to my SPSS Lessons page. ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download