topic Re: Convert Numeric Date to Character in SAS Programming

Convert Numeric Date to Character

Dhana18 — Tue, 31 Jul 2018 16:46:20 GMT

Hi,

I have a date variable that is numeric ((02JAN2018) ) with date9. format and date 9 informat length 8.

I would like it to be character date yymmdd10.

Your help will be appreciated

Re: Convert Numeric Date to Character

PaigeMiller — Mon, 20 Jun 2022 15:42:13 GMT

There is no such thing as a character date in SAS. You can convert the date to a plain old character string, which is only useful in labels and titles and reports. If you care going to do additional computations or work with the date, you need to leave it as numeric.

Here is the conversion to character:

char_date = put(date,yymmdd10.);

Perhaps you meant that you want to leave the variable as numeric but with a different format? That would be much more useful and reasonable than creating a character string. In that case, just change the format.

Editor's note:
As PaigeMiller noted, converting the date to a character string is different than reformatting the date with a format that uses characters. If reformatting is the goal, Astounding provides example code that can be used in a Proc step or a DATA step.

format datevar yymmdd10.;

Re: Convert Numeric Date to Character

PeterClemmensen — Tue, 31 Jul 2018 17:03:52 GMT

data test;   
   Date='02JAN2018'd;
   CharDate=put(Date, yymmdd10.);
   format Date date9.;
run;

However, not a good idea to have dates stored as character...

Re: Convert Numeric Date to Character

Astounding — Tue, 31 Jul 2018 17:32:09 GMT

If you are not happy with the DATE9 format, just use a different format:

format datevar yymmdd10.;

You can add that statement in a PROC step, in which case the format is used just for the duration of the procedure.

Or you can add it in a DATA step, in which case the format becomes the default format going forward from that point.

Re: Convert Numeric Date to Character

Dhana18 — Tue, 31 Jul 2018 18:15:23 GMT

Thank you for your response, i would like to create a new character variable with yymmdd10. format.

Re: Convert Numeric Date to Character

Dhana18 — Tue, 31 Jul 2018 18:25:07 GMT

Thank you! I just changed the format and it worked!