From: toby dunn on 26 Jul 2007 11:26 do this: &datas._08 &datas._15 Basically you have to tell SAS when the ,acro name ends, other wise it tries to use the who string as the name, when it cant find the whole string in the local or global macro symbol table it throws an error. The clue in the log is: WARNING: Apparent symbolic reference DATAS_08 not resolved. It telling you that it cant find DATAS_08 in either symbol table to resolve it to a value. Toby Dunn If anything simply cannot go wrong, it will anyway. Murphys Law #2. The buddy system is essential to your survival; it gives the enemy somebody else to shoot at. Murphys Law # Tell a man there are 300 billion stars in the universe and he'll believe you. Tell him a bench has wet paint on it and he'll have to touch to be sure. Murphys Law #9 From: John Edward <entry_mid_level_sas(a)YAHOO.COM> Reply-To: John Edward <entry_mid_level_sas(a)YAHOO.COM> To: SAS-L(a)LISTSERV.UGA.EDU Subject: Re: A simple MACRO question: Date: Thu, 26 Jul 2007 11:15:05 -0400 The error is as belowas tobby asked for: 472 %MACRO select(datas = ); 473 474 Proc sort data = in_08.&datas 475 out = &datas_08; 476 By subjid; 477 run; 478 479 Proc sort data = in_15.&datas 480 out = &datas_15; 481 By subjid; 482 run; 483 484 data &datas; 485 set &datas_08 486 &datas_15; 487 By subjid; 488 run; 489 490 %MEND select; 491 492 %SELECT(datas = trt) NOTE: Line generated by the invoked macro "SELECT". 1 Proc sort data = in_08.&datas out = &datas_08; By subjid; run; Proc sort data = in_15.&datas out - 22 -------- 202 1 ! = &datas_15; By subjid; run; data &datas; set &datas_08 &datas_15; By subjid; run; WARNING: Apparent symbolic reference DATAS_08 not resolved. ERROR 22-322: Expecting a name. ERROR 202-322: The option or parameter is not recognized and will be ignored. NOTE: The SAS System stopped processing this step because of errors. WARNING: The data set WORK.DATAS_08 may be incomplete. When this step was stopped there were 0 observations and 0 variables. WARNING: Data set WORK.DATAS_08 was not replaced because this step was stopped. NOTE: PROCEDURE SORT used: real time 0.01 seconds cpu time 0.00 seconds 22: LINE and COLUMN cannot be determined. NOTE 242-205: NOSPOOL is on. Rerunning with OPTION SPOOL may allow recovery of the LINE and COLUMN where the error has occurred. ERROR 22-322: Expecting a name. 202: LINE and COLUMN cannot be determined. NOTE: NOSPOOL is on. Rerunning with OPTION SPOOL may allow recovery of the LINE and COLUMN where the error has occurred. ERROR 202-322: The option or parameter is not recognized and will be ignored. WARNING: Apparent symbolic reference DATAS_15 not resolved. NOTE: The SAS System stopped processing this step because of errors. WARNING: The data set WORK.DATAS_15 may be incomplete. When this step was stopped there were 0 observations and 0 variables. WARNING: Data set WORK.DATAS_15 was not replaced because this step was stopped. NOTE: PROCEDURE SORT used: real time 0.01 seconds cpu time 0.00 seconds 22: LINE and COLUMN cannot be determined. NOTE 242-205: NOSPOOL is on. Rerunning with OPTION SPOOL may allow recovery of the LINE and COLUMN where the error has occurred. ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, ;, END, KEY, KEYS, NOBS, OPEN, POINT, _DATA_, _LAST_, _NULL_. 202: LINE and COLUMN cannot be determined. NOTE: NOSPOOL is on. Rerunning with OPTION SPOOL may allow recovery of the LINE and COLUMN where the error has occurred. ERROR 202-322: The option or parameter is not recognized and will be ignored. 22: LINE and COLUMN cannot be determined. NOTE 242-205: NOSPOOL is on. Rerunning with OPTION SPOOL may allow recovery of the LINE and COLUMN where the error has occurred. ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, (, ;, END, KEY, KEYS, NOBS, OPEN, POINT, _DATA_, _LAST_, _NULL_. 202: LINE and COLUMN cannot be determined. NOTE: NOSPOOL is on. Rerunning with OPTION SPOOL may allow recovery of the LINE and COLUMN where the error has occurred. ERROR 202-322: The option or parameter is not recognized and will be ignored. WARNING: Apparent symbolic reference DATAS_08 not resolved. WARNING: Apparent symbolic reference DATAS_15 not resolved. NOTE: The SAS System stopped processing this step because of errors. WARNING: The data set WORK.TRT may be incomplete. When this step was stopped there were 0 observations and 26 variables. WARNING: Data set WORK.TRT was not replaced because this step was stopped. NOTE: DATA statement used: real time 0.01 seconds cpu time 0.00 seconds 493 RUN; _________________________________________________________________ http://newlivehotmail.com |