I run the linear regression in SPSS for 300 companies after splitting the file on the basis of company name. Now I want to extract the output of my interest such as R square & coefficients with p values of all companies to excel. If I copy and paste, it will take so much time. Can anyone suggest any tricks or function to do this?
Only way I can think of is the syntax. Looks like in SPSS you can only programmatically save in the SPSS formats:
https://www.ibm.com/docs/en/spss-statistics/23.0.0?topic=save-overview-output-command
Maybe, this is a good opportunity to change the statistical software. You might want to check out JASP which looks and feels like SPSS but runs on R and enables you to see and alter the code, which makes it possible to solche your issue programmatically.
I think you have to use SPSS Syntax
You may visit following link to learn some SPSS Output - Basics, Tips & Tricks
https://www.spss-tutorials.com/spss-output/#:~:text=Copy-Pasting%20SPSS%20Output%20Tables%20to%20Excel%20If%20you,copy%20special%20as%20Excel%20worksheet%20as%20shown%20below
https://stackoverflow.com/questions/38866625/spss-oms-extract-to-dataset-on-regressions-that-have-already-been-run
If you use R Programming, then visit following link to convert list of regression outputs into data frames by using "broom" package and "tidyverse" package and tidy() and lapply() functions
https://stackoverflow.com/questions/56170796/how-to-convert-list-of-regression-outputs-into-data-frames-with-broomtidy-by-u
Take a look at OMS/OMSEND rather than OUTPUT SAVE. Notice that the DESTINATION sub-command includes both XLS and XLSX as two of the output formats.
- https://www.ibm.com/docs/en/spss-statistics/26.0.0?topic=reference-oms
- Badges
- Science topic
- Similar topics
- Filing