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
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;
Thanks...
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.