BookmarkSubscribeRSS Feed
☑ This topic is solved. Need further help from the community? Please sign in and ask a new question.
alsaleh1975
Calcite | Level 5

I seek your kind help, I'm trying to carry out KMO test, but bellow are the errors:

 

ERROR: All variables have missing values for all observations in the input data set.

ERROR: All observations in data set WORK.MYDATA have missing values, or the sum of weights or frequencies is nonpositive.

1 ACCEPTED SOLUTION

Accepted Solutions
Quentin
Super User

I don't know what the KMO test is.  When you post a question, it's helpful if you could include the log from running the step, showing the full code for the step, and all the notes and error messages.

 

In this case, the error messages you showed seem clear.  If you look at the values in your data with PROC FREQ or PROC MEANS, do you see that they are all missing?

As to why they would all be missing values, it's impossible for us to know.  Remember that when you run a SAS program, it's important to start debugging from the first error / warning / bad NOTE  in the log.   Often with this sort of problem, the cause is in earlier code that read in the data, or manipulated the data in some way, when creating WORK.MYDATA.

BASUG is hosting free webinars ! Check out recordings of our past webinars: https://www.basug.org/videos. Save the date for our in person SAS Blowout on Oct 18 in Cambridge, MA. Registration opens in September.

View solution in original post

1 REPLY 1
Quentin
Super User

I don't know what the KMO test is.  When you post a question, it's helpful if you could include the log from running the step, showing the full code for the step, and all the notes and error messages.

 

In this case, the error messages you showed seem clear.  If you look at the values in your data with PROC FREQ or PROC MEANS, do you see that they are all missing?

As to why they would all be missing values, it's impossible for us to know.  Remember that when you run a SAS program, it's important to start debugging from the first error / warning / bad NOTE  in the log.   Often with this sort of problem, the cause is in earlier code that read in the data, or manipulated the data in some way, when creating WORK.MYDATA.

BASUG is hosting free webinars ! Check out recordings of our past webinars: https://www.basug.org/videos. Save the date for our in person SAS Blowout on Oct 18 in Cambridge, MA. Registration opens in September.

SAS Innovate 2025: Call for Content

Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 16. Read more here about why you should contribute and what is in it for you!

Submit your idea!

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
  • 1 reply
  • 311 views
  • 0 likes
  • 2 in conversation