I am looking for a nice way to represent information on a given study for my classroom. I have two separate groups A and B and want to compare them (hoping that B is statistically significantly better than A). How can I program this? I am very new to this and not sure what to do! I think a box an whisker plot would look nice, but also want the p-value shown on the top comparing the two.
A 2.7
A 0.0
A 3.1
A 4.6
B 6.2
B 5.2
B 3.5
B 3.6
B 5.9
Any help is appreciated! Thank you
The SAS code below takes your data set and reads the A and B into a variable called GROUP and the measures into a variable called VALUE. I then ran the TTEST procedure with plots=box. The output shows the p-values in a table and the boxplot below if that is okay. This is one of the easiest ways I could think of. The SAS output is contained in the attached pdf file. All the best - Randy
data work.compare;
length group $1;
input group value;
cards;
A 2.7
A 0.0
A 3.1
A 4.6
B 6.2
B 5.2
B 3.5
B 3.6
B 5.9
;
run;
ods graphics on;
proc ttest data=work.compare plots=box;
class group;
var value;
ods graphics off;
You will need to run a test that creates p-values. Depending on the version of SAS you are using then you can add that value to a graph using an annotate dataset with your graph procedure.
Also, is that your actual data or do you have more records? Tests for a small sample is displayed are going to much different than for a larger sample. Also when compare (test) are you looking at means or distribution or something else?
The SAS code below takes your data set and reads the A and B into a variable called GROUP and the measures into a variable called VALUE. I then ran the TTEST procedure with plots=box. The output shows the p-values in a table and the boxplot below if that is okay. This is one of the easiest ways I could think of. The SAS output is contained in the attached pdf file. All the best - Randy
data work.compare;
length group $1;
input group value;
cards;
A 2.7
A 0.0
A 3.1
A 4.6
B 6.2
B 5.2
B 3.5
B 3.6
B 5.9
;
run;
ods graphics on;
proc ttest data=work.compare plots=box;
class group;
var value;
ods graphics off;
Is there anyway on the box-plot that I could include all the data points?
Both your answer (RandyCollica) and (stat@sas) answers are exactly what I needed!! Thank you
Check proc boxplot that allows to put stats on the box plot. I don't think it will allow to put all data points.
Hi,
This can provide the boxplot with p value added on it.
ods graphics on;
ods select boxplot;
proc anova data=have;
class group;
model value=group;
quit;
ods graphics off;
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
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.