BookmarkSubscribeRSS Feed
VanDalucas
Obsidian | Level 7

Hi,

 

I was wondering if, without using code, I could get the percentage of missing values for the variables of the input data set in enterprise miner. My data set has around 6000 observations and around 700 variables.

 

If I right-click on the dataset and hit "explore" I can only get missing percentage for the max allowed number of obs which is 5000...

 

thank you

 

 

2 REPLIES 2
VanDalucas
Obsidian | Level 7

I think I found it, you select you project and then go to "project start code" property. There you insert: %let em_exploreobs_max= ...(whetever you like up to 50000)

 

Sample method should be set to "Top" and Fetch Size to "Max"

 

VanDalucas
Obsidian | Level 7
But how can I export as a dataset the produced table named "Sample Statistics" ?

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!
How to choose a machine learning algorithm

Use this tutorial as a handy guide to weigh the pros and cons of these commonly used machine learning algorithms.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 2 replies
  • 1536 views
  • 0 likes
  • 1 in conversation