topic Re: How to convert SAS Date to a String? in SAS Health and Life Sciences

How to convert SAS Date to a String?

Lani — Wed, 28 Oct 2009 03:02:20 GMT

I have a column named "EffectiveDate". I want to check for a record that has an EffectiveDate of "01-01-2010", then this record need to be removed. I don't know how to compare since the EffectiveDate is formated in Date type and the values look numerics. Can I use put function to convert the EffectiveDate to string? then I compare it with "01-01-2010". Your inputs are much appreciated.

Re: How to convert SAS Date to a String?

sbb — Wed, 28 Oct 2009 03:52:12 GMT

Suggestion: you need not post in more than one SAS discussion forum.

Scott Barry
SBBWorks, Inc.

Re: How to convert SAS Date to a String?

SSN_Ravi — Thu, 10 Dec 2009 06:51:53 GMT

Hi Lani,

Yes, you can convert "Effective Date" variable into charracter variable. Then you can compare.

Re: How to convert SAS Date to a String?

Cynthia_sas — Thu, 10 Dec 2009 20:45:08 GMT

Hi:
In addition to converting the variable, you can also use Date constants to perform your selection or your deletion in a DATA step program (or PROC SQL step):
[pre]
if EffectiveDate = '01JAN2010'd then delete;
[/pre]

The date constant form 'DDMMMYYYY'D or 'DDMMMYY'D allows you to supply a date in "readable" format and the D at the end of the constant tells SAS to convert that value to an internal date value, so it would be as though you were specifying this:
[pre]
if EffectiveDate = 18263 then delete;
[/pre]

because '01jan2010'D is the date constant way to specify 18263 -- which represents January 1, 2010, which will be 18,263 days from Jan 1, 1960.

If EffectiveDate was a DATE/TIME variable, then you might have to use a different function to specify your comparison...something like:

[pre]
if datepart(EffectiveDate) = '01jan2010'd then delete;
[/pre]

cynthia