topic Re: How to convert data formats? in SAS Programming

How to convert data formats?

unwanted_banana — Tue, 06 Jul 2021 21:20:23 GMT

HAVE:

2017-04-20 00:00:00

WANT:

2017-04-20

AND

20/04/2017

(two separate formats for two different purposes)

Re: How to convert data formats?

Reeza — Tue, 06 Jul 2021 21:22:52 GMT

want1 = datepart(have);
format want1 yymmddd10.;
want2=want1;
format want2 ddmmyys10.;
want1_char = put(want1, yymmddd10.);
want2_char = put(want2, ddmmyys10.);

@unwanted_banana wrote:

HAVE:

2017-04-20 00:00:00

WANT:

2017-04-20

AND

20/04/2017

(two separate formats for two different purposes)

Re: How to convert data formats?

unwanted_banana — Tue, 06 Jul 2021 21:39:11 GMT

Ran the code and for some reason datepart returns a null value.

Re: How to convert data formats?

Astounding — Tue, 06 Jul 2021 23:09:23 GMT

This will happen if HAVE is actually a character variable, not a true date/time. In that case:

length want1 want2 $ 10;
want1 = have;
want2 = put(input(want1, yymmdd10.), ddmmyys10.);

Re: How to convert data formats?

Reeza — Tue, 06 Jul 2021 23:46:35 GMT

The log usually tells you more than that.

Re: How to convert data formats?

Kurt_Bremser — Wed, 07 Jul 2021 07:12:29 GMT

First of all, store date, time and datetime values as such; numbers that contain either the count of days or the count of seconds starting at 1960-01-01:00:00:00 or midnight (in case of pure time).

Then, whenever you need it, use the appropriate format to display the values as wanted.

In your case, this would be either YYMMDD10. or DDMMYY10.