DATA Step, Macro, Functions and more

BASE SAS

Accepted Solution Solved
Reply
Contributor
Posts: 65
Accepted Solution

BASE SAS

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


Accepted Solutions
Solution
‎04-06-2017 04:33 AM
Super User
Posts: 5,511

Re: BASE SAS

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;

View solution in original post


All Replies
Trusted Advisor
Posts: 1,926

Re: BASE SAS

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

Solution
‎04-06-2017 04:33 AM
Super User
Posts: 5,511

Re: BASE SAS

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;

Contributor
Posts: 65

Re: BASE SAS

Posted in reply to Astounding

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

65

 

Super User
Posts: 10,035

Re: BASE SAS

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;

☑ This topic is solved.

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

Discussion stats
  • 4 replies
  • 127 views
  • 0 likes
  • 4 in conversation