How to convert number(DateTime format) to character

[anmolk171]

Hi All,

I am stuck in a situation. I have data(Date) type is number and format is DATE9

example-

Employee Hire Date

12MAR1985

12MAR1985 is number in Date9 format.

I want it to convert into String or Character. So that I can use it in my way.

Please help me on this one.

Thanks!

Anmol

[ballardw]

data want; set have; chardate = put(date, date9.); /* or other date format you did not specify*/ run; Though if "use it my way" involves any further processing in SAS you are likely going to cause yourself more work.

[anmolk171]

Hi,

can you provide me the exact code. I am new to SAS. My table name is EmpData, variable is HireDate(Number->DateFormat9).

I want to change HireData into character or string.

Thanks.

[Reeza · Accepted solution]

HireDate_CHAR = put(hiredate, yymmdd8.);

The format in purple is what controls the appearance. You can change the format to get different outputs if desired.