assigning numbers to each group

monday89 — Wed, 16 Dec 2020 17:22:37 GMT

I have a dataset that looks like this:

ID	group
1	AB
1	AB
2	CD
2	CD
3	CD
3	CD
4	EF

What i would like to do see assign 1 for unique ID with group . if it is repeated more than once, then 0

something else this

ID	group	count
1	AB	1
1	AB	0
2	CD	1
2	CD	0
3	CD	1
3	CD	0
4	EF	1

i was thinking to do proc sql like proc sql; select distinct id, group, 1 as count; quit;

but was wondering if there is a simple dataset command where i dont have to create another dataset

thanks!

Re: assigning numbers to each group

Tom — Wed, 16 Dec 2020 17:26:26 GMT

COUNT is probably not a good name for a variable with values like that. If looks like the same values as the FIRST. variable that is created for BY group processing. Looks like both ID and GROUP have the same meaning, just that one is a number and the other is a string.

data want ;
  set have;
  by id;
  count=first.id;
run;

topic Re: assigning numbers to each group in SAS Programming

assigning numbers to each group

Re: assigning numbers to each group