topic Creating Macro Value in SAS Programming

Creating Macro Value

kindbe17 — Thu, 20 Apr 2023 08:14:09 GMT

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

Re: Creating Macro Value

PeterClemmensen — Thu, 20 Apr 2023 08:17:21 GMT

Try this

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

%put &maxNHITS.;

Re: Creating Macro Value

kindbe17 — Thu, 20 Apr 2023 08:19:46 GMT

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

Re: Creating Macro Value

PeterClemmensen — Thu, 20 Apr 2023 08:25:22 GMT

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

Re: Creating Macro Value

kindbe17 — Thu, 20 Apr 2023 09:08:58 GMT

Thank you so much Peter 🙂

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

Re: Creating Macro Value

Kurt_Bremser — Thu, 20 Apr 2023 09:13:23 GMT

Instead of

if NHITS > n then n = NHITS;

I would use

n = max(n,nhits);