Export to SPSS or others statisticals packages: Missing values

Discussions about tools to complement CSPro data processing
Post Reply
htuser
Posts: 398
Joined: December 19th, 2011, 6:26 pm
Location: HAITI

Export to SPSS or others statisticals packages: Missing values

Post by htuser » December 28th, 2018, 1:18 pm

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!

Gregory Martin
Posts: 1208
Joined: December 5th, 2011, 11:27 pm
Location: Washington, DC

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

Post by Gregory Martin » December 28th, 2018, 5:22 pm

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;

htuser
Posts: 398
Joined: December 19th, 2011, 6:26 pm
Location: HAITI

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

Post by htuser » December 28th, 2018, 7:52 pm

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?

Post Reply