topic Percentage of missing values through Enterprise Miner node in SAS Data Science

Percentage of missing values through Enterprise Miner node

VanDalucas — Mon, 11 Sep 2017 14:26:09 GMT

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

Re: Percentage of missing values through Enterprise Miner node

VanDalucas — Mon, 11 Sep 2017 15:03:09 GMT

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"

Re: Percentage of missing values through Enterprise Miner node

VanDalucas — Mon, 11 Sep 2017 15:13:00 GMT

But how can I export as a dataset the produced table named "Sample Statistics" ?