topic Re: Do loop run one extra step and duplicate last result in SAS Programming

Do loop run one extra step and duplicate last result

IgorR — Tue, 01 Aug 2023 11:36:46 GMT

Hi,

This is the code, which excepted to return numbers from 1 to 40 in "Cohort" column,

but from some reason returns numbers to 41 and duplicate the last result in "FV" column.

What do I miss?

%let Grossid = 1;
%let DmeiNihul = 0.014;
%let NetPremium = 94;

Data A;

Target = 0;
Rate   = (1+0)/(1+&Grossid*&DmeiNihul)-1;

do Period = 1 to 4;
	do Cohort = 1 to 40;
		If Period = 1 Then
     		do;
           	If Target = 0 Then
                FV = 0;
           	Else FV = Finance('PV',rate,Cohort,&NetPremium*(-1),0,1)*(1+rate)**cohort;
     		end;
		Else FV = Finance('PV',rate,Cohort,&NetPremium*(-1),0,1)*(1+rate)**cohort;
		output;
	end;
	output;
end;

run;

Re: Do loop run one extra step and duplicate last result

PaigeMiller — Tue, 01 Aug 2023 11:44:23 GMT

Remove the last output; statement

Re: Do loop run one extra step and duplicate last result

sbxkoenk — Tue, 01 Aug 2023 11:45:59 GMT

Hello,

If you get rid of the last output; statement (run; line minus 2).

Does that give you what you want?
At least there's no cohort 41 then.

Koen

Re: Do loop run one extra step and duplicate last result

IgorR — Tue, 01 Aug 2023 11:55:21 GMT

Thank you!

Re: Do loop run one extra step and duplicate last result

IgorR — Tue, 01 Aug 2023 11:56:23 GMT

Thank you!

It works.