Hi all,

I want to export a single table from my spss output to excel using spss syntax. i am new to spss , kindly if anyone have the syntax. In my case i want to export Relative importance tables from the spss output to excel using syntax. It can be in spss or python. 

Hi. Check here for details on the OMS command. If you want a syntax, that is what I would recommend.

It would be something like this:

OMS /SELECT TABLES /IF SUBTYPES="Whatever the subtype for the table you want is"
  /DESTINATION FORMAT=XLSX OUTFILE="path/file.xlsx".
** commands to produce whatever tables you want.
OMSEND.

You will not know the subtype for the table, but to find it, go to the output window, navigate the tree in the leftmost pane to that table, right click, and copy the subtype name. Then you can paste it into the OMS command.