Can anyone please give an example where a do loop can be used but %do loop cannot be used
Hi..
%Do can be used only with in the Macro,but in case of Do,you can use any where of the program even with in the macro.
which means you can not use %do in open code..
Data Test;
%do i=1 %to 10;
output;
%end;
Run;
Above code gives you error,so in above scenario you need to use Do.
Hope this helps..
Regards.
Sanjeev.K
Edited my post and given small example too..
Hope that is what you looking for..
Regards.
Sanjeev.K
You can do it:
do i=1 to 10 by 0.1 ;
But you can not do it:
%do i=1 %to 10 by 0.1;
thank u
do i=1,2,3; will work
%do i=1,2,3; will give an error
Ohhh too good to know that..
But why we can't use By in %do ??
is there any reason ???
Regards.
Sanjeev.K
You can use %BY, but you can't use a decimal fraction like 0.1.
The last construction where DO can be used but %DO cannot is a combination of a range with WHILE or UNTIL.
Legitimate: do i=1 to 10 until (age > 21);
No good: %do i=1 %to 10 %until (&age > 21);
You can use %DO %WHILE or %DO %UNTIL, you just can't combine that with a range of values.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.