I'm trying to add a value to do loop variable within a macro. However it keeps failing. Here is my code:
%macro base (yr);
%do i=10 %to &yr;
proc sort data=lib.den(&i+1).pzr out=ID_20(&i+1);by unique_id;run; proc sort data=lib.den&i.pzr out=den_20&i;by unique_id;run;
%end;
%mend;
%base (14);
All the errors appear to be around the parenthesis
The error I get is this:
ERROR 22-322: Syntax error, expecting one of the following: ;, ASCII, BUFFNO, DANISH, DATA, DATECOPY, DETAILS, DIAG, DUPOUT, EBCDIC, EQUALS, FINNISH, FORCE, IN, ISA, L, LEAVE, LIST, MESSAGE, MSG, NATIONAL, NODUP, NODUPKEY, NODUPKEYS, NODUPLICATE, NODUPLICATES, NODUPREC, NODUPRECS, NODUPS, NOEQUALS, NORWEGIAN, NOTHREADS, NOUNIKEY, NOUNIKEYS, NOUNIQUEKEY, NOUNIQUEKEYS, NOUNIQUEREC, NOUNIQUERECS, NOUNIREC, NOUNIRECS, OSA, OUT, OVERWRITE, PAGESIZE, PRESORTED, PSIZE, REVERSE, SIZE, SORTSEQ, SORTSIZE, SORTWKNO, SWEDISH, T, TAGSORT, TECH, TECHNIQUE, TESTHSI, THREADS, UNIOUT,
I'm trying to grab the current year of data I'm intersted in and the next years of data. Thanks for any insight!
... View more