How to find and correct a date in a dataset

[sasgorilla]

I have an imported dataset from excel where all dates assumed the mmddyy10. format. I noticed in a proc freq there is an observation with a date that is an obvious error I would like to fix (as it predates the observation window). 

Is there a way to find the observation with the date value I am looking for? A proc print that would work for normal numeric values does not work in this case. 

proc print data=a;
where date=09/01/1920;
run;

I ultimately need to change the year of this date, but that hasn't worked either. 

data b;
set a;
if date=09/01/1920 then date2=09/01/2020;
else date2=date;
run;

Thanks in advance. 

[PaigeMiller · Accepted solution]

where date=09/01/1920;

SAS thinks this means: find a date whose value is equal to 9 divided by 1 divided by 1920. I'm guessing this is not what you want.

To indicate you have date values which you would like SAS to use, you need to use this representation exactly (except either upper or lower case is allowed). Following the string with the letter d indicates to SAS this is a date.

where date = '01SEP1920'd;

So when you create data b; you need to make similar changes. I leave that part up to you as a homework assignment.

[sasgorilla]

Thank you. That did the trick and I was able to make the change.