I have an SQL Program like with field names   Proc SQL; Select var1,            var2,            var3,            31JAN2017,            28FEB2017,            31MAR2017,            30APR2017,            31MAY2017 from table1; quit;   Lets assume I am currently in the month of June2017 and my reporting month is May2017, if my month changes to Jul 2017, I need to add 30JUN2017 as a variable in the table. Instead of adding mannually I need to automate using macro. I tried this below    %macro loop;                                                                                                                                                                                       %do i=0 %to 11;                                                                                                                                                                                  %let date1=%sysfunc(intnx(month, '01JAN2017'd, &i. ,e), date9.);                                                                                                                                   %put &date1.;                                                                                                                                                                                     %end;                                                                                             %mend;                                                                                                                                                                                                %loop;   But it just added values in the log. How can I create macro to add the variable automatically from 31JAN2017 to reporting month. Similarly if the month is JAN 2017 I need it from 31JAN2016 to 31DEC2016 as variables to be added in the select table variables   31JAN2017                                                                                             28FEB2017                                                                                             31MAR2017                                                                                             30APR2017                                                                                             31MAY2017                                                                                             30JUN2017                                                                                             31JUL2017                                                                                             31AUG2017                                                                                             30SEP2017                                                                                             31OCT2017                                                                                             30NOV2017                                                                                             31DEC2017   ... View more

Suppose if I have a sample size which is less than 200. What is the best regression technique I can use .. for linear regression ..   KS Statistics with ten decile Poison? linear regression?   Sameer ... View more

Suppose if we have a categorical variable called zip codes and it has too many levels which is affecting the model. What is the most appropiate method to reduce the level of zipcodes in the logistic regression model.   Use greencase method? Dummy variables? Make it continous by reducing levels? Frequency method?   How would anyone deal with it? Is greencase method appropriate to reduce the levels of zip code?   Sameer ... View more

A non-contributing predictor variable whose P value is more than .50 is added to an existing multiple linear regression model. It will increase R2 value. I want to know if the same variable is removed from the regression model what will happen?   R2 value going down or no change in R2 value or will it affect mean square error.   Take an example we remove non significant variables in backward elimination method in SAS.. does this reduce r2 value if we remove non significant predictor variable?   Sameer    ... View more

Hello! Which statistical technique is used for model selection from the regression model (multiple linear regression). Adjusted R Square or Mallow's CP or Average Squared Error? which one is the most reliable one while choosing the model? Sameer Shaikh ... View more