topic Re: How to find and correct a date in a dataset in New SAS User

How to find and correct a date in a dataset

sasgorilla — Fri, 25 Oct 2024 10:37:55 GMT

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.

Re: How to find and correct a date in a dataset

PaigeMiller — Fri, 25 Oct 2024 10:59:17 GMT

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.

Re: How to find and correct a date in a dataset

sasgorilla — Fri, 25 Oct 2024 13:18:06 GMT

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