scatter by by hour

[matt23]

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?

[Reeza]

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?

---

[matt23]

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.

[Reeza · Accepted solution]

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