SAS DATE

music_is_m — Mon, 03 Oct 2016 18:31:04 GMT

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!

Re: SAS DATE

Astounding — Mon, 03 Oct 2016 19:07:11 GMT

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.

topic SAS DATE in SAS Procedures

SAS DATE

Re: SAS DATE