topic Re: Adding a min value per observation in SAS Procedures

Adding a min value per observation

PiotrLewczuk — Thu, 02 Apr 2020 09:49:47 GMT

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

Re: Adding a min value per observation

PeterClemmensen — Thu, 02 Apr 2020 09:52:40 GMT

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;

Re: Adding a min value per observation

PiotrLewczuk — Thu, 02 Apr 2020 10:03:20 GMT

Thank you so much! You really helped me.

Take care,

Piotr