Closed

SPSS Base Syntax

This project received 4 bids from talented freelancers with an average bid price of $30 USD.

Get free quotes for a project like this
Employer working
Skills Required
Project Budget
$30 - $250 USD
Total Bids
4
Project Description

Hi there,

I have a dataset in spss which consists of string and numeric variables. I want to recode all values '999' to SYSMIS. See the following simple example:
************
Simple Source Data:
************
Var1 Var2
4 comment 1
999 comment 2
3 999
2 222
****************
Target Data should look like:
****************
Var1 Var2
4 comment 1..
. comment 2..
3 .
1 222

I tried this one:
DATASET ACTIVATE DataSet3.
RECODE ALL (999=SYSMIS) .
execute.

But then it i get errormessage:
>On the RECODE command, all the variables to be recoded must be of the same
>type. That is, all must be string variables, or all must be numeric
>variables.

I need a syntax that recodes string and numeric variables mixed in one dataset.
Can anyone help me with this issue?

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online