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" ?

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

Register now!

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
  • 1476 views
  • 0 likes
  • 1 in conversation