first visit of id_no

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 9
Accepted Solution

first visit of id_no

data have;

  input id_no visit measurement;

  cards;

11 1 110

11 1 120

11 1 115

11 2 90

11 2 89

22 1 80

22 1 95

22 2 90

22 2 90

22 2 95

26 1 65

33 1 95

33 1 95

;

run;

for each visit, we take multiple measurement of the patient. we need to find the average of these measurements for each visit.

I run into problem trying to get the first or last visit for the same idno. so the expected output is:

11 1 115

11 2 89.5

22 1 88.3

etc...


Accepted Solutions
Solution
‎10-19-2012 01:25 PM
Respected Advisor
Posts: 3,156

Re: first visit of id_no

Posted in reply to Davidliu494

There will be many many ways to do it. The least mind-twisting method (may not be the fastest) is SQL:

proc sql;

   select id_no, visit, avg(measurement) as avg_m from have group by id_no, visit;quit;

Haikuo

View solution in original post


All Replies
Solution
‎10-19-2012 01:25 PM
Respected Advisor
Posts: 3,156

Re: first visit of id_no

Posted in reply to Davidliu494

There will be many many ways to do it. The least mind-twisting method (may not be the fastest) is SQL:

proc sql;

   select id_no, visit, avg(measurement) as avg_m from have group by id_no, visit;quit;

Haikuo

🔒 This topic is solved and locked.

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

Discussion stats
  • 1 reply
  • 172 views
  • 0 likes
  • 2 in conversation