How to pick the first observation only

hjjijkkl — Tue, 02 Feb 2021 00:14:59 GMT

I have a table below and I want to create a table where the first 'ID' is 'test'' =1. If the first 'ID' isn't 'test' =1 then to have it in a separate column.

ID	date	test
1	6/7/18	1
1	8/12/28	1
2	5/4/18	3
3	6/20/18	1
3	10/4/18	2
4	5/8/18	3
4	7/23/18	3
5	3/9/18	1
5	7/4/18	1
5	11/20/18	1

I want the output to look like this

ID	date	test	Test1	Test2
1	6/7/18	1	1
1	8/12/28	1		1
2	5/4/18	2		2
3	6/20/18	1	1
3	10/4/18	2		2
4	5/8/18	3		3
4	7/23/18	3		3
5	3/9/18	1	1
5	7/4/18	1		1
5	11/20/18	1		1

Re: How to pick the first observation only

Shmuel — Tue, 02 Feb 2021 01:45:52 GMT

You missed to sign the first of ID=4.

Assuming data is sorted by ID then:

data want;
 set have;
  by ID;
      if first.id then test=1; else test=.;
run;
options missing=' ';

topic How to pick the first observation only in New SAS User

How to pick the first observation only

Re: How to pick the first observation only