In agreement with the validity if previous posts, here is how it is usually done:
if (.Z < variable < 0) then delete;
Good luck.
Ksharp's has already provided a safe approach:
if var<0 and not missing(var) then delete;
This will include all kinds of missing values ranging from '._' to '.Z'.
Regards,
Haikuo
Your problem is that you're mixing up numeric and character data. And SAS' automatic conversions are trying to help.
By saying it deletes when variable = ' ', this means variable is character. So comparing to 0 forces an automatic conversion to numeric. (check the warnings in the log)...
So you need to use the following delete statement
if put(variable,5.) < 0 and put(variable,5.) ne . then delete.
SAS will still complain about invalid numeric data, but your tests will work correctly. Use an appropriate numeric format instead of the 5. if that's not appropriate.
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.