Sorry if the title is confusing. I am trying to create a macro routine for two datasets, SASUSER.MOVIES and SASUSER.ACTORS. Below is the code that I've created: %LET DSN = SASUSER.MOVIES ; %LET DSN2 = SASUSER.ACTORS %LET VAR = TITLE ; %LET CLASS_VAR = Rating ; %MACRO stats ; proc means data=&DSN,&DSN2 maxdec=0 ; var &VAR ; class &CLASS_VAR ; run ; %MEND stats; %stats ; Also, when I tried to run it, the log produces 6 error messages: ERROR: Open code statement recursion detected. 76 %LET CLASS_VAR = Rating ; ERROR: Open code statement recursion detected. 77 %MACRO stats ; ERROR: Open code statement recursion detected. 78 proc means data=&DSN,&DSN2 maxdec=0 ; 79 var &VAR ; 79 var &VAR ; ___ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. 80 class &CLASS_VAR ; 80 class &CLASS_VAR ; _____ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. ERROR: No matching %MACRO statement for this %MEND statement. 81 run ; 82 %MEND stats ; 83 %stats ; How can I fixed this code so that it can run 2 different DSN's and allow me to work with the TITLE column/variable? Thanks in advance.
... View more