Creating Macro Value

[kindbe17]

Can you help me to Create a macro variable that will keep the largest value of NHITS from SASHELP.BASEBALL dataset.?

[PeterClemmensen]

Try this

proc sql noprint;
   select max(NHITS) 
   into :maxNHITS
   from sashelp.baseball
   ;
quit;

%put &maxNHITS.;

[kindbe17]

Sir, is there any chance to solve this without using SQL ?

[PeterClemmensen · Accepted solution]

Sure. But why?

Do you have a preferred method?

Here is a pure data step approach

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.;

[kindbe17]

Thank you so much Peter 🙂

The SQL will be my next lesson that's why i asked you that.

[Kurt_Bremser]

Instead of

if NHITS > n then n = NHITS;

I would use

n = max(n,nhits);