Help using Base SAS procedures

SAS DATE

Reply
Regular Learner
Posts: 1

SAS DATE

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!

Super User
Posts: 5,498

Re: SAS DATE

Posted in reply to music_is_m

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.

Ask a Question
Discussion stats
  • 1 reply
  • 206 views
  • 1 like
  • 2 in conversation