02-27-2017 06:12 AM
02-27-2017 06:29 AM
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.
02-27-2017 06:33 AM
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.
02-27-2017 06:38 AM
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).
02-27-2017 08:14 AM
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.
02-27-2017 09:01 AM
Thanks for all your help.
I think the inser option does the trick:
proc univariate data=sashelp.cars noprint;
var EngineSize Invoice;
inset min max mean ;
02-27-2017 04:30 PM
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.