topic Re: why it is 2 and 7 ? in SAS Programming

why it is 2 and 7 ?

tianerhu — Sat, 16 Apr 2022 02:12:55 GMT

Rewrite the following program using %LET to assign the starting and ending values
of the DO loop to macro variables. Be sure these values also print in the PROC
PRINT output.

data sqrt_table;
do n = 1 to 5;
Sqrt_n = sqrt(n);
output;
end;
run;
title "Square Root Table from 1 to 5";
proc print data=sqrt_table noobs;
run;

the following is the answer:

%let start = 2;
%let stop = 7;

data sqrt_table;
   do n = &start to &stop;
      Sqrt_n = sqrt(n);
      output;
   end;
run;

title "Square Root Table from &start to &stop";
proc print data=sqrt_table noobs;
run;

why the 'start'=2 and 'end'=7 ?

Re: why it is 2 and 7 ?

ballardw — Sat, 16 Apr 2022 03:22:10 GMT

I don't see an "end"; I see a "stop".

Why 2 and 7? ask the author. May be to show that if you use

%let start = 1;
%let stop = 5;

It duplicates the output from the first data step and that changing the values changes the output.

Re: why it is 2 and 7 ?

Rick_SAS — Sat, 16 Apr 2022 10:24:05 GMT

Don't doubt yourself. If the first program you post is correct, then you can duplicate it by using the second DATA step and

%let start = 1; %let stop = 5;

Re: why it is 2 and 7 ?

tianerhu — Sat, 16 Apr 2022 13:15:16 GMT

sorry , it is 'stop' instead of 'end'.

Re: why it is 2 and 7 ?

tianerhu — Sat, 16 Apr 2022 13:18:49 GMT

Thank you for your help.

Re: why it is 2 and 7 ?

tianerhu — Sat, 16 Apr 2022 13:19:58 GMT

Thank you for your help ..