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 !!
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.
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.
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).
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.
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;
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.
Catch the SAS Global Forum keynotes, announcements, and tech content!
sasglobalforum.com | #SASGF
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.