Change a Dates Format

[AAWTomHanks]

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.

[Tushar]

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

[Tushar]

Please try below one...

data want;

  input date anydtdte.;

  format date date9.;

  cards;

28MAY1927:00:00:00

;

run;

[Tushar]

One correction use date10. instead of date9.

[Tushar]

Yesd KarlK you are right.. Thanks...

[KarlK]

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

Karl

[robertrao]

Hi,

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

Thanks

[AAWTomHanks]

Hi Guys,

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

Thanks.

[Tushar]

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.

[Ksharp]

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

[robertrao]

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

[Ksharp]

Plz check documentation firstly .