Building models with SAS Enterprise Miner, SAS Factory Miner, SAS Visual Data Mining and Machine Learning or just with programming

Display data characteristics in the same format as IBM modeller

Reply
Contributor
Posts: 42

Display data characteristics in the same format as IBM modeller

Hi ,

 

Is it possible to generate the max,min ,number of missings in the same format as the IBM modeller does?Attached is the desired sample.

 

Thanks in advance !!

Super User
Super User
Posts: 7,401

Re: Display data characteristics in the same format as IBM modeller

Hi,

 

Please post any relevant information in the post, not in attached files - I would not open these as they are security risks.

 

You can get various types of output from proc means:

proc means data=have n nmiss min max;
  ...
  output out=want;
run;

/* or */

proc means data=have;
  ...
  output out=want n=n nmiss=nummiss min=min max=max;
run;

If you want further manipulations then a datastep afterwards to get it into your specific format would be in order.

Contributor
Posts: 42

Re: Display data characteristics in the same format as IBM modeller

Hi ,

Thanks for your suggestion . However, I am aware of the procedures that would fetch me the results be it proc univariate /means . I want the resultant output to look something similar to the one that I hae attached i.e.; a histogram beside the basic univariate measures.

 

Super User
Super User
Posts: 7,401

Re: Display data characteristics in the same format as IBM modeller

Again, I am not looking at dangerous attachments.  At a guess, run an sgplot on the output from proc means with the legend showing the various results (or plot them as text values). 

SAS Employee
Posts: 38

Re: Display data characteristics in the same format as IBM modeller

If you have SAS Enteprise Guide, you can perform preliminary data exploration there prior to bringing your data into SAS Enterprise Miner. SAS Enterprise Miner has several tools for performing data visualization but there is a Data Exploration tool in SAS Enterprise Guide that provides output similar to IBM Modeler.

 

See this paper for an example: Easing into Data Exploration, Reporting, and Analytics Using SAS® Enterprise Guide®

 

This feature became available in SAS Enterprise Guide version 5.1.

Contributor
Posts: 42

Re: Display data characteristics in the same format as IBM modeller

Hi all,

 

Thanks for all your help.

I think the inser option does the trick:

 

proc univariate data=sashelp.cars noprint;
var EngineSize Invoice;
histogram;
inset min max mean ;
run;

SAS Employee
Posts: 63

Re: Display data characteristics in the same format as IBM modeller

Also you can automatically get out the same statistics and graphs as part of the HP Explore node. The output is not in the exact format but the same information is available. Use the drop down arrow to see the individual bar charts.

 

2017-02-27_16-28-04.png

Ask a Question
Discussion stats
  • 6 replies
  • 196 views
  • 0 likes
  • 4 in conversation