topic scatter by by hour in Graphics Programming

scatter by by hour

matt23 — Tue, 03 Jul 2018 14:48:15 GMT

I am trying to do a scatterplot with two groups (5 PM and 4 AM) but it also shows overall over the groups making it messy.

I have this:

data dataname2;
   set dataname;
   if Hour in (17) then grouphour='5 P.M.';
   if Hour in (4) then grouphour='4 P.M.';
run;

proc sgplot data=dataname2; 
where Month in (6,7,8);
where also Weekday in (1,2,3,4,5);
scatter x=Xvar y=Yvar / group=grouphour;
reg x=Xvar y=Yvar;

title '5 P.M. vs 4 A.M. (summer)';
run;

Also, is there an easier way to do this without making new dataset?

like group1 = Hour(17) group2 = Hour(4) or something like that?

Re: scatter by by hour

Reeza — Tue, 03 Jul 2018 14:57:48 GMT

Do you want the rest of the hours included and only those two hours highlighted? If so, a temp data set is the easiest method.

Or just those two hours - this is easy adding a condition to your WHERE statement for HOUR.

@matt23 wrote:

I am trying to do a scatterplot with two groups (5 PM and 4 AM) but it also shows overall over the groups making it messy.

I have this:
data dataname2;
   set dataname;
   if Hour in (17) then grouphour='5 P.M.';
   if Hour in (4) then grouphour='4 P.M.';
run;

proc sgplot data=dataname2; 
where Month in (6,7,8);
where also Weekday in (1,2,3,4,5);
scatter x=Xvar y=Yvar / group=grouphour;
reg x=Xvar y=Yvar;

title '5 P.M. vs 4 A.M. (summer)';
run;
Also, is there an easier way to do this without making new dataset?

like group1 = Hour(17) group2 = Hour(4) or something like that?

Re: scatter by by hour

matt23 — Tue, 03 Jul 2018 15:03:17 GMT

No, I only want the two hours but on top of them I get both of them combined. I don't want the combined one and I don't know why it even shows.

Re: scatter by by hour

Reeza — Tue, 03 Jul 2018 15:05:45 GMT

Exclude/Include them in the WHERE statement.

proc sgplot data=dataname; 

where Month in (6,7,8)
           and Weekday in (1,2,3,4,5) 
           and hour in (4, 17);

scatter x=Xvar y=Yvar / group=hour;
reg x=Xvar y=Yvar;

title '5 P.M. vs 4 A.M. (summer)';

run