About wave43

wave43 · ‎08-30-2017

Thanks, I understand how to create the new variables for the averages. I am looking for suggestions on a visual display.

wave43 · ‎08-28-2017

I have a multiple numeric variables (costs of services) where I want to show signficant descreases in mean costs before and after an event. I have a member level dataset consisting of 8,000 records where each of these cost variables are defined. Example Variables: before_event_cost_1 after_event_cost_1 before_event_cost_2 after_event_cost_2 before_event_cost_3 after_event_cost_3 I ran t-tests in BASE SAS to show significance decreases. However, I would like to visually display the decreases to these mean values before and after the event using SAS visual analytics. What are some objects or capabilities in SAS visual analytics where I can do this?

wave43 · ‎06-23-2017

I would like to use SVM in Enterprise Miner. Reading the blog posts, it sounds like I need to use HPSVM. When I try to run HPSVM, I see a vague error explaining that "a run time error was encountered and to please see the logs." However, I don't see an error in the logs. I ran statExplore and decision tree to make sure it wasn't my dataset. Any tips you can give me would be great. Thanks.

wave43 · ‎03-07-2016

Thank you!

wave43 · ‎03-04-2016

Is there a way that proc sgplot (vbox option) can generate the summary statistics for the boxplot like proc boxplot does? I want to show all the values: min, max, median, mean, and n for each category on the x axis. Can you point me to some sample code? I am sure I am not the first to ask this question. Thanks.

wave43 · ‎03-03-2016

I figure it out. I am using proc freq to come up with percentages for each of the groups individually: http://blogs.sas.com/content/iml/2012/12/03/show-percentages-for-bar-charts-with-proc-sgplot.html Then I am merging the output of the two datasets for two new variables: one for the percent overall, and one for the percent for the group.

wave43 · ‎03-03-2016

proc sgplot was defintely the way to go, and solved a couple of my other problems. However, I still have the same questions. I want to overlay (or side by side) each of these 35 graphs generated with the by statement: A) proc sgplot data= analytic_cohort; by pat_groupid; vbar agecat_clinical; run; With the one graph generated by: B) proc sgplot data= analytic_cohort; vbar agecat_clinical; run; B) contains the overall agecat_clinical for the entire population and I want that next to the age_cat clinical for the pat_groupid.

wave43 · ‎03-03-2016

I am creating a bar chart where I display 30 individual charts using the "by statement": proc gchart data = analytic_file; by group_id; vbar age_category / type=percent; run; The above creates 30 individual charts (for each group) showing the age category percentages for each group_id (great!) On each of the 30 charts, I want to show side by side 1) the age_category precentages for the group AND 2) the overall percentages for the entire population (analytic_file, not grouped by groupid). Ex. There are 30% who are 18-25 in groupd A, and 45% who are 18-25 for the entire population. How would I do this?

wave43 · ‎02-16-2016

Thank you!! Exactly what I was looking for. I can't believe how hard I made this.

wave43 · ‎02-16-2016

I received an email asking if I have a solution. I still do not. I am trying many options including the ones I highlighted in my previous post.

wave43 · ‎02-12-2016

Thanks. I tried "&em_lib..", "&em_lib.", and "em_lib." as repressented by the below in bold: PROC ARBOR INMODEL= &em_lib..Tree38_emtree; MACRO NLEAVES= &em_lib..nleaves; SAVE SEQUENCE= &em_lib..sequence NODESTATS= &em_lib..nodes STATSBYNODE= &em_lib..statsbynode; QUIT; the log says (and no location): 14896 %let syscc = 0; 14897 %inc "/xxxx/Projects/xxxx Data Mining 2015/Predictive Models/Workspaces/EMWS15/EMCODE/EMTRAINCODE.sas"; NOTE: %INCLUDE (level 1) file /xxxx/Projects/xxxx Data Mining 2015/Predictive Models/Workspaces/EMWS15/EMCODE/EMTRAINCODE.sas is file /xxxxx/Projects/xxxxx Data Mining 2015/Predictive Models/Workspaces/EMWS15/EMCODE/EMTRAINCODE.sas. 14898 +PROC ARBOR INMODEL= &em_lib..Tree38_emtree; NOTE: 1654978 kilobytes of physical memory. NOTE: The subtree sequence contains 5 subtrees. The largest has 9 nodes and 5 leaves. 14899 +MACRO NLEAVES= &em_lib..nleaves; 14900 +SAVE SEQUENCE= &em_lib..sequence NODESTATS= &em_lib..nodes STATSBYNODE= &em_lib..statsbynode; 14901 +QUIT; NOTE: %INCLUDE (level 1) ending. 14902 *------------------------------------------------------------*; 14903 * Close any missing semi colons; 14904 *------------------------------------------------------------*; 14905 ; 14906 ; 14907 ; 14908 ; 14909 quit;

wave43 · ‎02-12-2016

Yes, that was my issue! However, I still don't see the files for "node", "sequence", or "nodes" my EM_LIB directory. That should be the names of the datasets. Correct? Thank you!

wave43 · ‎02-11-2016

The logs have an error when looking for the EMTREE data. Maybe I don't understand your notation for "TREEZ", but I tried substituting the node id (Tree38) for Z ERROR: File WORK.EMWS15TREE38_EMTREE.DATA does not exist and when I leave in TREEZ ERROR: File WORK.EMWS15TREEZ_EMTREE.DATA does not exist Either way, I don't see any *EMTREE* data in my directories. Any idea?

wave43 · ‎02-11-2016

This is exactly what I need! However, when I run the below code in the SAS code node, I am not seeing the three data sets you mentioned. I only see the file names below. Any thoughts? Thanks. .

wave43 · ‎02-10-2016

I have a large project in which I generated 400+ decision trees. I need to export the SAS Node Leaf dataset automatically from a node. I do not want to have to click "Save as" 400+ times. Is there a way I can export it as part of the model? Placing the control point at the end of the all the paths has been a great tool to generate all the trees "at once". Can I insert a node to export the leaf datasets before the control point? Also, is there a way to do this with the output which contain the fit statistics? Thanks.

Online Status	Offline
Date Last Visited	‎08-30-2017 09:21 AM

Re: Visual display of numeric variable before and after event

Visual display of numeric variable before and after event

SAS Enterprise Miner HP SVM Error

Re: proc SGPLOT vbox summary statistics (like proc boxplot)

proc SGPLOT vbox summary statistics (like proc boxplot)

Re: proc gchart (group % and overall % side by side)

Re: proc gchart (group % and overall % side by side)

proc gchart (group % and overall % side by side)

Re: SAS Miner: Export Leaf Table (without manually saving) from a node...

Re: SAS Miner: Export Leaf Table (without manually saving) from a node...

Re: proc SGPLOT vbox summary statistics (like proc boxplot)

Re: SAS Miner: Export Leaf Table (without manually saving) from a node...

proc SGPLOT vbox summary statistics (like proc boxplot)

Re: Visual display of numeric variable before and after event

Re: Visual display of numeric variable before and after event

Visual display of numeric variable before and after event

SAS Enterprise Miner HP SVM Error

Re: proc SGPLOT vbox summary statistics (like proc boxplot)

proc SGPLOT vbox summary statistics (like proc boxplot)

Re: proc gchart (group % and overall % side by side)

Re: proc gchart (group % and overall % side by side)

proc gchart (group % and overall % side by side)

Re: SAS Miner: Export Leaf Table (without manually saving) from a node...

Re: SAS Miner: Export Leaf Table (without manually saving) from a node...

Re: SAS Miner: Export Leaf Table (without manually saving) from a node...

Re: SAS Miner: Export Leaf Table (without manually saving) from a node...

Re: SAS Miner: Export Leaf Table (without manually saving) from a node...

Re: SAS Miner: Export Leaf Table (without manually saving) from a node...

SAS Miner: Export Leaf Table (without manually saving) from a node?