Thank You Guys My issue is solved now ... View more

This is also not working! ... View more

%macro update(); data new1; %do i=9 %to 13; %do j=1 %to 12; %if %length(&i)=1 %then %let yr=%eval(200&i); %else %let yr=%eval(20&i); %if %length(&j)=1 %then mnth=%str(0&j); %else %let mnth=%eval(&j); %let vname=&yr&mnth; %put &vname.; %end; %end; %mend; %update; ... View more

That is ok but can you help me on this part:- %if %length(&j)=1 %then mnth=%str(0&j); %else %let mnth=%eval(&j); As i want to have 0 been appended before a single digit to get 01, 02, 03...likewise.. so that i could append to the year like 200901, 200902..so on... Hope you understand now! ... View more

%macro update(); data new1; %do i=9 %to 13; %do j=1 %to 12; %if %length(&i)=1 %then %let yr=%eval(200&i); %else %let yr=%eval(20&i); %if %length(&j)=1 %then mnth=%str(0&j); %else %let mnth=%eval(&j); %let vname=&yr&mnth; %put &vname.; %end; %end; %mend; %update; ERROR:- 201312 NOTE 137-205: Line generated by the invoked macro "UPDATE". 690         mnth=0&j             ____             22 ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, *, **, +, -, /, ;, <, <=, <>, =, >, ><, >=, AND, EQ, GE, GT,               IN, LE, LT, MAX, MIN, NE, NG, NL, NOTIN, OR, ^=, |, ||, ~=.  201312 201310 201311 132                                                        The SAS System                              09:51 Wednesday, June 5, 2013 201312 NOTE 137-205: Line generated by the invoked macro "UPDATE". 690         mnth=0&j             ____             22 ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, *, **, +, -, /, ;, <, <=, <>, =, >, ><, >=, AND, EQ, GE, GT,               IN, LE, LT, MAX, MIN, NE, NG, NL, NOTIN, OR, ^=, |, ||, ~=.  691        ... View more

Yes, i tried, Its not working ! ... View more

The issue is that it says apprent symbol not resolved. I want the output as :- 200901 200902 200903 . . . 201312 ... View more

Ignore the earlier one:- This below is the updated code:- %macro update(); %do i=9 %to 13;    %do j=1 %to 12; %if %length(&i)=1 %then %let yr=200&i; %else yr=20&i; %if %length(&j)=1 %then %let mn=0&j.; %else mn=&j; %let vname=&yr&mn; %end; %end; %mend; %update; ... View more

This will work try:- %macro t; %do i =1 %to 3 ; libname rs&i "/shared/BatchServer"; data rs&i..t&i.; x=&i; run; %end; %mend; %t; %macro dd; proc sql; drop table mpp; quit %do i =1 %to 3 ; libname rs&i "/shared/BatchServer"; ; proc append base=mpp data= rs&i..t&i.; run; %end; %mend; %dd; /Daman ... View more