Date: Wed, 14 Nov 2007 07:59:39 -0700
Reply-To: ViAnn Beadle <vab88011@gmail.com>
Sender: "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From: ViAnn Beadle <vab88011@gmail.com>
Subject: Re: SPSS number of cases in a given time
In-Reply-To: <473B0631.9040704@freemail.hu>
Content-Type: text/plain; charset="us-ascii"
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:kienzan@freemail.hu]
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:
> 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:SPSSX-L@LISTSERV.UGA.EDU] On Behalf Of
> Alex TORMASI
> Sent: Wednesday, November 14, 2007 2:46 AM
> To: SPSSX-L@LISTSERV.UGA.EDU
> 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
LISTSERV@LISTSERV.UGA.EDU (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
