I'm a SQL and R user who is just starting to use Stata. I'm trying to find an equivalent Stata program/code of doing the following in SQL:

SQL code:

MAX(VAR_A) OVER(PARTITION BY ID) AS MAX_VAR_A

I have tried foreach (perhaps wrong for the task) command but no luck.