Delete cells/replace data with empty cell using syntax

[theglazebrook]

Hi there

I have the follow problem:

In a number of my variables, I have data that is "0.00" and shows up in Data view and in any analysis I do as ".0". This is because I entered in 0s.

I would now like to replace the ".0" with nothing. I.e. make it a blank cell. I managed to do this in Data view using Edit > Replace. I searched for ".0" and didn't put anything in the replace field.

However, I need to be able to do the same thing using the syntax file.

SPSS can find the cells and replace it with a number, such as 999 when I do the following:

RECODE FHCOMBINED1990 (0.00=999).
It works when I put in a number. The problem is I want to make those cells empty/blank.

So, if I don't put in a number, it gives me an error:

RECODE FHCOMBINED1990 (0.00=).
RECODE FHCOMBINED1990 (0.00=.).
RECODE FHCOMBINED1990 (0.00='').

All give me errors.

How can I do this? Any ideas?

Thanks so much!

[theglazebrook]

Nevermind, I got it. It is RECODE FHCOMBINED1990 (0=SYSMIS).

Thanks!

[Ambika]

Hi,

I need help on a similar problem. My data is in excel spreadsheet. Several cells are empty because of the nature of the data. When I take this to spss, the empty cells contain dots ("."). I want to convert those to 999 so that spss treats them as missing data. What is the syntax for that?

Thanks!

[Pell]

RECODE variable (SYSMIS = 999).

Where variable is the name of the variable which contains the dots