DATA Step, Macro, Functions and more

how to replace date value ?

Accepted Solution Solved
Reply
Contributor
Posts: 31
Accepted Solution

how to replace date value ?

hi i have a dataset which contains one variable date/

Variable - date

06/20/2010

06/16/2010

06/22/2010

06/20/2010

i want to replace the value of 06 ( month ) with 04 and 2010 ( year ) with 2011.

how can i achieve this?


Accepted Solutions
Solution
‎08-04-2011 09:10 AM
PROC Star
Posts: 7,363

how to replace date value ?

If you only want to change certain dates, you could do it with something like:

data have;

  informat date mmddyy10.;

  format date mmddyy10.;

  input date;

  cards;

06/20/2010

06/16/2010

06/22/2010

06/20/2010

;

data want;

  set have;

  if month(date) eq 6 then date=

    mdy(4,day(date),year(date));

  if year(date) eq 2010 then date=

    mdy(month(date),day(date),2011);

run;

View solution in original post


All Replies
Contributor
Posts: 28

how to replace date value ?

I suppose your date is a valid sas date. This value is a number into your dataset.

the intnx function is the best way to increase or decrease your date values.

new_month = intnx('month',date,1); /* this adds one month to your date */

new_month2 = intnx('year',new_month,1); /* this adds one year to your date */

if it's text you can use substring and convert your date to a sas date using the mdy(month,day,year) function.

Solution
‎08-04-2011 09:10 AM
PROC Star
Posts: 7,363

how to replace date value ?

If you only want to change certain dates, you could do it with something like:

data have;

  informat date mmddyy10.;

  format date mmddyy10.;

  input date;

  cards;

06/20/2010

06/16/2010

06/22/2010

06/20/2010

;

data want;

  set have;

  if month(date) eq 6 then date=

    mdy(4,day(date),year(date));

  if year(date) eq 2010 then date=

    mdy(month(date),day(date),2011);

run;

Contributor
Posts: 31

how to replace date value ?

Hi Sir,

Thank you so much for your time. This is really useful to me.

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 1166 views
  • 1 like
  • 3 in conversation