%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
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);
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;
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);
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.