Q: (Exporting results to Excel)
I have produced results in a statistical package, which I would like to paste into a
spreadsheet for formatting.
Do I really have to paste the numbers, one by one, from the program output window?
A: Not any more! Every package has a more convenient way to get results into Excel.
- In AMOS, results are already in a spreadsheet-type format. Just cut and paste.
- In Stata, highlight the results and choose Edit->Copy table. Then paste into Excel.
- In SPSS, highlight the results and choose File->Export with a File Type of Excel.
This produces an Excel file that contains your results.
- In SAS, use the
Output Delivery System (ODS)
to put your results into a SAS data set.
Then use
the EXPORT procedure
to put the SAS data set into an Excel spreadsheet file.
For detailed instructions, click here.