Export to SPSS or others statisticals packages: Missing values

Discussions about tools to complement CSPro data processing
Forum rules
New release: CSPro 8.0
Post Reply
htuser
Posts: 631
Joined: December 19th, 2011, 6:26 pm
Location: Silver Spring Area, MD, USA

Export to SPSS or others statisticals packages: Missing values

Post 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!
G.VOLNY, a CSProuser from Haiti, since 2004
Gregory Martin
Posts: 1777
Joined: December 5th, 2011, 11:27 pm
Location: Washington, DC

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

Post 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;
htuser
Posts: 631
Joined: December 19th, 2011, 6:26 pm
Location: Silver Spring Area, MD, USA

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

Post 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?
G.VOLNY, a CSProuser from Haiti, since 2004
Post Reply