how can i create loop in SAS using iterative method and print the results

Question

i would like to make an iterative loop in SAS to calculate the average for each id my data as follow :

data sample

Answer 1

In SAS data steps you use do loops for iterative processing https://blogs.sas.com/content/iml/2011/09/07/loops-in-sas.html.

However, to get an average value per idea, SQL is usually much simpler.

proc sql;
  select id, mean(value)
  from data
  group by id
  ;
quit;