BookmarkSubscribeRSS Feed
Calcite | Level 5


I have a data set with 6 excel sheets and 1 of them is products which has 1069 rows. I am unable to perform my analysis on more than 30 observations. Can some one help me with this issue, i am doing this for my University assignment.



Super User Tom
Super User

A single dataset would not be stored in 6 separate worksheets.  That would be 6 separate datasets.  If the data is related you might be able to combine them.


How did you convert the workbook into SAS datasets?  Did the worksheet with the 1,069 rows yield a dataset with 1,068 observations (assuming the first row in the worksheet has column headers that SAS can use to guess what names you want to use to refer to the variables it creates).


The usual reason why only 30 out of 1,068 observations participate in an analysis is that observations with missing values for one or more of the variables are excluded.  How many variables are in the dataset you used for the analysis?  How many of the variables did you use in the analysis?  How many missing values do the variables have?



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. 

Register now!

What is ANOVA?

ANOVA, or Analysis Of Variance, is used to compare the averages or means of two or more populations to better understand how they differ. Watch this tutorial for more.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 2 in conversation