topic Re: Need to create a graph for time values in SAS Programming

Need to create a graph for time values

kajal_30 — Mon, 26 Aug 2024 18:55:37 GMT

I have a column datetime in sas dataset and want to create a graphs to show maximum number of times exists in a range .

For eg few events occur between 2pm and 4 pm so my graph should show maximum dots or peak line during that interval.

max range for the graph should be 24 hours and each interval should be 1 hour apart.

Also from the datetime column I just need to take time portion.

regards

kajal

Re: Need to create a graph for time values

PaigeMiller — Mon, 26 Aug 2024 19:00:54 GMT

A bunch of questions enter my mind:

You say: "want to create a graphs to show maximum number of times exists in a range". Maximum of what? If you take the word "maximum" out of your statement, then it makes sense to me what (I think) you want, you want the number of times this variable exists in the range. But I'm guessing.

You say "For eg few events occur between 2pm and 4 pm so my graph should show maximum dots or peak line during that interval." If there are few events, should that not be the minimum dots or lowest value on the line?

Are these always 2 hour intervals? Are we talking about multiple days, or just talking about time interval regardless of day?

Re: Need to create a graph for time values

kajal_30 — Mon, 26 Aug 2024 19:02:34 GMT

sorry correction to my question.

need to create a graph showing max frequencies of 'time of event ' in a particular time range

most of the events occur between 2pm and 4 pm should show maximum dots on the graph between 2pm and 4 pm range.

Regards

kajal

Re: Need to create a graph for time values

PaigeMiller — Mon, 26 Aug 2024 19:05:20 GMT

I'm still not understanding your usage of "maximum" in your problem statement. Please explain in more detail.

Please show us a simple example, show us some example data and the plot you want.

Re: Need to create a graph for time values

ballardw — Mon, 26 Aug 2024 19:23:21 GMT

In a data step the TIMEPART function will extract the time of day from a DATETIME value. Example;

data want;
   set have;
   timeofday = timepart(datetimevariable);
run;

By "each interval should be 1 hour " do you mean the tick marks on the time axis or the actual values of the time rounded to 1 hour to graph, or both?

What is going on the Y axis? A count of something? A measurement or recorded value?

Re: Need to create a graph for time values

kajal_30 — Mon, 26 Aug 2024 19:24:28 GMT

Re: Need to create a graph for time values

PaigeMiller — Mon, 26 Aug 2024 19:32:46 GMT

Thanks for the plot. So we are not calculating a maximum of anything, we are calculating a count. Is that correct?

Try this:

/* UNTESTED CODE AS I DON"T HAVE EXAMPLE DATA */

data have2;
    set have;
    hour=hour(yourdatetimevariable);
run;
proc freq data=have2;
    table hour/noprint out=_counts_;
run;
proc sgplot data=_counts_;
     series x=hour y=count;
run;

Re: Need to create a graph for time values

Ksharp — Tue, 27 Aug 2024 01:46:30 GMT

data have;
call streaminit(123);
do datetime=dhms('01jan2022'd,21,0,0) to dhms('02jan2022'd,3,0,0) by 60*60;
 hour=scan(put(timepart(datetime),timeampm.),1,':');
 count=rand('integer',100,600);
 output;
end;
format datetime e8601dt.;
run;

proc sgplot data=have;
series x=hour y=count;
xaxis  type=discrete discreteorder=data label='Time';
run;

Re: Need to create a graph for time values

ChrisNZ — Tue, 27 Aug 2024 06:57:36 GMT

If you want this smooth plot, you need points between the hours. Do you have that detail? How many points?

Mind that the more points, the less volume by point. So if the volume is say 600 in an hour, a per-minute plot will show around 10 on the Y axis.

A per-30-minute plot will show around 300 on the Y axis. Etc.

Re: Need to create a graph for time values

kajal_30 — Wed, 28 Aug 2024 17:50:05 GMT

Thank you so much it works

Re: Need to create a graph for time values

kajal_30 — Wed, 28 Aug 2024 17:50:43 GMT

Thank you so much it also works