topic Re: Change a Dates Format in SAS Procedures

Change a Dates Format

AAWTomHanks — Tue, 14 May 2013 13:00:53 GMT

Hi,

I am having trouble switching dates that look like this '28MAY1927:00:00:00' to '05/28/1927'. Does anyone know how to do this?

Thanks.

Re: Change a Dates Format

Tushar — Tue, 14 May 2013 13:06:03 GMT

use anydtdte. format for reading date and once you read apply date9. format.

Re: Change a Dates Format

Tushar — Tue, 14 May 2013 13:09:08 GMT

Please try below one...

data want;

input date anydtdte.;

format date date9.;

cards;

28MAY1927:00:00:00

;

run;

Re: Change a Dates Format

KarlK — Tue, 14 May 2013 13:12:19 GMT

Tushar, I think you meant mmddyy10. format, no? The OP wants "05/28/1927", not "28MAY1927".

Karl

Re: Change a Dates Format

Tushar — Tue, 14 May 2013 13:13:36 GMT

One correction use date10. instead of date9.

Re: Change a Dates Format

Tushar — Tue, 14 May 2013 13:14:24 GMT

Yesd KarlK you are right.. Thanks...

Re: Change a Dates Format

AAWTomHanks — Tue, 14 May 2013 13:35:40 GMT

Hi Guys,

Thanks for the help. One more question, what if it is a column I am using in a sas data table?

Thanks.

Re: Change a Dates Format

robertrao — Tue, 14 May 2013 13:50:49 GMT

Hi,

Cant we use datepart(date_time) and then use format on that?

Thanks

Re: Change a Dates Format

Tushar — Tue, 14 May 2013 13:52:16 GMT

Suppose if its the sas dataset where on one variable you wanted to apply this format then you can use Proc dataset procedure with modify statement.

Re: Change a Dates Format

Ksharp — Tue, 14 May 2013 14:43:24 GMT

Make a format.

proc format;
picture x
 low-high='%0m/%0d/%Y'(datatype=datetime)     ;
run;
data want;
  input date datetime20.;
  x=date;
  format date datetime20. x x10.;
  cards;
28MAY1927:00:00:00
;
run;

Ksharp

Re: Change a Dates Format

robertrao — Tue, 14 May 2013 21:58:21 GMT

Hi Ksharp,

I have read the picture format after you have posted the solution and did not clearly understand it..

x x10.; means u are applying a format named x10. on the variable x

what is the meaning of '%0m/%0d/%Y' ?????

why did you put x x10. ???? just x x. would not be enough???

Thanks

Re: Change a Dates Format

Ksharp — Wed, 15 May 2013 02:18:40 GMT

Plz check documentation firstly .