**Goal:**I'm trying to write the syntax to get the net descriptive statistics for multiple variables.

**Problem:**Much like what you can achieve by highlighting multiple rows and columns in Microsoft Excel to get mean/min/max/stddev/variance, I want to get the total descriptive statistics for each

*MoveDistance*variable listed below. Essentially, I would like to treat each

*MoveDistance*Variable as if they were one column (For example below Min =0.5, max=89). What I am not trying to accomplish is to compute the grand mean for each ID as a new score.

Two things complicate writing syntax for this further: First, is my need to use

*If statetments*, as some moves are eligible and others are ineligible (Eligible=1); Second is my need to disaggregate the descriptive statistics by

*Recruitment_Site*. My syntax included below, accomplishes this

*but fails to give me the net MoveDistance means, standard deviation, min, max, and so on.*

**SPSS Version:**19

**Dataset:**

ID, Recruitment_Site, MoveDistance1(km), MoveDistance2(km), MoveDistance3(km), Move1_Eligibility, Move2_Eligibility, Move3_Eligibility.

101, Winnipeg, 89, 3, 7, 1, 1, 1,

102, Winnipeg, 17, 3, 0.5, 1, 1, 1,

103, Toronto, 22, 3, 6, 1, 1, 1,

104, Vanouver, 17, 5, 1, 1, 1, 0,

105, Montreal, 23, 3, 1, 1, 1, 0,

106, Montreal, 25, 4, 13, 1, 0, 0,

107, Toronto, 20, 3, 30, 1, 0, 0,

108, Toronto, 15, 4, 12, 1, 1, 1,

109, Halifax, 18, 3, 11, 1, 1, 0,

110, Winnipeg, 26, 3, 8, 1, 1, 1,

**Syntax attempts thus far:**

Temporary.

SELECT IF Move1_Eligibility = 1 OR Move2_Eligibility = 1 OR Move3_Eligibility = 1.

means MoveDistance1(km) MoveDistance2(km) MoveDistance3(km) by Recruitment_Site

/cells count min max mean median stddev seskew SPCT.

Execute.

I've been digging for answers for a few days now and cannot find any solutions on my own. Any help you could offer would be greatly appreciated.