Distinct values in sub Group

deega — Tue, 08 Nov 2016 00:46:30 GMT

Hi All,

The solutions of the community have always helped me and saved lot of time too. Here I am again with another problem. It is looking very simple but I am not able to do it by simple program.

My input is as follows

1	A
1	A
1	B
2	A
2	A
2	A
2	B
2	B
3	A
3	B
3	C
3	C
3	C
3	C
4	D
4	D
4	E
5	A
5	B
5	C

and I am looking for output where I get unique values of sub-group as follows

1	A
1	B
2	A
2	B
3	A
3	B
3	C
4	D
4	E
5	A
5	B
5	C

Thanks in advance !

Re: Distinct values in sub Group

ChrisNZ — Tue, 08 Nov 2016 00:58:13 GMT

Like this?

proc sort nodupkey;

by VAR1 VAR2;

Re: Distinct values in sub Group

deega — Tue, 08 Nov 2016 01:10:32 GMT

Wow !
Yes, its working .....

topic Re: Distinct values in sub Group in SAS Programming

Distinct values in sub Group

Re: Distinct values in sub Group

Re: Distinct values in sub Group