BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Tom
Super User Tom
Super User

Anyone know why the DATETIME18. format uses only two digits for the year?

Unless my math skills have slipped 9 + 1 + 8 = 18 should be enough for DATE9. plus TIME8. with space for a colon between them.

Looks like it has done this for a long time as here is an article from 1999 about a problem it caused. 

557 - SAS/GIS sample map data sets use DATETIME18. format for DATE variable

1 ACCEPTED SOLUTION

Accepted Solutions
PGStats
Opal | Level 21

PERCENTN. has the same kind of quirk, it requires two extra spaces for parentheses that it is designed not to write. I guess that is the plight of long term compatibility, once a less than ideal feature is installed, you are more or less stuck with it.

PG

PG

View solution in original post

1 REPLY 1
PGStats
Opal | Level 21

PERCENTN. has the same kind of quirk, it requires two extra spaces for parentheses that it is designed not to write. I guess that is the plight of long term compatibility, once a less than ideal feature is installed, you are more or less stuck with it.

PG

PG

sas-innovate-2026-white.png



April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!

Register now

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 2126 views
  • 0 likes
  • 2 in conversation