Plot time series over an interval
in [SAS]
|
Prev: ranuni between .20 and .25
Next: Can SAS do text parsing like PERL on a website or news search engine
From: vncntj on 14 Mar 2010 15:12 I'm trying to gplot a time series on an interval from 5:30 to 5:31 to see number of people I have within that interval. Data Entry_Times; Input ticket_time $1-10; cards; 5:27:14 5:30:34 5:30:34 5:31:29 5:31:35 5:31:50 5:31:57 5:31:58 5:31:59 5:32:05 5:32:22 5:32:59 5:33:58 5:34:14 5:35:39 ; run; quit; proc gplot data=Entry_Times; plot ticket_time; run;
From: xlr82sas on 14 Mar 2010 19:21 On Mar 14, 12:12 pm, vncntj <vincent.s.jo...(a)gmail.com> wrote: > I'm trying to gplot a time series on an interval from 5:30 to 5:31 to > see number of people I have within that interval. > > Data Entry_Times; > Input ticket_time $1-10; > > cards; > 5:27:14 > 5:30:34 > 5:30:34 > 5:31:29 > 5:31:35 > 5:31:50 > 5:31:57 > 5:31:58 > 5:31:59 > 5:32:05 > 5:32:22 > 5:32:59 > 5:33:58 > 5:34:14 > 5:35:39 > ; > run; > quit; > > proc gplot data=Entry_Times; > plot ticket_time; > run; Data Entry_Times; Input ticket_time time10.; id='T'; cards; 5:27:14 5:30:34 5:30:34 5:31:29 5:31:35 5:31:50 5:31:57 5:31:58 5:31:59 5:32:05 5:32:22 5:32:59 5:33:58 5:34:14 5:35:39 ; run; quit; options nocenter; proc timeplot format ticket_time time10.; plot ticket_time=id / pos=25; run; /* or you can make gplot look like timeplot */ proc gplot data=entry_times; format ticket_time time10.; plot ticket_time*ticket_time=id; run; Output from timeplot. ticket_time min max 5:27:14 5:35:39 *-------------------------* 5:27:14 |T | 5:30:34 | T | 5:30:34 | T | 5:31:29 | T | 5:31:35 | T | 5:31:50 | T | 5:31:57 | T | 5:31:58 | T | 5:31:59 | T | 5:32:05 | T | 5:32:22 | T | 5:32:59 | T | 5:33:58 | T | 5:34:14 | T | 5:35:39 | T| *-------------------------* If you want to plot time vs frequency do this to get output for plot proc freq data=entry_times; format ticket_time time5.; tables ticket_time/missing out=frq; run; and olot the frq dataset
From: vncntj on 15 Mar 2010 00:12
thanks!!! :) On 14 mar, 19:21, xlr82sas <xlr82...(a)aol.com> wrote: > On Mar 14, 12:12 pm, vncntj <vincent.s.jo...(a)gmail.com> wrote: > > > > > > > I'm trying to gplot a time series on an interval from 5:30 to 5:31 to > > see number of people I have within that interval. > > > Data Entry_Times; > > Input ticket_time $1-10; > > > cards; > > 5:27:14 > > 5:30:34 > > 5:30:34 > > 5:31:29 > > 5:31:35 > > 5:31:50 > > 5:31:57 > > 5:31:58 > > 5:31:59 > > 5:32:05 > > 5:32:22 > > 5:32:59 > > 5:33:58 > > 5:34:14 > > 5:35:39 > > ; > > run; > > quit; > > > proc gplot data=Entry_Times; > > plot ticket_time; > > run; > > Data Entry_Times; > Input ticket_time time10.; > id='T'; > cards; > 5:27:14 > 5:30:34 > 5:30:34 > 5:31:29 > 5:31:35 > 5:31:50 > 5:31:57 > 5:31:58 > 5:31:59 > 5:32:05 > 5:32:22 > 5:32:59 > 5:33:58 > 5:34:14 > 5:35:39 > ; > run; > quit; > > options nocenter; > proc timeplot > format ticket_time time10.; > plot ticket_time=id / pos=25; > run; > > /* or you can make gplot look like timeplot */ > proc gplot data=entry_times; > format ticket_time time10.; > plot ticket_time*ticket_time=id; > run; > > Output from timeplot. > ticket_time min max > 5:27:14 5:35:39 > *-------------------------* > 5:27:14 |T | > 5:30:34 | T | > 5:30:34 | T | > 5:31:29 | T | > 5:31:35 | T | > 5:31:50 | T | > 5:31:57 | T | > 5:31:58 | T | > 5:31:59 | T | > 5:32:05 | T | > 5:32:22 | T | > 5:32:59 | T | > 5:33:58 | T | > 5:34:14 | T | > 5:35:39 | T| > *-------------------------* > > If you want to plot time vs frequency do this to get output for plot > > proc freq data=entry_times; > format ticket_time time5.; > tables ticket_time/missing out=frq; > run; > and olot the frq dataset |