Code and define missing values in SPSS

I'll show you how to quickly replace 'blank' cells with a missing value code in the Data View tab and then define that missing value code in the Variable View tab.

[@indefat]

I've been looking for a video like this for over a week. Thank you for making this video!!!

[@porterspilgrimage3011]

Clear, concise, and exactly the question I was looking to answer. Thank you.

[@abhijitv]

very nice !! clarity of thought and expression both

[@tarignassr6690]

Thanks for the video it is very useful. You made it easy.

[@oliverlandon6795]

Thank you, clear and to the point.

[@AliyuMarke]

Thank you very much, this is a nice tutorial indeed.

[@mralbert1030]

Thanks very much for your video, it's really helpful

[@alexgiank1960]

thanks a lot , easy to understand and very helpfull

[@TheJammed]

Thank you! saved me much time

[@lm9098]

You helped a lot, thanks ! :)

[@ummisyifa2003]

Thank you. Very helpful

[@tvtynah1513]

Thank you for sharing ❤️

[@ThePookie25]

This was very good.

[@pamelaloriesse]

So helpful!

[@MusaAhmed--oh8hg]

it really helps!

[@jagdogs]

THANK YOU!

[@erasmomaldonado9517]

Thanks again!

[@Dr.Farah.M]

Thank you so much🙏

[@jaywelly6896]

Thanks, very helpful! I also have missing data from a 'decline to answer' option I provided in my survey - would this be checking the 'system or user missing' option and placing the value spss has already allocated to the decline option in the new values box?

[@ahmed3820]

I have not applicable NA value ,how to treat it?

[@ankithooda1536]

Thank u dear

[@linduchyable]

thanks for the video it is very useful. i face a problem in SPSS. my data includes negative valu3s as -127.79 when i type it or paste it in SPSS it does not appear the cell remains blank. i need these negative values since most of them are negative. please help !!!

[@sarasolomon7971]

Thanks so much for this video, it was really helpful. I had a question regarding coding answers that are inapplicable. In my survey, some people wrote their nationality rather than their ethnicity. Under another question, "what year are you in? (University)", I have a variety of answers that do not apply, like the year they were born, the year they expect to graduate, the study program etc. How would I begin to code and define these values? Should I just code all of them with "99" for example, and define them as missing? Would appreciate any help I can get :)

[@jdanzevino]

When I do this and then just run Analyze=>Descriptive Statistics=>Frequencies, the blank values are still counted in the percentages. How do I omit the blanks from the percent calculation??

[@aqsakhan5985]

I'm also facing the same issue☹

[@datascientist2958]

blank spaces are by default considered missing value in spss

[@raziehadineh]

thanks for sharing this video

[@saadalhumaid3959]

thanks

[@nileytrueluv1]

hey this is great! How about setting missing values for string variables? I have a string variable that has some blank cells, finding it quite hard to set missing values for them

[@nikidcruz9228]

change it into numeric in variable view.

[@owbahraniya500]

@@nikidcruz9228 Thank you so much, you dont realize how much helpful your reply was. You literally saved me

[@owbahraniya500]

Thanks for asking this question!

[@ahmed3820]

If i code the not applicable with zero is it ok or shall i keep it blank ?! Please help

[@chloepatterson2972]

Why are all of mine coming up missing values?

[@aqsakhan5985]

This didn't work. The frequencies still count -1 as missing values and even show the percentage. How can we actually omit it

[@lucutes2936]

2022 thx

[@Stuck313]

Didn't work at all.