I have this visualization where I am trying to print the plot based on 'by' variables. In order to specify which chart has which data, I am using #byline/#byval values to print them on top of chart using title statement. Issue is that a static 'title' statement is being printed on the pages and I am not able to pin point where it is coming from options nobyline leftmargin=.5in rightmargin=0.5in orientation=portrait nocenter; ODS PDF FILE = "&outfiles./PDF/Transaction_Bucket.pdf" gtitle dpi=300; ods graphics on / width=7in height=4.5in scale=on outputfmt=png; options nobyline; ods layout gridded columns=1 advance=table; title height=10pt color=dabgr 'Source = #byval2 and Transaction Bucket = #byval1'; PROC sgplot DATA = _01_E_TXN_CLM_; by BKT_TXN CLM_SOURCE; vbar weekof/ response=AMT y2axis datalabelattrs=(size=8 family="Arial") datalabel=AMTK fillattrs=(color=aquamarine); vline weekof/ response=TXN_CLM lineattrs=(color=red thickness=2) markerattrs=(symbol=CircleFilled color=red size=5) datalabel=TXN_CLM datalabelattrs=(size=8 family="Arial" color=red); xaxis label= "Weeks" labelattrs=(size=8 family="Arial") valueattrs=(size=8 family="Arial"); yaxis label= "TXN / CLM" labelattrs=(size=8 family="Arial") valueattrs=(size=8 family="Arial") GRID VALUES = (0 TO 2.5 BY 0.2); y2axis label= "Total Claim Amount" labelattrs=(size=8 family="Arial") valueattrs=(size=8 family="Arial"); keylegend / valueattrs=(size=8 family="Arial") location=outside position=BOTTOMRIGHT ; RUN; ods layout end; ODS PDF CLOSE; Please see the pdf to check for highlighted issue ... View more

Hi,   I have table of this structure with more than 1 flags, (have just 1 flag here for simplicity).   How do I create another table with no 'case 3' in it?  I want to remove all cases where FLAG_1 is 0(for all occurrence of that case), but not those where it's either 0,1 or 1   One option I can think of is by using MAX(FLAG_1) with group by 'Key' to create a table and then do right join. But I have several FLAG columns such as these and looking for some R, Python type of solution for concision.   Key FLAG_1 Conclusion case 2 0 include case 2 0 include case 2 1 include case 2 1 include case 3 0 remove case 3 0 remove case 3 0 remove case 4 1 include   ... View more

Hi,   I am trying to understand how exactly stepwise selections words in case of PROCREG.   According to the Documentation explanation of Stepwise selection. (My Questions are in bold and Italic)     "The stepwise method is a modification of the forward-selection technique and differs in that variables already in the model do not necessarily stay there. As in the forward-selection method, variables are added one by one to the model, and the F statistic for a variable to be added must be significant(greater than SLENTRY, or less than?) at the SLENTRY= level(Was the F statistics calculated independently or was it done after keeping it with dependent variable). After a variable is added, however, the stepwise method looks at all the variables already included in the model and deletes any variable that does not produce an F statistic significant at the SLSTAY= level. Only after this check is made and the necessary deletions are accomplished can another variable be added to the model. The stepwise process ends when none of the variables outside the model(What is meant by outside the model?) has an F statistic significant(less or more?) at the SLENTRY= level and every variable in the model is significant at the SLSTAY= level, or when the variable to be added to the model is the one just deleted from it.   Please explain this concept as you would to a 10 year old. I am just trying to understand what exactly SLENTRY, and SLSTAY do here. and How many times the F Statistics have been calculated.(How do they go from consideration to acceptance/rejection)?   Link to the documentation: https://support.sas.com/documentation/cdl/en/statug/63033/HTML/default/viewer.htm#statug_reg_sect030.htm ... View more

After running proc GLM with multiple regressors. I got the regressors and their Estimate, P, and T values.   I want to find out the best regressors for my model. how should I use P, T, or Estimate column to determine which regressors are best for my model.   Also, what is the meaning of Estimate, P, and T values in model output. Please help   this is how the output looks like   Dependent Parameter Estimate Biased StdErr tValue Probt ln_dep1 ln_rw_base*region_nm PACIFIC NORTHWEST 0.9604395696 0 0.00481642 199.41 0.0000 ln_dep1 ln_rw_base*region_nm PACIFIC CENTRAL 0.9601801559 0 0.00476460 201.52 0.0000 ln_dep1 ln_rw_base*region_nm NEW ENGLAND 0.9600740196 0 0.00479192 200.35 0.0000 ln_dep1 ln_rw_base*region_nm PACIFIC NORTH 0.9600171774 0 0.00475982 201.69 0.0000 ... View more

While running proc X12 on the time series data, I am getting following error   "Multiplicative or log additive seasonal adjustment cannot be performed when preadjustment factors are derived from a regARIMA model for data which have not been log transformed. Check the values for the POWER option of the TRANSFORM statement and MODE option of the X11 statement."   Any help with what this may imply? ... View more

I am getting following error while using an exogenous variable with X12. I cant post the code here   any guesses with that may be the reason?   "ERROR: Starting date for the span of the data, . , must begin on or after the starting date for user defined regression variables, JAN1960." ... View more

Hi,   so below is the structure of my program (pesudo code)   list =  [1,2,5], [2,4,6];   %macro someMacro (list)   %do list=1 to list=<lastIndex> when list = 1  access 1,2,5 in loop when list = 2 access 2,4,6 in loop   %mend someMacro()   someMacro(list) how do I impliment a sas macro with passing a list or array as a parameter to the macro? My problem is similar to this topic. http://support.sas.com/kb/26/155.html Only difference is that I need to pass more than 1 variable in one iteration. ... View more

Hi,   I have 5 regressors in the INPUT= and CROSSCORR= function of arima model, which is being iterated from 0 to 5 with the help of do-to loop.   when the loop starts from 0,0,0,0,0 for these 5 regressors, all the regressors are getting selected.   Is there a way where I can select only 3 or 4 combination of the regressors iteratively.   lets say if a,b,c,d,e are my 5 regressors, then at one step I would like to use combination of only 2 of these to run the model, then move forward to combination of 3, and then 4.    it is like a stepwise selection procedure if I am not wrong? ... View more

Dear programmers,   i would like to know which of the ods output <option> will give me the AIC, BIC component produced in the results. i will use iterations to take the model with least AIC and hence require them in a variable,   just like parameterEstimates where we can access p and t value, i want to know which <option> will produce the AIC numbers in variable.   i tried testing some of them but there is no output altogether in the output tab.     using SAS enterprise guide: version 6.1 M1 ... View more