topic Re: Date Change in SAS Procedures

Date Change

ren2010 — Fri, 22 Jan 2010 21:18:41 GMT

Hi,

I have a requirement suppose I have customer data(name,enrolldate)
I want to change the enrolldate to the end of that particular month

eg: james 12/01/2007
roby 11/10/2009
mary 02/26/2009

my desired output is:

james 12/31/2007
roby 11/30/2009
mary 02/28/2009

Please help.

Re: Date Change

sbb — Fri, 22 Jan 2010 22:21:44 GMT

Using a DATA step, explore using the INTNX function in a SAS assignment statement, either to create a new variable (with the desired output FORMAT) or to change the value of an existing variable.

Scott Barry
SBBWorks, Inc.

Recommended Google advanced search argument:

change date end of month site:sas.com

intnx function site:sas.com

Re: Date Change

ren2010 — Fri, 22 Jan 2010 22:44:39 GMT

Thanks Scott

Re: Date Change

deleted_user — Mon, 25 Jan 2010 18:49:25 GMT

data initial;
input name $ customer_date MMDDYY10.;
datalines;
james 12/01/2007
roby 11/10/2009
mary 02/26/2009
;
run;

data end_of_month;
set initial;
c_date=intnx('month', customer_date, 0, 'end');

proc print
data=end_of_month;
format customer_date c_date MMDDYY10.;
run;