topic Re: I need a variable in my output populated with 'y' if variable result is last.result but gettng in SAS Programming

I need a variable in my output populated with 'y' if variable result is last.result but gettng erro

Aliya-begum — Mon, 19 Nov 2018 06:07:16 GMT

data VS;
input ptid @5 vsdtc ddmmyy10. @17 result;
format vsdtc ddmmyy10.;
cards;
101 24/10/2018 110
101 25/10/2018 120
101 26/10/2018 115
101 27/10/2018 125
101 28/10/2018 135
102 23/10/2018 130
102 25/10/2018 120
102 26/10/2018 110
102 29/10/2018 115
102 30/10/2018 125
103 24/10/2018 120
103 26/10/2018 140
103 27/10/2018 110
103 28/10/2018 115
103 28/10/2018 145
;
run;

data DM;
input ptid @8 rfstdtc ddmmyy10.;
format rfstdtc ddmmyy10.;
cards;
101 26/10/2018
102 26/10/2018
103 27/10/2018
;
run;

proc sort data=VS;
by ptid;
run;
proc sort data=DM;
by ptid;
run;
data VS1;
merge VS DM;
by ptid;
run;
proc print;
run;

DATA VS2 VS3;
set VS1;
if vsdtc < rfstdtc then output VS2;
if vsdtc > rfstdtc then output VS3;
run;
DATA NEWL;
SET VS2;
IF LAST.result THEN vsblfl = 'Y';
RUN;
PROC PRINT;
RUN

Re: I need a variable in my output populated with 'y' if variable result is last.result but gettng

PeterClemmensen — Mon, 19 Nov 2018 06:21:40 GMT

What is the error?

Re: I need a variable in my output populated with 'y' if variable result is last.result but gettng

Aliya-begum — Mon, 19 Nov 2018 06:24:53 GMT

its showing variable last.result is uninitialized.

Re: I need a variable in my output populated with 'y' if variable result is last.result but gettng

error_prone — Mon, 19 Nov 2018 06:59:25 GMT

If you want to use last(or first you have to use by, too. And I am wondering that you don't get a warning or at least a note saying exactly that.

Re: I need a variable in my output populated with 'y' if variable result is last.result but gettng

Aliya-begum — Mon, 19 Nov 2018 07:16:04 GMT

Re: I need a variable in my output populated with 'y' if variable result is last.result but gettng

RW9 — Mon, 19 Nov 2018 08:43:07 GMT

Please avoid coding in upper case, its shouting code. Missing by line:

data newl; 
  set vs2;
  by result;
  if last.result then vsblfl='Y';
run;

Re: I need a variable in my output populated with 'y' if variable result is last.result but gettng

Aliya-begum — Mon, 19 Nov 2018 13:28:24 GMT

sure ill...and thanks for the reply