DATA Step, Macro, Functions and more

Increementing a Variable with conditions!

Reply
Frequent Contributor
Posts: 97

Increementing a Variable with conditions!

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

Super Contributor
Posts: 345

Re: Increementing a Variable with conditions!

Posted in reply to allurai0412

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;

Frequent Contributor
Posts: 97

Re: Increementing a Variable with conditions!

Posted in reply to andreas_lds

Thanks...

Ask a Question
Discussion stats
  • 2 replies
  • 205 views
  • 4 likes
  • 2 in conversation