Question about Frequency Output

[stace swayne]

Dear List,

 

Does anyone know if there is a way to write syntax for a frequency that only includes the frequency and the valid percent column?

 

Thanks,

 

Stace

[Daciuk, Tim]

I don’t think so, the FREQUENCIES output is pretty fixed in nature.  What you could look at is the use of CUSTOM TABLES to do that (at least, that is what I use).  You could probably also write a script that deletes the unwanted columns.  Take a look in http://support.spss.com/Tech/default.asp and look at Frequency Tables or Pivot Tables.  There may be a script there you can use.

 

Tim Daciuk

Director, Worldwide Demo Resources

SPSS Inc.

 

 

---

From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of stace swayne
Sent: Friday, June 26, 2009 3:10 PM
To: [hidden email]
Subject: Question about Frequency Output

 

Dear List,

 

Does anyone know if there is a way to write syntax for a frequency that only includes the frequency and the valid percent column?

 

Thanks,

 

Stace

 

[Bruce Weaver]

Daciuk, Tim wrote

I don't think so, the FREQUENCIES output is pretty fixed in nature.  What you could look at is the use of CUSTOM TABLES to do that (at least, that is what I use).  You could probably also write a script that deletes the unwanted columns.  Take a look in http://support.spss.com/Tech/default.asp and look at Frequency Tables or Pivot Tables.  There may be a script there you can use.

There are also a couple of scripts on Raynald's website that may be useful.  See items 17 & 18 here:

   http://www.spsstools.net/SampleScripts.htm#PivotTables
 

[Peck, Jon]

Yes, or almost yes. There is an extension command, spssinc modify tables, that can do this. It requires at least v17 and the Python programmability plugin, but no Python knowledge is required to use it.

You can download this from SPSS Developer Central.

HTH,
Jon Peck

---

From: SPSSX(r) Discussion <[hidden email]>
To: [hidden email] <[hidden email]>
Sent: Fri Jun 26 15:10:21 2009
Subject: [SPSSX-L] Question about Frequency Output

Dear List,

 

Does anyone know if there is a way to write syntax for a frequency that only includes the frequency and the valid percent column?

 

Thanks,

 

Stace

[stace swayne]

Dear list,

 

I have to create sub-samples from a larger data set and I have a few questions:

 

Here is the back ground:

 

I have a data set with 252 people, I have been asked to create sub-samples from this data set based on the following conditions and combine them together to reflect anyone in the sample who reported having an accident :

 

(1) Any individual who answered YES to the first accident inquiry (question #1)

(2) Anyone who answered NO to question 1 but YES to question 6 (another accident inquiry question)

(3) Anyone who answered NO to question 1&6, but answered YES to question 15 (another accident inquiry question)

(4) Anyone who answered no to questions 1,6,&15 but answered YES to question 28.

 

My question is: how would I go about writing the syntax to select based on these conditions.

 

All suggestions are appreciated,

 

Thanks,

 

Stace

 

[Arthur Burke]

Stace ... Does this do what you want? 

 

* GROUP = 1  Any individual who answered YES to the first accident inquiry (question #1).
* GROUP = 2  Anyone who answered NO to question 1 but YES to question 6 (another accident inquiry question).
* GROUP = 3  Anyone who answered NO to question 1&6, but answered YES to question 15.
* GROUP = 4  Anyone who answered no to questions 1,6,&15 but answered YES to question 28.
 
DATA LIST FREE /Q1 Q6 Q15 Q28.
BEGIN DATA.
0 0 0 0
1 0 0 0
0 1 0 0
0 0 1 0
0 0 0 1
END DATA.

 

COMPUTE GROUP = 0.
IF Q1 = 1 GROUP = 1.
IF Q1 = 0 and Q6 = 1 GROUP = 2.
IF Q1 = 0 AND Q6 = 0 AND Q15 = 1 GROUP = 3.
IF Q1 = 0 AND Q6 = 0 AND Q15=0 AND Q28 = 1 GROUP = 4.
EXECUTE.
______________________________________________

 

Art

------------------------------------------------------------------

Art Burke
Northwest Regional Educational Laboratory
101 SW Main St, Suite 500
Portland, OR 97204-3213

Phone:  [phone]

Fax: [phone]

[hidden email] 

 

 

---

From: stace swayne [mailto:[hidden email]]
Sent: Monday, June 29, 2009 6:35 AM
To: [hidden email]
Subject: Question about selecting subsamples

Dear list,

 

I have to create sub-samples from a larger data set and I have a few questions:

 

Here is the back ground:

 

I have a data set with 252 people, I have been asked to create sub-samples from this data set based on the following conditions and combine them together to reflect anyone in the sample who reported having an accident :

 

(1) Any individual who answered YES to the first accident inquiry (question #1)

(2) Anyone who answered NO to question 1 but YES to question 6 (another accident inquiry question)

(3) Anyone who answered NO to question 1&6, but answered YES to question 15 (another accident inquiry question)

(4) Anyone who answered no to questions 1,6,&15 but answered YES to question 28.

 

My question is: how would I go about writing the syntax to select based on these conditions.

 

All suggestions are appreciated,

 

Thanks,

 

Stace

 

[Chipulu M.]

Dear all,

 

I have a request about cluster analysis in ‘clementine spss’. Right now I am not even sure what is ‘clementine spss’. Has anyone come across it and how is it different from ‘normal’ spss?

 

Thanks,

 

Max

 

[John McConnell-2]

Hi Max

 

SPSS Clementine – now called PASW Modeler http://www.spss.com/software/modeling/modeler/ – is the SPSS Data Mining/Predictive Analytics workbench.

 

It shares many of the same algorithms as SPSS, Cluster Analysis being a case in point, but also has some different algorithms. More importantly it has a very different User Interface which is designed to map to the modelling process ( see http://www.crisp-dm.org/ ).

 

Hope this helps and happy to discuss in more details

 

Thanks

 

John

John McConnell

analytical people
500 Chiswick High Road
London
W4 5RG, United Kingdom

Mobile:            [phone]

Office:              [phone]

Skype:              Johnmac65                  

Web:                www.analytical-people.com

 

 

From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Chipulu M.
Sent: 01 July 2009 09:32
To: [hidden email]
Subject: Clementine SPSS anyone?

 

Dear all,

 

I have a request about cluster analysis in ‘clementine spss’. Right now I am not even sure what is ‘clementine spss’. Has anyone come across it and how is it different from ‘normal’ spss?

 

Thanks,

 

Max

 

[Darlene Knafelz]

PASW Modeler (formerly named SPSS Clementine)
http://www.spss.com/software/modeling/ is a workbench for data mining.
Modeler contains many data mining algorithms including a series of modules
that allow you to do Cluster Analysis / Segmentation.   PASW Modeler and
PASW Statistics (formerly named SPSS) are complimentary products.  In
fact, the newest version of Modeler allows you to access Statistics
functionality directly from within Modeler.  Modeler provides more control
over the process and repeatability required for Data Mining tasks.

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

[Bruce Weaver]

stace swayne wrote

Dear list,

I have to create sub-samples from a larger data set and I have a few questions:
 
Here is the back ground:
 
I have a data set with 252 people, I have been asked to create sub-samples from this data set based on the following conditions and combine them together to reflect anyone in the sample who reported having an accident :
 
(1) Any individual who answered YES to the first accident inquiry (question #1)
(2) Anyone who answered NO to question 1 but YES to question 6 (another accident inquiry question)
(3) Anyone who answered NO to question 1&6, but answered YES to question 15 (another accident inquiry question)
(4) Anyone who answered no to questions 1,6,&15 but answered YES to question 28.
 
My question is: how would I go about writing the syntax to select based on these conditions.
 
All suggestions are appreciated,
 
Thanks,
 
Stace

If Yes and No are the only possible responses, and if they are coded Y=1, N=0, then this should work:

compute accident = Q1 or
  (~Q1 and Q6) or
  (~Q1 and ~Q6 and Q15) or  
  (~Q1 and ~Q6 and ~Q15 and Q28) . /* ~ means "not" .
exe.
filter by accident.

If you used codes Y=1 N=2, then you you need to be a bit more explicit, like this:

compute accident =  (Q1 EQ 1) OR
 ((Q1 EQ 2) and (Q6 EQ 1)) OR
 ((Q1 EQ 2) and (Q6 EQ 2) and (Q15 EQ 1)) OR
 ((Q1 EQ 2) and (Q6 EQ 2) and (Q15 EQ 2) and (Q28 EQ 1)) .
exe.
filter by accident.

Personally, though, I always try to use the 1=Y 0=N codes, or recode to that if given data from someone else, because the coding is much neater.

[Art Kendall-2]

But those are not all the possible combinations.
what do you want to do with the person who answers all 4 questions yes.

two possible approaches are:
DATA LIST FREE /Q1 Q6 Q15 Q28.
BEGIN DATA.
0 0 0 0
1 0 0 0
0 1 0 0
0 0 1 0
0 0 0 1
1 0 1 0
1 1 1 0
1 2 2 2
END DATA.
count naccidents = q1 to q28(1).
compute any_accident= any(1, Q1, Q6, Q15, Q28).
formats q1 to any_accident(f1).
LIST .

Art Kendall
Social Research Consultants
Arthur Burke wrote:

Stace ... Does this do what you want? 

 

* GROUP = 1  Any individual who answered YES to the first accident inquiry (question #1).
* GROUP = 2  Anyone who answered NO to question 1 but YES to question 6 (another accident inquiry question).
* GROUP = 3  Anyone who answered NO to question 1&6, but answered YES to question 15.
* GROUP = 4  Anyone who answered no to questions 1,6,&15 but answered YES to question 28.
 
DATA LIST FREE /Q1 Q6 Q15 Q28.
BEGIN DATA.
0 0 0 0
1 0 0 0
0 1 0 0
0 0 1 0
0 0 0 1
END DATA.

 

COMPUTE GROUP = 0.
IF Q1 = 1 GROUP = 1.
IF Q1 = 0 and Q6 = 1 GROUP = 2.
IF Q1 = 0 AND Q6 = 0 AND Q15 = 1 GROUP = 3.
IF Q1 = 0 AND Q6 = 0 AND Q15=0 AND Q28 = 1 GROUP = 4.
EXECUTE.
______________________________________________

 

Art

------------------------------------------------------------------

Art Burke
Northwest Regional Educational Laboratory
101 SW Main St, Suite 500
Portland, OR 97204-3213

Phone:  [phone]

Fax: [phone]

[hidden email] 

 

 

---

From: stace swayne [[hidden email]]
Sent: Monday, June 29, 2009 6:35 AM
To: [hidden email]
Subject: Question about selecting subsamples

Dear list,

 

I have to create sub-samples from a larger data set and I have a few questions:

 

Here is the back ground:

 

I have a data set with 252 people, I have been asked to create sub-samples from this data set based on the following conditions and combine them together to reflect anyone in the sample who reported having an accident :

 

(1) Any individual who answered YES to the first accident inquiry (question #1)

(2) Anyone who answered NO to question 1 but YES to question 6 (another accident inquiry question)

(3) Anyone who answered NO to question 1&6, but answered YES to question 15 (another accident inquiry question)

(4) Anyone who answered no to questions 1,6,&15 but answered YES to question 28.

 

My question is: how would I go about writing the syntax to select based on these conditions.

 

All suggestions are appreciated,

 

Thanks,

 

Stace

 

===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD