topic Re: To write a code that finds the max amount before the last amount in do until loop in SAS Programming

To write a code that finds the max amount before the last amount in do until loop

GN0001 — Wed, 12 May 2021 04:02:54 GMT

Hello team,

I have a code and I want to write a code that finds the max amount before the last amount in do until loop? I can eye ball and say what it is. How can I do this by writing code?

Thanks,

Blue Blue

data salyr;  
input salary year;  
cards;  
134 2019  
run;

data increaseit;
set salyr;
do until (salary gt 1000);
salary = salary + salary * 0.06;
year = year + 1;
output;
end;
Run;

Re: To write a code that finds the max amount before the last amount in do until loop

japelin — Wed, 12 May 2021 04:16:10 GMT

For example.

data increaseit;
  set salyr;
  do until (salary gt 1000);
    salary = salary + salary * 0.06;
    year = year + 1;
    if not(salary gt 1000) then output;
  end;
Run;

Re: To write a code that finds the max amount before the last amount in do until loop

Sajid01 — Wed, 12 May 2021 11:49:18 GMT

Hello @GN0001
Do you want the max value or the total sum?
Your code is creating a sum. The following code will help in deciding what you need sum or max value.

proc sql;
select max(weight) as MAX_WT, sum(Weight) as SUM_WT from sashelp.class;
quit;

The output will be like this

Re: To write a code that finds the max amount before the last amount in do until loop

GN0001 — Thu, 13 May 2021 04:42:45 GMT

Hello kawakami,
Thanks for the response!
This outputs everything less than 1000.
I need only one observation: only the first observation which is less than 1000.
Please let me know if this makes sense.
Respectfully,
Blue Blue

Re: To write a code that finds the max amount before the last amount in do until loop

GN0001 — Thu, 13 May 2021 04:46:27 GMT

Thanks for the response.
No, I don't want a sum.
Regards,
Blue Blue

Re: To write a code that finds the max amount before the last amount in do until loop

japelin — Thu, 13 May 2021 06:38:02 GMT

How about this two codes?

Store in other variable for the last observation

data increaseit;
  set salyr;
  do until (salary gt 1000);
    salary = salary + salary * 0.06;
    year = year + 1;
    output;
    salary2=salary;
  end;
Run;

Sort and flag the second one.

proc sort data=increaseit out=temp;
  by descending year;
run;
data want;
  set temp;
  by descending year;
  if _n_=2 then flg=1;
run;
proc sort data=want;
  by year;
run;

Re: To write a code that finds the max amount before the last amount in do until loop

Sajid01 — Thu, 13 May 2021 12:04:15 GMT

Make the following change to the second part.

Instead of if _n_=2 then flg=1; use if _n_=2 then output;

The want data set will have only one record. I am giving a sample code below

data salary;
input salary year;
datalines;
200 1990
;
run;
data increaseit;
  set salary;
  do until (salary gt 1000);
    salary = salary + salary * 0.06;
    year = year + 1;
    if not(salary gt 1000) then output;
  end;
Run;
proc sort data=increaseit out=temp;
  by descending year;
run;
data want;
  set temp;
  by descending year;
  if _n_=2 then output;
run;
proc print data=want;
run;

The out put will