Hello,
I have two variables pref_hat and BrewingTime (2 mins, 4 mins, 6mins and 8mins). I used the following procedure:
proc sgplot data = conjoint;
scatter y=pref_hat x=BrewingTime;
run;
How can I connect the mean of pref_hat in each of BrewingTime in the scatter plot below?
Bests,
Golf
Hello @Golf,
I would combine the scatter plot with a line plot using precomputed mean values:
/* Create test data for demonstration */
data conjoint(drop=b);
length BrewingTime $8;
do _n_=1 to 9;
pref_hat=0.3+0.4*rannor(1425674559);
do b=2 to 8 by 2;
pref_hat=pref_hat+b/18-b**2/65;
BrewingTime=catx(' ',b,'Mins');
output;
end;
end;
run;
/* Compute mean values */
proc summary data=conjoint nway;
class BrewingTime;
var pref_hat;
output out=stats mean=mean_pref_hat;
run;
/* Append mean values to detail data */
data want;
set conjoint stats;
run;
/* Combine scatter plot with line plot */
proc sgplot data=want;
scatter y=pref_hat x=BrewingTime;
series y=mean_pref_hat x=BrewingTime / markers markerattrs=(symbol=X);
run;
Result:
Hello @Golf,
I would combine the scatter plot with a line plot using precomputed mean values:
/* Create test data for demonstration */
data conjoint(drop=b);
length BrewingTime $8;
do _n_=1 to 9;
pref_hat=0.3+0.4*rannor(1425674559);
do b=2 to 8 by 2;
pref_hat=pref_hat+b/18-b**2/65;
BrewingTime=catx(' ',b,'Mins');
output;
end;
end;
run;
/* Compute mean values */
proc summary data=conjoint nway;
class BrewingTime;
var pref_hat;
output out=stats mean=mean_pref_hat;
run;
/* Append mean values to detail data */
data want;
set conjoint stats;
run;
/* Combine scatter plot with line plot */
proc sgplot data=want;
scatter y=pref_hat x=BrewingTime;
series y=mean_pref_hat x=BrewingTime / markers markerattrs=(symbol=X);
run;
Result:
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.