Is there a way to use proc datasets and delete with certain conditions?
For example, I have dataset A and I want to delete if it the mean of one of its variables is less than a certain number. I have that mean stored in a macro variable.
I notice that it wont let me put a regular if statement in proc datasets. Is there another way to do this?
FYI, the reason I need to is I am creating hundreds of datasets with a do loop, and I only want the datasets stored if they are meeting a condition, or else too much room would be made up in the end.
If you are already using a macro then you can use conditional logic (%IF %THEN etc).
Or you can just generate the code and then execute it.
For example you might do what you want with PROC SQL ;
data x;
set sashelp.class;
run;
proc sql noprint ;
select case when (mean(age)<14) then 'proc delete data=x;run;'
else ' ' end
into :code
from x
;
quit;
&code;
If you are already using a macro then you can use conditional logic (%IF %THEN etc).
Or you can just generate the code and then execute it.
For example you might do what you want with PROC SQL ;
data x;
set sashelp.class;
run;
proc sql noprint ;
select case when (mean(age)<14) then 'proc delete data=x;run;'
else ' ' end
into :code
from x
;
quit;
&code;
Yea, thanks for the help, i feel dumb not thinking outside the box there.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.