Hello -
I need to delete observations from my dataset when the entry for a given variable contains a certain character (@). I want to keep all the other observations. This seems to require something between an if-then statement and a where contains statement. I can't seem to find any references to this situation. Can anyone suggest the best way to do this?
Thank you.
Try something like this
if findc(text,'(@)') then delete;
Or sql like
PROC SQL ;
DELETE FROM your.dataset
WHERE that_variable CONTAINS '@' ;
;
QUIT;
The contains keyword can be replaced with the symbol ? to make the syntax shorter (not neccessarily clearer)
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.