BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
JS
Obsidian | Level 7 JS
Obsidian | Level 7

I'm trying to convert a datetime20. to a yymmd7. but I'm running into a peculiar error. The data steps run fine, the values get converted... but the error remains.

 

Any thoughts?

 

Thank you!

 

Code

data have;
input time datetime20.;
format time datetime20.;
informat time datetime20.;
cards;
12SEP2013:10:19:43
;
run;

data want;
set have;
format time datetime20. want_date yymmd7.;
want_date = input(datepart(time),yymmd7.);
run;

 

Error -- Informat could not be found 

485
NOTE 485-185: Informat YYMMD was not found or could not be loaded.

28 run;

NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column).
27:19

 

Results -- Outputs and runs successfully despite error

time want_date
12Sep2013 10:19:43 2013-09

 

 

1 ACCEPTED SOLUTION
2 REPLIES 2
JS
Obsidian | Level 7 JS
Obsidian | Level 7

I see. I was trying to re-input the date unnecssarily. This works beautifully. Thank you!

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
  • 2 replies
  • 1675 views
  • 1 like
  • 2 in conversation