proc reg data = abc;
model &dep = &indep;
However, when I am trying to add option of producing standardized coeff. I am getting following error message. ..
proc reg data = abc;
model &dep = &indep /stb;
NOTE: The previous statement has been deleted.
SYMBOLGEN: Macro variable COMMENTED resolves to by Global_Segment
MPRINT(REGRESS): /stb by Global_Segment ;
NOTE: Line generated by the invoked macro "REGRESS".
189 model &dep = &indep /stb; &commented ; RUN;
ERROR 180-322: Statement is not valid or it is used out of proper order.
NOTE: Interactivity disabled with BY processing.
NOTE: PROCEDURE REG used (Total process time):
real time 0.13 seconds
cpu time 0.12 seconds
It would be helpful if you could supply the full code including your macro definition statements and macro call statement. The MPRINT evidence is suggesting that &commented may contain the text BY as well as the BY variable. If it is this should be removed.
The "interactivity disabled" note just means that you were being warned that interactive mode (for PROC REG) was no longer in effect. (Also you did not correctly end the PROC REG step with a QUIT statement for batch processing.) As this Tech Support note says: http://support.sas.com/kb/37/105.html
The ANOVA, ARIMA, CATMOD, FACTEX, GLM, MODEL, OPTEX, PLAN, and REG procedures are interactive procedures. They remain active after processing a RUN statement. The "running" message in the banner of the program editor window alerts you to the fact that these procedures are still active. More statements can be submitted as a continuation of the previous statements. A new group of statements can be executed by submitting them along with a RUN statement. These procedures remain active until a DATA step or another procedure is executed, or if a QUIT statement is submitted. In many cases, interactivity is disabled when a BY statement is specified.
I doubt that the "interactivity disabled" was the cause of the problem with your macro program. At this point, seeing your whole macro program (what's between the %MACRO and %MEND) will be most useful and then showing how you're invoking the macro program that you've defined will also be useful. At this point, a verbal description of the your ultimate goal and what you think the macro is doing would also be helpful.