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.
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 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.