SPSSX Discussion

SPSS number of cases in a given time

Classic

List

Threaded

4 messages Options

kienzan

SPSS number of cases in a given time

Dear List,

First of all sorry for my english and for my question.
I'm new to SPSS and I would like to create a plot with the frequencie of a
case in a given time.

X axe would be the time in seconds
Y axe would be the number of "error code #2" in the given second

(growth curve?)

I made an example in paint:
http://w3.enternet.hu/krilin/whatiwant.PNG
so I would like to something like this.

Is there any embedded function or something to do it?
I've had googling all yesterday... I couldn't find any useful (sorry, but i
know a little bit about mathematics, statistics and SPSS)

P.S.:
My time variable is in UNIX TIME (seconds from 1970-01-01 00:00:00)
(maybe i sent this message duplaceted... sorry, there are problems with my
mail server)

Sincerely,
Alex Tormasi

=====================
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

ViAnn Beadle

Re: SPSS number of cases in a given time

As usual, the solution depends upon what your data look like. So tell us
what a row of data looks like.

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
Alex TORMASI
Sent: Wednesday, November 14, 2007 2:46 AM
To: [hidden email]
Subject: SPSS number of cases in a given time

Dear List,

First of all sorry for my english and for my question.
I'm new to SPSS and I would like to create a plot with the frequencie of a
case in a given time.

X axe would be the time in seconds
Y axe would be the number of "error code #2" in the given second

(growth curve?)

I made an example in paint:
http://w3.enternet.hu/krilin/whatiwant.PNG
so I would like to something like this.

Is there any embedded function or something to do it?
I've had googling all yesterday... I couldn't find any useful (sorry, but i
know a little bit about mathematics, statistics and SPSS)

P.S.:
My time variable is in UNIX TIME (seconds from 1970-01-01 00:00:00)
(maybe i sent this message duplaceted... sorry, there are problems with my
mail server)

Sincerely,
Alex Tormasi

=====================
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

=====================
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

kienzan

Re: SPSS number of cases in a given time

Thank you for your reply.

I've got 2 columns.

UNIXTIMESTAMP (seconds since 1970 01 01 00:00:00)
ERRORCODE ("1"-> user error, "2"-> system error)

ViAnn Beadle wrote:

> As usual, the solution depends upon what your data look like. So tell us
> what a row of data looks like.
>
> -----Original Message-----
> From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
> Alex TORMASI
> Sent: Wednesday, November 14, 2007 2:46 AM
> To: [hidden email]
> Subject: SPSS number of cases in a given time
>
> Dear List,
>
> First of all sorry for my english and for my question.
> I'm new to SPSS and I would like to create a plot with the frequencie of a
> case in a given time.
>
> X axe would be the time in seconds
> Y axe would be the number of "error code #2" in the given second
>
> (growth curve?)
>
> I made an example in paint:
> http://w3.enternet.hu/krilin/whatiwant.PNG
> so I would like to something like this.
>
> Is there any embedded function or something to do it?
> I've had googling all yesterday... I couldn't find any useful (sorry, but i
> know a little bit about mathematics, statistics and SPSS)
>
> P.S.:
> My time variable is in UNIX TIME (seconds from 1970-01-01 00:00:00)
> (maybe i sent this message duplaceted... sorry, there are problems with my
> mail server)
>
>
> Sincerely,
> Alex Tormasi
>

=====================
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

ViAnn Beadle

Re: SPSS number of cases in a given time

Since you are not interested in ERRORCODE = 1, you first select out all of
those records. I recommend the FILTER command (which can be generated from
the Data>Select Cases command in the Data Editor:

COMPUTE filtercode=(ERRORCODE = 2).
FILTER by filtercode.

Your plot is a plot of frequencies and not individual observations and you
definitely want the x axis to be scale and not categorical. So you'll need
IGRAPH or GGRAPH to make sure that the x axis is scalar. If you are using a
version of SPSS less than 14, use IGRAPH; otherwise use GGRAPH.

To use IGRAPH, go to Graphics>Interactive>Line and drag the UNIXTIMESTAMP
variable into the X axis box. I suggest using the menu approach to syntax
construction because IGRAPH needs the physical size of coordinates which
will be in a metric specific to your version of SPSS.

To use GGRAPH, just run this code:

GGRAPH
/GRAPHDATASET NAME="graphdataset" VARIABLES=UNIXTIMESTAMP
COUNT()[name="COUNT"] MISSING=LISTWISE
REPORTMISSING=NO
/GRAPHSPEC SOURCE=INLINE.
BEGIN GPL
SOURCE: s=userSource(id("graphdataset"))
DATA: age=col(source(s), name("age"))
DATA: COUNT=col(source(s), name("COUNT"))
GUIDE: axis(dim(1), label("Time Stamp"))
GUIDE: axis(dim(2), label("Count"))
ELEMENT: line(position(age*COUNT), missing.wings())
END GPL.

If your line looks really flat then what you need is a histogram which will
bin values into time bins such as 0 to 20 seconds, 21 to 40 seconds, etc. In
that case you can just a simple GRAPH command, IGRAPH, or GGRAPH.

This is enough for you to work on now. Come back to the list if you really
want a histogram.

-----Original Message-----
From: kienzan [mailto:[hidden email]]
Sent: Wednesday, November 14, 2007 7:29 AM
To: ViAnn Beadle; SPSSX(r) Discussion
Subject: Re: SPSS number of cases in a given time

Thank you for your reply.

I've got 2 columns.

UNIXTIMESTAMP (seconds since 1970 01 01 00:00:00)
ERRORCODE ("1"-> user error, "2"-> system error)

ViAnn Beadle wrote:

> know a little bit about mathematics, statistics and SPSS)
>
> P.S.:
> My time variable is in UNIX TIME (seconds from 1970-01-01 00:00:00)
> (maybe i sent this message duplaceted... sorry, there are problems with my
> mail server)
>
>
> Sincerely,
> Alex Tormasi
>