BookmarkSubscribeRSS Feed
SyazmiSaadon
Calcite | Level 5

Hi

 

I am new with SAS. When I tried to use ANOVA for my data, I keep on getting the same warning causing the result to be incomplete. 

In the log window, it says "WARNING: LSMEAN differences for Days are not estimable; no table of differences will be produced."

 

How am I supposed to solve this problem?

3 REPLIES 3
Kurt_Bremser
Super User

When you encounter problems, always post the log. Use the {i} button for posting log (or other fixed-space) text.

Please post example data in a data step with datalines, like this (creates a copy of the often used sashelp.class dataset):

data class;
input name :$8. sex :$1. age height weight;
datalines;
Alfred      M      14     69.0      112.5
Alice       F      13     56.5       84.0
Barbara     F      13     65.3       98.0
Carol       F      14     62.8      102.5
Henry       M      14     63.5      102.5
James       M      12     57.3       83.0
Jane        F      12     59.8       84.5
Janet       F      15     62.5      112.5
Jeffrey     M      13     62.5       84.0
John        M      12     59.0       99.5
Joyce       F      11     51.3       50.5
Judy        F      14     64.3       90.0
Louise      F      12     56.3       77.0
Mary        F      15     66.5      112.0
Philip      M      16     72.0      150.0
Robert      M      12     64.8      128.0
Ronald      M      15     67.0      133.0
Thomas      M      11     57.5       85.0
William     M      15     66.5      112.0
;

Posting data in this way does not leave any ambiguities. If needed, add a format statement.

This code was posted using the "little running man" button.

Unless your question deals explicitly with Excel files, do not use them to post data. Excel spreadsheets do not convey important information, like SAS variable types and lengths, SAS formats etc.

SyazmiSaadon
Calcite | Level 5
I'm sorry, I'm still new here. Here's what it said in the log window
 
1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
NOTE: ODS statements in the SAS Studio environment may disable some output features.
71
72 /*
73 *
74 * Task code generated by SAS Studio 3.7
75 *
76 * Generated on '8/5/19, 10:10 AM'
77 * Generated by 'u40795001'
78 * Generated on server 'ODAWS01-APSE1.ODA.SAS.COM'
79 * Generated on SAS platform 'Linux LIN X64 3.10.0-693.21.1.el7.x86_64'
80 * Generated on SAS version '9.04.01M5P09132017'
81 * Generated on browser 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko)
81 ! Chrome/75.0.3770.142 Safari/537.36'
82 * Generated on web client
82 ! io%2F='
83 *
84 */
85
86 ods noproctitle;
87 ods graphics / imagemap=on;
88
89 proc glm data=WORK.IMPORT;
90 class Days CM Water CS;
91 model Volume=Days CM Water CS Days*CM Days*Water Days*CS CM*Water CM*CS
92 Water*CS Days*CM*Water Days*CM*CS Days*Water*CS CM*Water*CS Days*CM*Water*CS
93 / ss1 ss3;
94 lsmeans Days CM Water CS / adjust=tukey pdiff=all alpha=0.05 cl;
95 quit;
 
WARNING: LSMEAN differences for Days are not estimable; no table of differences will be produced.
WARNING: LSMEAN differences for CM are not estimable; no table of differences will be produced.
WARNING: LSMEAN differences for CS are not estimable; no table of differences will be produced.
NOTE: PROCEDURE GLM used (Total process time):
real time 0.22 seconds
user cpu time 0.23 seconds
system cpu time 0.01 seconds
memory 6635.50k
OS Memory 34916.00k
Timestamp 08/05/2019 02:10:32 AM
Step Count 197 Switch Count 74
Page Faults 0
Page Reclaims 1901
Page Swaps 0
Voluntary Context Switches 469
Involuntary Context Switches 1
Block Input Operations 0
Block Output Operations 816
 
 
96
97 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
109
 

 

Ready to join fellow brilliant minds for the SAS Hackathon?

Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.

Register today!
Mastering the WHERE Clause in PROC SQL

SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 3 replies
  • 635 views
  • 0 likes
  • 2 in conversation