SAS datetime format YYYY-mm-dd HH:ii

Question

I am trying to display a datetime in the format yyyy-mm-dd hh:mm (e.g. 2012-12-31 23:59)

In PHP I would normally use the format YYYY-mm-dd HH:ii to get what I want. I have been looking through the SAS knowledge base and the closest I can get is E8601DTw.d which provides 2008-09-15T15:53:00 which includes seconds as well as a "T" where I'd like a space.

Is there a format to do what I'd like? If not, is there a way to create my own? I don't know that much SAS myself I'm just trying to modify an existing system. Any help is appreciated.

Solution

If the standard datetime formats provided do not meet your requirements you can create a new format:

PROC FORMAT;
  picture MyMSdt other='%0Y-%0m-%0d %0H:%0M' (datatype=datetime);
RUN;

DATA TEST;
  mydatetime='25nov2009 14:44:56'dt;
  format newdt MyMSdt.;
  newdt=mydatetime;
  put mydatetime= newdt=;
RUN;

Taken from this example that you can easily customize.