唔識寫 SPSS Syntax -- 將SPSS Output Export to Excel???

2007-06-22 6:17 pm
如題...想問有冇兄弟識寫SPSS syntax 將SPSS Output export去EXCEL???可唔可以幫幫我???...唔該o西...

回答 (2)

2007-06-28 6:16 am
✔ 最佳答案
Suppose your want to save the file as "abc.xls" under C drive temp folder, the syntax will then be:

SAVE TRANSLATE OUTFILE='C:\temp\abc.xls'
/TYPE=XLS /VERSION=8 /MAP /REPLACE /FIELDNAMES
/CELLS=VALUES .

Hope this helps.
參考: SPSS Syntax Reference Guide & SPSS version 13 software
2007-06-22 6:31 pm
參考以下連結中的3.1章節, 此章節提供匯出excel的方法,
http://www.dur.ac.uk/resources/its/info/guides/86spssexport.pdf


收錄日期: 2021-04-21 14:32:48
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20070622000051KK00824

檢視 Wayback Machine 備份