New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Problem with NA to SPSS #70

Closed
dgromer opened this Issue May 20, 2015 · 2 comments

Comments

Projects
None yet
2 participants
@dgromer
Copy link

dgromer commented May 20, 2015

SPSS seems to have a problem with NA values written with haven. I use the following to create an SPSS file

data <- data.frame(group = rep(c("a", "b"), each = 3),
                   score = c(10, 12, 14, 20, NA, 30))

haven::write_sav(data, "test.sav")

If I now open and run a t-test using

T-TEST GROUPS=group(1 2)
  /MISSING=ANALYSIS
  /VARIABLES=score
  /CRITERIA=CI(.95).

I get the following output:
spss_1

If I now go into the cell containing the missing value in SPSS' data editor and hit the delete key and rerun the analysis, everything works fine (although I have no visible change in the data editor in that cell):
spss_2

hadley added a commit that referenced this issue Jun 22, 2015

@hadley

This comment has been minimized.

Copy link
Member

hadley commented Jun 22, 2015

@dgromer could you please try with the dev version? I've fixed something related to missing values that is almost certainly a bug, but I don't have SPSS to test with

@dgromer

This comment has been minimized.

Copy link

dgromer commented Jun 23, 2015

@hadley the problem seems to be gone (tested with two data sets). Thanks!

@dgromer dgromer closed this Jun 23, 2015

@lock lock bot locked and limited conversation to collaborators Jun 27, 2018

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.