topic Re: Duncan’s Multiple Range Test Grouping in SAS Programming

Duncan’s Multiple Range Test Grouping

RitCF — Thu, 07 Nov 2019 15:12:50 GMT

Hi!

I am trying to do ANOVA analysis with Duncan grouping. However, the results window is showing only the colour code instead of a letter code. How can I convert results into a letter code? Thanks in advance!

Result_with colour codeResult_with letter code

Re: Duncan’s Multiple Range Test Grouping

ballardw — Thu, 07 Nov 2019 16:03:48 GMT

As a minimum you should share the code you are using, or the code generate by choices.

There are at least half a dozen procs that do ANOVA in some form and display choices vary by Procedure.

Also you may need to share some example data to use for testing.

Is the table on the left what you actually want? I'm not quite sure I understand exactly what you expect for result.

Re: Duncan’s Multiple Range Test Grouping

PGStats — Thu, 07 Nov 2019 16:13:24 GMT

Use the LINESTABLE option. To get datasets, request

ODS OUTPUT MCLines=MCLines MCLinesInfo=MCLinesInfo MCLinesRange=MCLinesRange;

Duncan’s Multiple Range Test Grouping

RitCF — Fri, 08 Nov 2019 09:57:24 GMT

Hi!
Yes, I want the result in a tabular format that appears in a letter coding (like A, AB, BC, C etc..) instead of colour coding. Please find the data set and code below that I am using.

title1 'Nitrogen Content of Red Clover Plants';
data Clover;
input Strain $ Nitrogen @@;
datalines;
3DOK1 19.4 3DOK1 32.6 3DOK1 27.0 3DOK1 32.1 3DOK1 33.0
3DOK5 17.7 3DOK5 24.8 3DOK5 27.9 3DOK5 25.2 3DOK5 24.3
3DOK4 17.0 3DOK4 19.4 3DOK4 9.1 3DOK4 11.9 3DOK4 15.8
3DOK7 20.7 3DOK7 21.0 3DOK7 20.5 3DOK7 18.8 3DOK7 18.6
3DOK13 14.3 3DOK13 14.4 3DOK13 11.8 3DOK13 11.6 3DOK13 14.2
COMPOS 17.3 COMPOS 19.4 COMPOS 19.1 COMPOS 16.9 COMPOS 20.8
;
proc anova data=Clover;
class Strain;
model Nitrogen = Strain;
means Strain / duncan waller;
run;

I found this code from the SAS/STAT(R) 9.2 User's Guide, Second Edition. I want the result as it has been shown in this guide.

Thanks!

Re: Duncan’s Multiple Range Test Grouping

Serko — Tue, 14 Jan 2020 13:44:18 GMT

How to add linetable option?

Re: Duncan’s Multiple Range Test Grouping

Serko — Tue, 14 Jan 2020 13:45:18 GMT

hello! Did you convert your results into letter?

Re: Duncan’s Multiple Range Test Grouping

ashrafali — Fri, 14 Aug 2020 19:35:40 GMT

from code remove ODS GRAPHICS ON; and ODS GRAPHICS OFF;

Re: Duncan’s Multiple Range Test Grouping

Chamini — Tue, 20 Feb 2024 05:31:43 GMT

I would also like to have the code to convert results in to letter

Re: Duncan’s Multiple Range Test Grouping

Chamini — Tue, 20 Feb 2024 05:33:03 GMT

I tried this code as follows
title1 'AUDPC values of pepper plants';
data Pepper;
input Sample $ AUDPC @@;
datalines;
MB1 04.19 MB1 02.09
MB2 10.67 MB2 10.57
MB3 07.75 MB3 07.94
MB4 14.71 MB4 12.00
MB5 15.14 MB5 12.43
MB6 16.91 MB6 12.55
MB7 18.00 MB7 18.00
MB8 17.56 MB8 16.91
MB9 12.71 MB9 15.52
MB10 18.00 MB10 18.13
;
proc anova data=Pepper;
class Sample;
model AUDPC = Sample;
means Sample / duncan waller;
ODS OUTPUT MCLines=MCLines MCLinesInfo=MCLinesInfo MCLinesRange=MCLinesRange;
run;
It did not work

Re: Duncan’s Multiple Range Test Grouping

Rick_SAS — Tue, 20 Feb 2024 13:21:14 GMT

To get the table instead of the graph, use
ODS GRAPHICS OFF;

as explained in this article: Introducing the new SAS/STAT lines plot - Graphically Speaking

For an overview of the LINESPLOT, its advantages, and its limitations, see Graphs for multiple comparisons of means: The lines plot - The DO Loop (sas.com)