Spss data output

[JuanCV]

Hello,

We are trying to output a file to SPSS (.sav) but are having some issues. We have the file currently saved as yxdb fromat (weights about 400 mb).

We are trying to switch it from yxdb to sav (input->output with no other tools) but we don’t know why it is taking so long. It has been already over 1 hour, only 8 percent reached and over 100GB. With that in mind, it would reach over 2000GB when finished.

Is there a bug with the SPSS output? Are we missing something?

The have currently the 2020.4.5.12471 version installed on a Windows machine.

The table has about 550k lines and 330columns with VString, Double, DateTime and fixed decimal columns.

Regards

[christine_assaad · Accepted solution]

Hi @JuanCV 

This is probably related to String data fields.. when data gets written to .sav, the size of String fields could grow by a magnitude of 4, as in Alteryx Help document.

https://help.alteryx.com/current/designer/stat-transfer-supported-file-formats

Before you write to .sav, I'd recommend you add an "Auto Field" building block to give you the optimum data type and size.

This should improve run time and give you a more manageable file size. Hope this helps.

[DavidP]

Hi @JuanCV 

There's also a post by JordanB where he uses an R-based macro to write to SPSS - it's worth trying it out.

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/SPSS-Output/ta-p/55453