Adding a min value per observation

[PiotrLewczuk]

Good morning,

Probably I am missing something very simple, but I am just a beginner in SAS...

I am trying to find a solution, how to add a variable with min (x_min) of a given variable (x) per observation (id).

My dataset looks like:

id x     y

1 10   1

1 20   2

1 30   3

2 100 10

2 200  20

...

and what I need is:

id x     min_x   y

1 10    10        1

1 20    10        2

1 30    10        3

2 100  100     10

2 200   100     20

...

Would you be so kind to help me?

Thank you in advance!

Piotr Lewczuk

[PeterClemmensen · Accepted solution]

data have;
input id x y;
datalines;
1 10   1
1 20   2
1 30   3
2 100 10
2 200  20
;

proc sql;
   create table want as
   select id,
          x,
          min(x) as min_x,
          y
   from have
   group by id;
quit;

[PiotrLewczuk]

Thank you so much! You really helped me.

Take care,

Piotr