topic Re: BASE SAS in SAS Programming

BASE SAS

molla — Tue, 04 Apr 2017 18:40:03 GMT

Hii I have following input

Input dataset :

id max score

101 20 45

101 32 65

101 28 50

output :

id max score change

101 20 45 5

101 28 50 15

101 32 65 .

pls help me out

Re: BASE SAS

PaigeMiller — Tue, 04 Apr 2017 19:18:21 GMT

I don't understand how the column named change is computed. You didn't explain that.

Re: BASE SAS

Astounding — Tue, 04 Apr 2017 20:01:36 GMT

Perhaps:

proc sort data=have;

by id score;

run;

data want;

set have;

by id;

if last.id=0 then do;

_n_ = _n_ + 1;

set have (keep=score rename=(score=next_score)) point=_n_;

change = next_score - score;

end;

drop next_score;

run;

Re: BASE SAS

molla — Wed, 05 Apr 2017 07:39:55 GMT

Is there any way to get the observations of one varaible to other by excluding the first value of that varaible ie

score score2

45 50

50 64

Re: BASE SAS

Ksharp — Wed, 05 Apr 2017 14:14:16 GMT

data have;
input id      max   score;
cards;
   101     20        45  
   101     32        65    
   101     28        50
;
run;
proc sort data=have;by id score;run;
data want;
 merge have have(keep=id score rename=(id=_id score=_score) firstobs=2);
 if id=_id then diff=_score-score;
 drop _:;
run;