08-25-2017 11:16 PM - edited 08-25-2017 11:17 PM
Please provide a sample data of the variables you have with values. This will help to get better responses. Without the data it is very difficult to suggest the code.
08-26-2017 01:27 AM
Is January 2017 greater then December 2016 ?
Are you comparing just the month or the date ?
In what format is your date? Is Character? numeric? sas date?
If it is a character date - is it ddmmyy mmddyy or any othe format ?
The code will change according to your answer.
The best is to post example of your data.
08-26-2017 08:29 AM - edited 08-26-2017 09:58 AM
Suppose you are interested to drop all observations of SASHELP.CLASS where AGE = 14 to get new data as myclass.
where AGE ^= 14;
If you interested to drop those whose SEX = 'M' then do:
where Sex ^= 'M';