topic Re: using if last. if first. in SAS Programming

using if last. if first.

kindbe17 — Fri, 21 Apr 2023 07:58:36 GMT

Can i create a macro variable that will keep the largest value of NHITS from SASHELP.BASEBALL dataset using If Last. ?

i guess i am doing something wrong in my code above

data baseball_1;
set sashelp.baseball;
run;

proc sort data=baseball_1;
by name nhits;
run;

data m;
set Baseball_1;
by name;
if last.name then n=1;
call symputx('maxnhits', n);
proc print;
run;

Re: using if last. if first.

PeterClemmensen — Fri, 21 Apr 2023 08:05:01 GMT

Do you want the overall max in a macro variable or the max by some group?

Re: using if last. if first.

kindbe17 — Fri, 21 Apr 2023 08:13:34 GMT

i just want to create a macro variable that will keep the largest value of nhits, i think that value is 238 value from nhits variable, i dont know how to do that

Re: using if last. if first.

PeterClemmensen — Fri, 21 Apr 2023 08:17:11 GMT

You got several methods yesterday? The last. / fist. variables are not suitable for this purpose. They indicate By-Group Boundaries, not the end of an entire data set.

From yesterday:

data _null_;
   set sashelp.baseball end = z;
   if NHITS > n then n = NHITS;
   if z then call symputx('maxNHITS', n);
   retain n;
run;

%put &maxNHITS.;

Re: using if last. if first.

kindbe17 — Fri, 21 Apr 2023 08:18:40 GMT

i thought i will be able to use if last. too, now i got it, thank you so much.