topic Re: rename variable and amend date format in same variable in SAS Programming

rename variable and amend date format in same variable

zdassu — Wed, 21 Jun 2017 12:12:52 GMT

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?

Re: rename variable and amend date format in same variable

RW9 — Wed, 21 Jun 2017 12:19:58 GMT

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

Re: rename variable and amend date format in same variable

Oligolas — Wed, 21 Jun 2017 12:23:32 GMT

Hi,

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

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

Re: rename variable and amend date format in same variable

Kurt_Bremser — Wed, 21 Jun 2017 12:23:58 GMT

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.