Function reads horizontally

usuario_estudo — Wed, 31 Oct 2018 21:08:42 GMT

Hi,

I need a function in SAS that reads horizontally.

I have to create a variable "Number of completed months" that returns the value of months that are filled until it arrives empty (missing ".").

Example:

Thnak you!

Re: Function reads horizontally

Astounding — Wed, 31 Oct 2018 21:14:36 GMT

SAS can do this easily if the data behaves:

n_complete = n(of month_1 - month_8);

However, if you have the possibility of missing values in the middle:

month_1 = 10

month_2 = .

month_3 = 22

You would need to decide if the correct result is 2 vs. should it be 3. The programming might have to change a little.