topic Creating a counting var where variable value equals 1 in ODS and Base Reporting

Creating a counting var where variable value equals 1

jenim514 — Thu, 16 Jan 2020 00:07:23 GMT

Is there a was to create a count/sequence var to +1 when encountering a '1'? For example, if I had data that looks like this, I do not want to change any sort order, I just want to increase count +1 every time it encounters a 1; Help is appreciated!

Have	Want ORD 2
1	1
2	1
3	1
4	1
5	1
1	2
27	2
28	2
29	2
30	2
1	3
37	3
38	3
39	3
40	3
1	4
57	4
58	4
59	4
60	4

Re: Creating a counting var where variable value equals 1

ed_sas_member — Thu, 16 Jan 2020 00:12:43 GMT

Hi @jenim514

Here is a way to do that.

Best,

data have;
	input num;
	datalines;
1
2
3
4
5
1
27
28
29
30
1
37
38
39
40
1
57
58
59
60
;
run;

data want;
	set have;
	by num notsorted;
	retain count;
	if num=1 and first.num then count+1;
run;

Re: Creating a counting var where variable value equals 1

novinosrin — Thu, 16 Jan 2020 00:52:27 GMT

Hi @jenim514 Methinks all you need is

if num=1 then want+1;

data have;
	input num;
	datalines;
1
2
3
4
5
1
27
28
29
30
1
37
38
39
40
1
57
58
59
60
;

data want;
	set have;
	if num=1 then want+1;
run;