rename variable and amend date format in same variable

[zdassu]

Hi I have a column called SystemDate with a date format yymmdd8 and the date is being displayed  06-08-10 I would like to rename the column to Todaysdate and have the date format DDMMYY10 10/08/2006. How would I go about changing the format of the date?

[RW9]

data want;
  set have (rename=(systemdate=todaysdate));
  format todaysdate ddmmyy10.;
run;

[Oligolas]

Hi,

DATA have;
   systemDate="10AUG2006"d;
   format systemdate yymmdd8.;
RUN;

DATA want;
   SET have(rename=(SystemDate=Todaysdate));
   format Todaysdate DDMMYY10.;
RUN;

[Kurt_Bremser · Accepted solution]

data want;
set have (rename=(systemdate=todaysdate));
format todaysdate ddmmyy10.;
run;

If your dataset is large and you do not need to preserve its original status, consider using proc datasets.