Page 1 of 1

Export to SPSS or others statisticals packages: Missing values

Posted: December 28th, 2018, 1:18 pm
by htuser
Dear all,
When exporting to SPSS please, i would like to know if i can label notappl as (-99) values in batch?
Thanks in advance!

Re: Export to SPSS or others statisticals packages: Missing values

Posted: December 28th, 2018, 5:22 pm
by Gregory Martin
You would have to write this manually for every field:
PROC FIELD

    if FIELD = notappl then
        FIELD = -99;     // or...
        FIELD = missing; // if you've defined -99 as missing in the dictionary
    endif;

Re: Export to SPSS or others statisticals packages: Missing values

Posted: December 28th, 2018, 7:52 pm
by htuser
Thanks You Very Much Greg. This way is very time consuming... However, a ItemList/DictList functions would facilitate greatly the job.
What do you think about?