topic Re: Error in Summary statistics and One-Way Anova in SAS Software for Learning Community

Error in Summary statistics and One-Way Anova

BARCMRC05 — Thu, 06 Jul 2023 20:08:31 GMT

I'm trying to analyze my data using the Summary Statistics and One-Way Anova but on the Top Corner, there a red exclamation point next to the DATA sub-heading and the "Add Columns" sign (+) won't let me add my variables.

Re: Error in Summary statistics and One-Way Anova

Tom — Thu, 06 Jul 2023 20:11:13 GMT

Does the ORGAN dataset actually have any numeric variables to use in an analysis?

Re: Error in Summary statistics and One-Way Anova

BARCMRC05 — Thu, 06 Jul 2023 20:16:00 GMT

yes

Re: Error in Summary statistics and One-Way Anova

Tom — Thu, 06 Jul 2023 20:22:54 GMT

Share the output of PROC CONTENTS. Preferably as text pasted into the pop-up window that opens when you hit the Insert Code icon (looks like < / > ).

Re: Error in Summary statistics and One-Way Anova

BARCMRC05 — Thu, 06 Jul 2023 20:36:01 GMT

PROC CONTENTS DATA=WORK.ORGAN; RUN;

Re: Error in Summary statistics and One-Way Anova

Kurt_Bremser — Thu, 06 Jul 2023 20:46:02 GMT

Not the code, the output.

Re: Error in Summary statistics and One-Way Anova

PaigeMiller — Thu, 06 Jul 2023 20:49:15 GMT

What the error message says is: " ... the following roles are not set: Analysis variable". Your screen capture shows that you have not assigned a variable in the Analysis variables dialog box. You need to do that. Similarly, you will need to assign a variable to the Classification variables box.

Re: Error in Summary statistics and One-Way Anova

BARCMRC05 — Thu, 06 Jul 2023 20:55:57 GMT

Nothing is not coming up for me to add the variables. I have been clicking the to add variables, but it's not letting me

Re: Error in Summary statistics and One-Way Anova

BARCMRC05 — Thu, 06 Jul 2023 20:58:28 GMT

/* Generated Code (IMPORT) */
/* Source File: Rough Data-Organ Weight (7.6.23).xlsx */
/* Source Path: /home/u62478585/Summer 2022 Poultry Research */
/* Code generated on: 7/6/23, 2:39 PM */

%web_drop_table(WORK.ORGAN);

FILENAME REFFILE '/home/u62478585/Summer 2022 Poultry Research/Rough Data-Organ Weight (7.6.23).xlsx';

PROC IMPORT DATAFILE=REFFILE
        DBMS=XLSX
        OUT=WORK.ORGAN;
        GETNAMES=YES;
        SHEET="Organ Weights";
RUN;

PROC CONTENTS DATA=WORK.ORGAN; RUN;

%web_open_table(WORK.ORGAN);

Re: Error in Summary statistics and One-Way Anova

PaigeMiller — Thu, 06 Jul 2023 21:05:33 GMT

I'm wondering if this is a problem caused by the spaces and parentheses in the variable names.

What happens if you first run the command

options validvarname=any;

and then try the one-way ANOVA?

Re: Error in Summary statistics and One-Way Anova

BARCMRC05 — Thu, 06 Jul 2023 21:16:57 GMT

It didn't work

Re: Error in Summary statistics and One-Way Anova

PaigeMiller — Thu, 06 Jul 2023 21:21:06 GMT

So as Sherlock Holmes would say, once you have eliminated many possible causes, whatever is left (no matter how unlikely) is the cause.

So, we are trying to eliminate causes now.

Please show us the ENTIRE output from PROC CONTENTS. When I run PROC CONTENTS, the very first table in the output shows the name of the data set. We need to see this and the rest of the PROC CONTENTS output. Here is that first table when I run PROC CONTENTS on the data set SASHELP.CLASS, you can clearly see that the name of the data set is provided.

Re: Error in Summary statistics and One-Way Anova

Reeza — Thu, 06 Jul 2023 22:49:31 GMT

%web_drop_table(WORK.ORGAN);


FILENAME REFFILE '/home/u62478585/Summer 2022 Poultry Research/Rough Data-Organ Weight (7.6.23).xlsx';

PROC IMPORT DATAFILE=REFFILE
        DBMS=XLSX
        OUT=WORK.ORGAN;
        GETNAMES=YES;
        SHEET="Organ Weights";
RUN;

PROC CONTENTS DATA=WORK.ORGAN; RUN;

proc means data=organ;
run;

What happens if you run that?

Re: Error in Summary statistics and One-Way Anova

BARCMRC05 — Mon, 10 Jul 2023 23:15:20 GMT

Sorry for the late response. Thank you everyone for helping me with my SAS problem, but I did figured out what was the problem. There was a problem with my Library Folders.Thank you to the individuals for reaching out and helping me. I really appreciate it.