topic Formatting a date question in SAS Procedures

Formatting a date question

zetter — Wed, 01 Oct 2014 19:15:11 GMT

I'm having problems reading the date on my sas table

id date

111 01sept10 000000

the date is september 1 2010

ive tried to read this date and produce results like this:

id date expiry

111 01sept10 000000 yes

by using a code like this

length expiry $ 10

if date < '21Apr2014' d then expiry ='yes'; , the problem is the code does not appear to recognize this date format and give incorrect results. I was thinking that the solution may be to change the format of the date to something like 01/09/2010 as this format has worked for me in the past. How do i change the code or which is the quickest way?

Thanks.

Re: Formatting a date question

Reeza — Wed, 01 Oct 2014 19:23:46 GMT

If you're dealing with an actual SAS dataset post the proc contents on it.

proc contents data=have; run;

My guess is its a date time variable so you'll need to use the date part function for the comparison:

if datepart(date) < '21Apr2014' d then expiry ='yes';

Re: Formatting a date question

zetter — Thu, 02 Oct 2014 17:55:45 GMT

Thanks this works

Re: Formatting a date question

zetter — Thu, 02 Oct 2014 19:34:19 GMT

thanks that works