I use the Results panel in the "SAS BASE 9.4" frequently to check the outputs of my previously executed procedures. where I can browse the outputs easily by looking for the desired output title. The output titles become very handy when you have submitted more than 100 procs or data steps in your session. (See snapshot A) But unfortunately when running procedures throughout "Rsubmit;" the results pane, titles all different procedures as "Rsubmit Output" making the Results pane quite inefficient to browse and use. (See snapshot B)   Any idea on how to get similar output on results pane to snapshot A, while using "Rsubmit" for submitting commands? Thanks, Sam   Please see below screenshots for details. Screenshot A: Screenshot A  Screenshot B Screenshot B ... View more

Hi, I am trying to predict an interval target (customer spend in $) using GLM in SAS EM 13.2. I have 80K observations and 300 variables. The problem that I have with the final model is that the minimum prediction for the target is around $50 whereas 11K of customers have spent less than $50 in the training dataset and 1% of customers have spent less than $1. Any thoughts on why is this happening or on how to fix it? The probability distribution that I have used in the GLM model is Gamma with a Log link function. I have also tried other prob. distributions as well as link functions like Tweedie or invert gaussian but Gamma with a log link function produced the smallest ASE. The distribution of Target variable is highly skewed on the right as there are plenty of customers spending lower amounts and only a few spending more than $1000. Any thoughts are highly appreciated, Thanks, Sam ... View more