Thanks a lot Reeza.   Finally identified what made that line and column error.   i was calling the spds macro like "spds()" that is with paranthesis.   Once i removed the paranthesis it worked perfect.   below is the code. I'm wondering if you could explain what does that paranthesis mean will be helpful to me as well as the community.   %macro spDS; %local dsCnt inlibref inmember i; proc sql noprint ; select count(*)into :dsCnt from sashelp.vtable where libname='SERETIDE' ; quit; %let i=1; %do i = &i %to &dscnt; data _null_; set sashelp.vtable (where=(libname='SERETIDE') firstobs=&i obs=&i); call symput("inlibref",strip(libname)); call symput("inmember",strip(memname)); run; proc sort data=&inlibref..&inmember. out= strans.&inmember. (drop = subjectstatus form formentrydate subjectvisitformid); by subjectid; run; %end; %mend; %spDS; ... View more

not completely getting your point if you could give a sample code will be helpful ... View more

Hi   You were suggesting there are other ways to achieve the same i'm trying to achieve. if you could hint something it will be helpful. ... View more

Yep  included the firstobs and obs now getting the same 180 error.   i tried for 1 dataset to 5 dataset.   Also, tried for only one dataset still getting the same error. ... View more

options mprint mlogic symbolgen; %macro spDS; %local dsCnt inlibref inmember i; proc sql noprint ; select count(*) into :dsCnt from sashelp.vtable where libname='SERETIDE' ; quit; %let i=1; %do i = &i %to 5; data _null_; set sashelp.vtable (where=(libname='SERETIDE')); call symput("inlibref",strip(libname)); call symput("inmember",strip(memname)); run; proc sort data=&inlibref..&inmember. out = strans..&inmember (drop = subjectstatus form formentrydate subjectvisitformid); by subjectid; run; %end; %mend; %spDS(); Revised code with 5 iterations, got a whole different error.   1. The inmember resolves to the last dataset during the first iteration itself as VS (so only this dataset is sorted and saved in strans library 2. Next in the out= option the macro call of inmember causing the issue.   Attached the bit long log to review from begining of the loop.     ... View more

I tried retyping the code completely in as new program and also restarted the sas session but still no luck. ... View more

options mprint mlogic symbolgen; %macro spDS; %local dsCnt inlibref inmember i; proc sql noprint ; select count(*)into :dsCnt from sashelp.vtable where libname='SERETIDE' ; quit; %let i=1; %do i = &i %to &dscnt; data _null_; set sashelp.vtable (where=(libname='SERETIDE')); call symput("inlibref",strip(libname)); call symput("inmember",strip(memname)); run; proc sort data=&inlibref..&inmember. out= strans.&inmember. (drop = subjectstatus form formentrydate subjectvisitformid); by subjectid; run; /* %let i=%eval(&i.+1); */ %end; %mend; %spDS(); MLOGIC(SPDS): %DO loop index variable I is now 23; loop will iterate again. MPRINT(SPDS): data _null_; MPRINT(SPDS): set sashelp.vtable (where=(libname='SERETIDE')); MPRINT(SPDS): call symput("inlibref",strip(libname)); MPRINT(SPDS): call symput("inmember",strip(memname)); MPRINT(SPDS): run; NOTE: There were 23 observations read from the data set SASHELP.VTABLE. WHERE libname='SERETIDE'; NOTE: DATA statement used (Total process time): real time 0.53 seconds cpu time 0.54 seconds SYMBOLGEN: Macro variable INLIBREF resolves to SERETIDE SYMBOLGEN: Macro variable INMEMBER resolves to VS SYMBOLGEN: Macro variable INMEMBER resolves to VS MPRINT(SPDS): proc sort data=SERETIDE.VS out= strans.VS (drop = subjectstatus form formentrydate subjectvisitformid); MPRINT(SPDS): by subjectid; MPRINT(SPDS): run; NOTE: There were 660 observations read from the data set SERETIDE.VS. NOTE: The data set STRANS.VS has 660 observations and 14 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.09 seconds cpu time 0.01 seconds 180: LINE and COLUMN cannot be determined. NOTE: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where the error has occurred. ERROR 180-322: Statement is not valid or it is used out of proper order. MLOGIC(SPDS): %DO loop index variable I is now 24; loop will not iterate again. MLOGIC(SPDS): Ending execution. 86 87 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; SYMBOLGEN: Macro variable GRAPHTERM resolves to GOPTIONS NOACCESSIBLE; 99 ... View more

 Yes I have attached the log previously with all options enabled.   Here it goes again. MLOGIC(SPDS): %LET (variable name is I) SYMBOLGEN: Macro variable I resolves to 21 SYMBOLGEN: Macro variable I resolves to 22 SYMBOLGEN: Macro variable DSCNT resolves to 23 MLOGIC(SPDS): %DO %WHILE(&i <= &dscnt) condition is TRUE; loop will iterate again. MPRINT(SPDS): data _null_; SYMBOLGEN: Macro variable I resolves to 22 SYMBOLGEN: Macro variable I resolves to 22 MPRINT(SPDS): set sashelp.vtable (where=(libname='SERETIDE') firstobs=22 obs=22 ); MPRINT(SPDS): call symput("inlibref",strip(libname)); MPRINT(SPDS): call symput("inmember",strip(memname)); MPRINT(SPDS): run; NOTE: There were 1 observations read from the data set SASHELP.VTABLE. WHERE libname='SERETIDE'; NOTE: DATA statement used (Total process time): real time 0.05 seconds cpu time 0.06 seconds SYMBOLGEN: Macro variable INLIBREF resolves to SERETIDE SYMBOLGEN: Macro variable INMEMBER resolves to SV SYMBOLGEN: Macro variable INMEMBER resolves to SV MPRINT(SPDS): proc sort data=SERETIDE.SV out= strans.SV (drop = subjectstatus form formentrydate subjectvisitformid); MPRINT(SPDS): by subjectid; MPRINT(SPDS): run; NOTE: There were 120 observations read from the data set SERETIDE.SV. NOTE: The data set STRANS.SV has 120 observations and 10 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.04 seconds cpu time 0.00 seconds MLOGIC(SPDS): %LET (variable name is I) SYMBOLGEN: Macro variable I resolves to 22 SYMBOLGEN: Macro variable I resolves to 23 SYMBOLGEN: Macro variable DSCNT resolves to 23 MLOGIC(SPDS): %DO %WHILE(&i <= &dscnt) condition is TRUE; loop will iterate again. MPRINT(SPDS): data _null_; SYMBOLGEN: Macro variable I resolves to 23 SYMBOLGEN: Macro variable I resolves to 23 MPRINT(SPDS): set sashelp.vtable (where=(libname='SERETIDE') firstobs=23 obs=23 ); MPRINT(SPDS): call symput("inlibref",strip(libname)); MPRINT(SPDS): call symput("inmember",strip(memname)); MPRINT(SPDS): run; NOTE: There were 1 observations read from the data set SASHELP.VTABLE. WHERE libname='SERETIDE'; NOTE: DATA statement used (Total process time): real time 0.05 seconds cpu time 0.03 seconds SYMBOLGEN: Macro variable INLIBREF resolves to SERETIDE SYMBOLGEN: Macro variable INMEMBER resolves to VS SYMBOLGEN: Macro variable INMEMBER resolves to VS MPRINT(SPDS): proc sort data=SERETIDE.VS out= strans.VS (drop = subjectstatus form formentrydate subjectvisitformid); MPRINT(SPDS): by subjectid; MPRINT(SPDS): run; NOTE: There were 660 observations read from the data set SERETIDE.VS. NOTE: The data set STRANS.VS has 660 observations and 14 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.03 seconds cpu time 0.01 seconds MLOGIC(SPDS): %LET (variable name is I) SYMBOLGEN: Macro variable I resolves to 23 SYMBOLGEN: Macro variable I resolves to 24 SYMBOLGEN: Macro variable DSCNT resolves to 23 180: LINE and COLUMN cannot be determined. NOTE: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where the error has occurred. ERROR 180-322: Statement is not valid or it is used out of proper order. MLOGIC(SPDS): %DO %WHILE() condition is FALSE; loop will not iterate again. MLOGIC(SPDS): Ending execution. 86 87 88 89 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; SYMBOLGEN: Macro variable GRAPHTERM resolves to GOPTIONS NOACCESSIBLE; ... View more

apologies you mean only mprint? ... View more

for some reason the macro variable 'i' referred to 'obs=' resolves to 24 after the last iteration. ... View more

code   %macro spDS; %local dsCnt inlibref inmember i; proc sql noprint ; select count(*)into :dsCnt from sashelp.vtable where libname='SERETIDE'; quit; %let i=1; %do %while (&i <= &dscnt); data _null_; set sashelp.vtable (where=(libname='SERETIDE') firstobs=&i. obs=&i. ); call symput("inlibref",strip(libname)); call symput("inmember",strip(memname)); run; proc sort data=&inlibref..&inmember. out= strans.&inmember. (drop = subjectstatus form formentrydate subjectvisitformid); by subjectid; run; %let i=%eval(&i.+1); %end; %mend; options mprint; %spDS(); MLOGIC(SPDS): %LET (variable name is I) SYMBOLGEN: Macro variable I resolves to 22 SYMBOLGEN: Macro variable I resolves to 23 SYMBOLGEN: Macro variable DSCNT resolves to 23 MLOGIC(SPDS): %DO %WHILE(&i <= &dscnt) condition is TRUE; loop will iterate again. MPRINT(SPDS): data _null_; SYMBOLGEN: Macro variable I resolves to 23 SYMBOLGEN: Macro variable I resolves to 23 MPRINT(SPDS): set sashelp.vtable (where=(libname='SERETIDE') firstobs=23 obs=23 ); MPRINT(SPDS): call symput("inlibref",strip(libname)); MPRINT(SPDS): call symput("inmember",strip(memname)); MPRINT(SPDS): run; NOTE: There were 1 observations read from the data set SASHELP.VTABLE. WHERE libname='SERETIDE'; NOTE: DATA statement used (Total process time): real time 0.05 seconds cpu time 0.03 seconds SYMBOLGEN: Macro variable INLIBREF resolves to SERETIDE SYMBOLGEN: Macro variable INMEMBER resolves to VS SYMBOLGEN: Macro variable INMEMBER resolves to VS MPRINT(SPDS): proc sort data=SERETIDE.VS out= strans.VS (drop = subjectstatus form formentrydate subjectvisitformid); MPRINT(SPDS): by subjectid; MPRINT(SPDS): run; NOTE: There were 660 observations read from the data set SERETIDE.VS. NOTE: The data set STRANS.VS has 660 observations and 14 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.03 seconds cpu time 0.01 seconds MLOGIC(SPDS): %LET (variable name is I) SYMBOLGEN: Macro variable I resolves to 23 SYMBOLGEN: Macro variable I resolves to 24 SYMBOLGEN: Macro variable DSCNT resolves to 23 180: LINE and COLUMN cannot be determined. NOTE: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where the error has occurred. ERROR 180-322: Statement is not valid or it is used out of proper order. MLOGIC(SPDS): %DO %WHILE() condition is FALSE; loop will not iterate again. MLOGIC(SPDS): Ending execution. 58 59 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; SYMBOLGEN: Macro variable GRAPHTERM resolves to GOPTIONS NOACCESSIBLE; ... View more

IF i use Do loop then i'm getting the same error. ... View more

There is only 23 datasets in the library, but it also contains other files like .txt, .zip, .sas files as well.   Is that a problem ?   if yes how do i explicitly say only to sort sas7bdat files ... View more

MLOGIC(SPDS): %LET (variable name is I) SYMBOLGEN: Macro variable I resolves to 23 SYMBOLGEN: Macro variable I resolves to 24 SYMBOLGEN: Macro variable DSCNT resolves to 23 180: LINE and COLUMN cannot be determined. NOTE: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where the error has occurred. ERROR 180-322: Statement is not valid or it is used out of proper order. MLOGIC(SPDS): %DO %WHILE() condition is FALSE; loop will not iterate again. MLOGIC(SPDS): Ending execution. 58 59 60 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; SYMBOLGEN: Macro variable GRAPHTERM resolves to GOPTIONS NOACCESSIBLE; 72 ... View more

The iterations are complete and datasets were sorted but after the last iteration the below error is occuring.   MLOGIC(SPDS): %LET (variable name is I) MLOGIC(SPDS): %DO %WHILE(&i. <= &dsCnt.) condition is TRUE; loop will iterate again. NOTE: There were 1 observations read from the data set SASHELP.VTABLE. WHERE libname='SERETIDE'; NOTE: DATA statement used (Total process time): real time 0.05 seconds cpu time 0.03 seconds NOTE: There were 660 observations read from the data set SERETIDE.VS. NOTE: The data set STRANS.VS has 660 observations and 14 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.03 seconds cpu time 0.00 seconds MLOGIC(SPDS): %LET (variable name is I) 180: LINE and COLUMN cannot be determined. NOTE: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where the error has occurred. ERROR 180-322: Statement is not valid or it is used out of proper order. MLOGIC(SPDS): %DO %WHILE() condition is FALSE; loop will not iterate again. MLOGIC(SPDS): Ending execution. 87 88 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 100 ... View more