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

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

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