The Correct code is bellow.   %macro mymacro; %let i=0; %let j=0; %do %until(&i>5); %do %until(&j>5); %let product=%sysevalf(&i*&j); %put The result is &product; %let j=%eval(&j+1); %end; %let i=%eval(&i+1); %end; %mend; %mymacro; The Macro compiler is called by a word processor in SAS. When you wrote a do in side a %do, SAS assumed that the do is a part of some other sas statement which will be used after the macro processing. That you can see if you try to execute the macro. You will get the following error. NOTE: Line generated by the invoked macro "MYMACRO". 85 do until(&j>5); __ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. The result is 0 NOTE: Line generated by the invoked macro "MYMACRO". 85 end; ___ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. NOTE: Line generated by the invoked macro "MYMACRO". 85 do until(&j>5); __ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. The result is 1 NOTE: Line generated by the invoked macro "MYMACRO". 85 end; ___ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. NOTE: Line generated by the invoked macro "MYMACRO". 85 do until(&j>5); __ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. The result is 4 . . . Macro is a very powerfull lnguage which can be mixed with BASE SAS to get results, but macro can not be mixed with BASE SAS utilities alone. ... View more

1. Invalid Variable name 23hrstay 2. cmiss or nmiss is the best way of doing your code   Please find the bellow approach.   option source source2 mprint; %macro runit; %let vars = admitdt dischargedt v_23hrstay hosp hospdt dob sex antimed rapidRT; %let v_count=%sysfunc(countw(&vars, ' ')); %put &=v_count; data want; set have; if %do i=1 %to &v_count.; %sysfunc(scan(&vars,&i)) %str(ne .) %if &i ne &v_count %then %str(or); %end;; run; %mend runit; %runit; Please let us know if it worked for you. ... View more

Please check the bellow code data WORK.EMPLOYEE_DATA_SAMPLE(label='employee_data_sample dataset written by Stat/Transfer Ver. 11.2.2106.0521 ' drop= fname lname); infile datalines dsd dlm=' ' truncover; input School:$7. FName:$17. LName:$17. Job:32. Year:32.; Name=strip(FName)||' '||strip(LName); datalines; SchoolA Smith, John 1 2009 SchoolA Doe, Jane 2 2009 SchoolA Cooper, Laura 3 2009 SchoolA Adams, Charlie 2 2009 SchoolA Anderson, Joyce 2 2009 SchoolA Bell, Anne 2 2009 SchoolA Abbott, Sharon 3 2009 SchoolB Lane, Gary 1 2009 SchoolB Nelson, Elizabeth 2 2009 SchoolB Bumpus, Toby 3 2009 SchoolB Doe, John 3 2009 SchoolB Smith, Jane 2 2009 SchoolB Richards, Simon 2 2009 SchoolB Tate, Lori 2 2009 SchoolB Bates, Linda 2 2009 SchoolB Pitt, Joel 3 2009 SchoolA Smith, John 1 2010 SchoolA Doe, Jane 2 2010 SchoolA Hill, Claire 3 2010 SchoolA Adams, Charlie 2 2010 SchoolA Arnold, Gayle 2 2010 SchoolA Bell, Anne 2 2010 SchoolA Abbott, Sharon 3 2010 SchoolA Bond, Connie 2 2010 SchoolB Lane, Gary 1 2010 SchoolB Nelson, Elizabeth 2 2010 SchoolB Bumpus, Toby 3 2010 SchoolB Doe, John 3 2010 SchoolB Anderson, Gilbert 2 2010 SchoolB Gately, Ronan 2 2010 SchoolB Tate, Lori 2 2010 SchoolB Bates, Linda 2 2010 SchoolB Pitt, Joel 3 2010 SchoolB Jeffords, Jim 2 2010 ;;;; run; proc sort data=work.employee_data_sample; by School Job Name Year; run; data want; set employee_data_sample; by School Job Name Year; if first.name then year_count=0; year_count+1; if last.name then output; run; proc sql; create table turnover_rate as select a.job, round(sum(a._total, -1*b._remains)/a._total*100,0.01) as _remains from (select Job,count(*) as _total from want group by Job) a left join (select Job,count(*) as _remains from want where year_count=1 and Year=2009 group by Job) b on a.job=b.job; quit; Please let us know if it worked for you. ... View more

Please let us know if it worked for you. proc sql; create table result as select s1.a, s1.b, s2.e /*,s2.c,s2.d*/ from sample1 s1, sample2 s2 where s1.b ge s2.c and s1.b le s2.d; quit; ... View more

Please let us know if it worked for you data emails; input emails:$200.; id=_n_; /*This is one way of Iding, there are several other ways*/ cards; sai@gmail.com kiran@gmail.com ; run; %macro mac(no=); data _null_; set emails; where id=&no; call symput('email',emails); stop; run; %put &=email; /****Add Email Sending Code Here****/ %mend mac; %mac(no=1); %mac(no=2); ... View more