topic Re: Increementing a Variable with conditions! in SAS Programming

Increementing a Variable with conditions!

allurai0412 — Tue, 26 Feb 2013 08:01:15 GMT

hi to all,

i am working with large databases ....just providing sample obs and variables....

I need 'count' variable increment as in Desired ouput....

data have;
infile datalines;
input month sales;
datalines;
1 2000
2
3 4500
4 12200
5
6
7 45000
8 87800
9 127955
;
run;

**********desired output**********

month sales count
1     2000   1
2               0
3     4500   1
4     12200 2
5               0
6               0
7     45000 1
8     87800 2
9     127955 3

Regards

ALLU

Re: Increementing a Variable with conditions!

andreas_lds — Tue, 26 Feb 2013 08:08:04 GMT

Use RETAIN on the variable count with 0 as initial value, reset it to 0 if sales is missing, if sales is not missing increment it by 1.

data want;

set have;

length count 8;

retain count 0;

count = ifn(missing(sales), 0, count + 1);

run;

Re: Increementing a Variable with conditions!

allurai0412 — Tue, 05 Mar 2013 07:34:12 GMT

Thanks...