Here is a simple trick to avoid this problem. Usually when importing data from Excel or csv,  SAS decide whether variable type should be numeric or character  while reading the first few rows of the dataset.  As a trick, you can insert a new row into your input Excel file after the label row and assign value 9999 for all numeric columns   and 'aaaa' for all character columns and then import into SAS. After you import delete this additional row from the dataset. Good luck for your dataset!      ... View more

Your date variable in data is in DATE9. informat. Use dhms function to make both sides of dates into same format. Then your where statement need to be changed as like this and then it should work.   Where dhms(Date,0,0,0) >= dhms('01JUL2015'd,0,0,0);   ... View more