topic Re: Count a value _ Conditional loop in SAS Programming

Count a value _ Conditional loop

RohitSehgal — Fri, 23 Nov 2018 21:49:47 GMT

Hi,

I need to populate a count_var variable in my dataset based on the value of Order Id, Dataset format is as follows:

Order ID Count_var

000123 1

000123 2

000123 3

000125 1

000125 2

000130 1

Here Count_var variable is something that I want to auto-populate in SAS, which should start the counting from 1 when the value of Order ID changes. Please help me with the code.

Regards,

Rohit

Re: Count a value _ Conditional loop

novinosrin — Fri, 23 Nov 2018 21:54:04 GMT

data want;

set have;

by order_id;

if first.order_id then count_var=1;

else count_var+1;

run;

Re: Count a value _ Conditional loop

r_behata — Fri, 23 Nov 2018 21:55:11 GMT

Data have;
input Order_ID;
datalines;
000123
000123
000123
000125
000125
000130
;
run;

proc sort;
	by Order_ID;
run;

data want;
	set have;
	by Order_ID;

	if first.Order_ID then Count_var=1;
		else Count_var+1;
run;