topic Re: How to convert number(DateTime format) to character in All Things Community

How to convert number(DateTime format) to character

anmolk171 — Mon, 20 Aug 2018 19:34:02 GMT

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

Re: How to convert number(DateTime format) to character

ballardw — Mon, 20 Aug 2018 19:43:38 GMT

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.

Re: How to convert number(DateTime format) to character

anmolk171 — Mon, 20 Aug 2018 19:53:21 GMT

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.

Re: How to convert number(DateTime format) to character

Reeza — Mon, 20 Aug 2018 22:09:25 GMT

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.