CODEWITHSUNDEEP
datetimeformatsas
GadonJ
GadonJ

Reputation: 41

SAS datetime format YYYY-mm-dd HH:ii

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.

Upvotes: 4

Views: 16197

Answers (1)

Paxi
Paxi

Reputation: 61

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.

Upvotes: 4

Related Questions