Date Format

[robertrao]

I have a numeric date variable with the format 11. in the dataset 20010813

How can I convert it to 13AUG2001?

Thanks

[Reeza · Accepted solution]

data have;

input current_date;

cards;

20010813

;

data want;

set have;

current_date=input(put(current_date, 8.), yymmdd8.);

format current_date date9.;

run;

This will display the date in a date9. format, but it still stored as a number underneath.

[DBailey]

If you have clean data (and most of us don't)...then you can use an input format to tell sas that you are reading in what you want to be considered a date variable.

data have;

informat current_date yymmdd8.;

format current_date date9.;

input current_date;

cards;

20010813

;