Increementing a Variable with conditions!

[allurai0412]

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

[andreas_lds]

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;

[allurai0412]

Thanks...