https://communities.sas.com/t5/SAS-Programming/Macro-s/m-p/10037#M659 Rename your datasets all with the same prefix, like DS1, DS2...DS10.<BR /> <BR /> %macro sortit;<BR /> <BR /> %do i = 1 to 10;<BR /> proc sort data=ds&amp;i;<BR /> by var1 var2...;<BR /> run;<BR /> %end;<BR /> %mend<BR /> <BR /> %sortit; Tue, 15 Apr 2008 17:05:53 GMT JasonDiVirgilio 2008-04-15T17:05:53Z https://communities.sas.com/t5/SAS-Programming/Macro-s/m-p/10036#M658 1.I have 10 datasets i want to sort all datasets at a time by using single Proc sort procedure in macro's? Wed, 09 Apr 2008 11:24:18 GMT https://communities.sas.com/t5/SAS-Programming/Macro-s/m-p/10036#M658 deleted_user 2008-04-09T11:24:18Z https://communities.sas.com/t5/SAS-Programming/Macro-s/m-p/10037#M659 Rename your datasets all with the same prefix, like DS1, DS2...DS10.<BR /> <BR /> %macro sortit;<BR /> <BR /> %do i = 1 to 10;<BR /> proc sort data=ds&amp;i;<BR /> by var1 var2...;<BR /> run;<BR /> %end;<BR /> %mend<BR /> <BR /> %sortit; Tue, 15 Apr 2008 17:05:53 GMT https://communities.sas.com/t5/SAS-Programming/Macro-s/m-p/10037#M659 JasonDiVirgilio 2008-04-15T17:05:53Z