topic Re: Categorical variable not being read into output in New SAS User

Categorical variable not being read into output

jake_t1876 — Tue, 10 Sep 2024 22:37:18 GMT

The Cultivar variable is not recognized as categorical for the ANOVA. Any suggestions/recommendations on correcting this issue and anything else you might notice? Thanks!

data rice_yield;

input Soil $ Cultivar $ Yield;

datalines;

Soil_I Cultivar_1 100

Soil_I Cultivar_2 73

Soil_I Cultivar_3 89

Soil_I Cultivar_4 37

Soil_I Cultivar_5 120

Soil_II Cultivar_1 105

Soil_II Cultivar_2 59

Soil_II Cultivar_3 91

Soil_II Cultivar_4 41

Soil_II Cultivar_5 115

Soil_III Cultivar_1 93

Soil_III Cultivar_2 65

Soil_III Cultivar_3 79

Soil_III Cultivar_4 43

Soil_III Cultivar_5 105

;

run;

/* Perform two-way ANOVA with interaction */

proc anova data=rice_yield;

class Soil Cultivar; /* Declare categorical variables */

model Yield = Soil|Cultivar; /* Include interaction term */

means Soil Cultivar / tukey; /* Post-hoc comparisons */

run;

Re: Categorical variable not being read into output

Ksharp — Wed, 11 Sep 2024 00:59:21 GMT

That is because the data you imported in is NOT right.

Change your data step code to import it correctly .

data rice_yield;
    input Soil $ Cultivar :$32. Yield;
    datalines;
...............

Re: Categorical variable not being read into output

jake_t1876 — Wed, 11 Sep 2024 01:10:45 GMT

How does the ":$32" change the inputs?

Re: Categorical variable not being read into output

Ksharp — Wed, 11 Sep 2024 01:32:20 GMT

?? It is LIST INPUT method, with it you could get variable "Cultivar" has more length 32,not 8 by default, to include "_2" "_3".
You can see the change:
Cultivar -> Cultivar_1
Cultivar -> Cultivar_2

Re: Categorical variable not being read into output

jake_t1876 — Wed, 11 Sep 2024 01:34:39 GMT

Thanks you so much for the explanation!!