%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);
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: