Macro if then print

[pritish069]

%macro con (p=);
proc sort data=work.superstore;
by descending profit;
%if profit ge &p %then %do;
title 'Profit';
proc print data=work.superstore;
%end;
%mend;
run;

%con (p=500);

I want to print the data if the condition is met in the profit variable but the result i am getting is the entire table.

Thank you in advance

[RW9]

So you want to only print data where profit is the given value correct?

If so:

%let p=500;

proc sort data=work.superstore;
  by descending profit;
  where profit >= &p.;
run;
title "Profit";
proc print data=work.superstore;
run;

[pritish069]

I want the macro to sort and print where the profit is the given value

[RW9 · Accepted solution]

And did you try my code as that is what it does, or do you need to put the words macro in there?

%macro for_macros_sake (p=);

proc sort data=work.superstore;
  by descending profit;
  where profit >= &p.;
run;
title "Profit";
proc print data=work.superstore;
run;

%mend for_macros_sake;

%for_macros_sake (p=500);

[pritish069]

Thankyou!