topic Re: Macro if then print in SAS Programming

Macro if then print

pritish069 — Tue, 20 Feb 2018 10:10:14 GMT

%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

Re: Macro if then print

RW9 — Tue, 20 Feb 2018 10:20:38 GMT

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;

Re: Macro if then print

pritish069 — Tue, 20 Feb 2018 11:15:47 GMT

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

Re: Macro if then print

RW9 — Tue, 20 Feb 2018 11:22:15 GMT

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

Re: Macro if then print

pritish069 — Tue, 20 Feb 2018 11:25:44 GMT

Thankyou!