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?
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
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?
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.
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
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.