BookmarkSubscribeRSS Feed
SharonBH
Calcite | Level 5

I am trying to convert a Character date DDMonYYY format to a SASDATE to compare against a Raw date read in as ccyymmdd and converted to SASDATE. I tried using INPUT function as in Sample 24591 using Date9, but it does not work. I get "Invalid argument to INPUT function at Line ### Column ##'. When I PUT the string data into the SASLOG it shows that it matches. The new data field using the INPUT function dusplays as missing.

3 REPLIES 3
PGStats
Opal | Level 21

Is this the problem : reading a date with a 3-digit year?

PG
SharonBH
Calcite | Level 5

No, that was a typo. The date read in is format is DDMonYYYY.

ballardw
Super User

It would help to show the code actually used. I would say the most likely culprit are some specific values are not valid dates: 30FEB2014 for instance.

Show an entire error message.

Catch up on SAS Innovate 2026

Dive into keynotes, announcements and breakthroughs on demand.

Explore Now →
What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

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
  • 3 replies
  • 1918 views
  • 0 likes
  • 3 in conversation