topic Filling in values in a data set in SAS Programming

Filling in values in a data set

nickcampanale — Mon, 12 Sep 2022 23:16:27 GMT

I have three tables, a Master calendar table, Accrued points table, and Redeemed Points table.

Users can redeem points and not accrue and vice versa.

I need to create records to fill in a data set for months where no points accrued.

EX:

Month ID

SEP -

OCT -

NOV A

Desired OutCome

Month ID

SEP A

OCT A

NOV A

ballardw — Mon, 12 Sep 2022 23:24:04 GMT

You mention three input tables and show one, and don't even provide a data set name to boot.

Probably should show examples of all three.

You imply that what ever that ID might be that it could have values before a user is actually active. Is that in fact what you want?

What determines the actual value to "fill in"? Closest other value? Before? After?

I suspect you are leaving out details that are obvious to you but not mentioned while we can only use what you show us.

A trivial and almost certainly incorrect approach would be like this:

data want;
   set datawithmissing;
   id = 'A';
run;

Probably incorrect because it sets everything to 'A'. But you haven't provided any example why a value other than 'A' would appear.

andreas_lds — Tue, 13 Sep 2022 05:57:36 GMT

Is there always only obs without missing ID? If not: please describe the rule to choose the right value.