topic Re: change value in last raw in SAS Programming

change value in last raw

Ronein — Sun, 21 Jun 2020 06:01:29 GMT

Hello

I want to create a new data set based on current data set ttt.

I want to create a condition that IF value of UntilYYMM is 31DEC2020 then the value will be one month after FromYYMM value.

However in wanted data set the value in last row was not changed as I wanted and it is still 31DEC2020

data ttt;
format  FromYYMM date9. UntilYYMM  date9.;
input month FromYYMM :date9. UntilYYMM :date9. ;
cards;
2003 15Feb2020 13MAR2020
2004 14MAR2020 11APR2020
2005 12APR2020 09MAY2020
2006 10MAY2020 31DEC2020
;
run;
data wanted(drop=UntilYYMM rename=(UntilYYMM_new=UntilYYMM));
retain month FromYYMM UntilYYMM;
set ttt;
if last.month then UntilYYMM_new=intnx('month',FromYYMM,1);
else UntilYYMM_new=UntilYYMM;
format UntilYYMM_new date9.;
run;

Re: change value in last raw

Jagadishkatam — Sun, 21 Jun 2020 07:21:49 GMT

Please try the below code

data wanted(drop=UntilYYMM rename=(UntilYYMM_new=UntilYYMM));
retain month FromYYMM UntilYYMM;
set ttt;
UntilYYMM_new=ifn(UntilYYMM='31DEC2020'd,intnx('month',FromYYMM,1),UntilYYMM);
format UntilYYMM_new date9.;
run;

Re: change value in last raw

Kurt_Bremser — Sun, 21 Jun 2020 07:34:13 GMT

Maxim 2: Read the Log.

It will alert you about your incorrect use of last.month without a

by month;

statement.

@Ronein wrote:

Hello

I want to create a new data set based on current data set ttt.

I want to create a condition that IF value of UntilYYMM is 31DEC2020 then the value will be one month after FromYYMM value.

However in wanted data set the value in last row was not changed as I wanted and it is still 31DEC2020
data ttt;
format  FromYYMM date9. UntilYYMM  date9.;
input month FromYYMM :date9. UntilYYMM :date9. ;
cards;
2003 15Feb2020 13MAR2020
2004 14MAR2020 11APR2020
2005 12APR2020 09MAY2020
2006 10MAY2020 31DEC2020
;
run;
data wanted(drop=UntilYYMM rename=(UntilYYMM_new=UntilYYMM));
retain month FromYYMM UntilYYMM;
set ttt;
if last.month then UntilYYMM_new=intnx('month',FromYYMM,1);
else UntilYYMM_new=UntilYYMM;
format UntilYYMM_new date9.;
run;