Re: data handling problem

[Johnny Amora]

Hi Stanley,

 

Run this syntax:

 

WEIGHT BY Count.
CROSSTABS
  /TABLES=Area BY Time
  /FORMAT=AVALUE TABLES
  /CELLS=COUNT
  /COUNT ROUND CELL.

Cheers,

Johnny

 

--- On Wed, 3/25/09, Cho, Stanley <[hidden email]> wrote:

From: Cho, Stanley <[hidden email]>
Subject: data handling problem
To: [hidden email]
Date: Wednesday, 25 March, 2009, 12:44 AM

Hi all,

I have a straightforward data handling problem.  I have data like this:

Area    Time    Count
100     2       20
102     1       30
102     3       10
104     1       20
104     2       40
104     3       20
105     1       10
108     2       10
108     3       10

In other words, I have a certain number of areas, and data for only some
of the time periods.  I need to create a summary crosstab like this:

Area    Count(Time 1) Count(Time 2)     Count(Time 3)
100     0       20      0
102     30      0       10
104     20      40      20
105     10      0       0
108     0       10      10

This should have a simple solution, but I can't wrap my mind around it
right now.  Any suggestions?

Thanks,
--S.

=====================
To manage your subscription to SPSSX-L, send a message to
LISTSERV@... (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

---

Interested in growing your business? Find out how with Yahoo! Search Marketing!

[Cho, Stanley]

Thanks! 

 

---

From: Johnny Amora [mailto:[hidden email]]
Sent: Tuesday, March 24, 2009 1:00 PM
To: [hidden email]; Cho, Stanley
Subject: Re: data handling problem

 

Hi Stanley,

 

Run this syntax:

 

WEIGHT BY Count.
CROSSTABS
  /TABLES=Area BY Time
  /FORMAT=AVALUE TABLES
  /CELLS=COUNT
  /COUNT ROUND CELL.

Cheers,

Johnny

 

--- On Wed, 3/25/09, Cho, Stanley <[hidden email]> wrote:

From: Cho, Stanley <[hidden email]>
Subject: data handling problem
To: [hidden email]
Date: Wednesday, 25 March, 2009, 12:44 AM

Hi all,

I have a straightforward data handling problem.  I have data like this:

Area    Time    Count
100     2       20
102     1       30
102     3       10
104     1       20
104     2       40
104     3       20
105     1       10
108     2       10
108     3       10

In other words, I have a certain number of areas, and data for only some
of the time periods.  I need to create a summary crosstab like this:

Area    Count(Time 1) Count(Time 2)     Count(Time 3)
100     0       20      0
102     30      0       10
104     20      40      20
105     10      0       0
108     0       10      10

This should have a simple solution, but I can't wrap my mind around it
right now.  Any suggestions?

Thanks,
--S.

=====================
To manage your subscription to SPSSX-L, send a message to
LISTSERV@... (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

 

---

Interested in growing your business? Find out how with Yahoo! Search Marketing!