Creating a Data Model based on prior month

[new_sas_user_4]

@andreas_lds thank you 🙂

There is something I have come across and I thought you might help !!

The dataset 'have' sometimes has missing values.

eg there no row that comes up for Day 30(which in my sample dataset is 30 0.01 30May2020 )

and because of the missing percent value, I get a random number in the results for 30June2020 Orders1

I believe it is because of the informat value for Day2Percent30 is missing. 

Is there a way to rectify this?

I tried using coalesce function 

_p = coalesce(input(cats(_z),Day2Percent.),0);            but it didnt help.

_p = input(cats(_z), Day2Percent.);
			_o = input(cats(_i), Day2Orders.);
			allOrders[_i] = int(_o * _p);