09-26-2017 03:05 PM
I am using a do loop to create a counter variable, count. However, the values that needs to be counted is not fully complete. How can I adjust the following code to include missing observations? I want to add a line that makes count=. if time=., and have no rows added if time=., but i couldn't get an if-then statement to work. Instead, the rows where time=. are removed from the dataset.
data dat2; set dat1; if time ge 0 then do count=1 to round(time, 1); output; end; run;
09-26-2017 03:16 PM
You could just make sure your upper bound is at least 1.
data dat2; set dat1; do count=1 to max(1,round(time, 1)); output; end; run;
Need further help from the community? Please ask a new question.