BookmarkSubscribeRSS Feed
music_is_m
Calcite | Level 5

Hi!

 

I have a character variable with dates that look like this: 04221999

 

I want the varaiable to stay a character variable and to look like this: 04/22/1999

 

How do I go about making this conversion?

 

Thanks!

1 REPLY 1
Astounding
PROC Star

While I think you would be better off creating a numeric variable instead of changing the character variable, that's a different story.  Keeping my opinion out of it, here is a possibility:

 

data want;

length datevar $ 10;

set have;

datevar = put (input(datevar, mmddyy8.), mmddyys10.);

run;

 

The "s" in the middle of the new format name indicates that slashes should be used as separators.

sas-innovate-white.png

Missed SAS Innovate in Orlando?

Catch the best of SAS Innovate 2025 — anytime, anywhere. Stream powerful keynotes, real-world demos, and game-changing insights from the world’s leading data and AI minds.

 

Register 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
  • 1 reply
  • 931 views
  • 1 like
  • 2 in conversation