Hi SAS Community, I want to create a set of features based on a date index- that is, a set of features based on a date on one line per ID key. This is the data: What I want it to look like: This is the code I came up with: data x;
set x;
if date_field = '30SEP2018:00:00:00.000'dt then SEP2018_BAL= amount;
else if date_field = '31OCT2018:00:00:00.000'dt then OCT2018_BAL= amount;
else if date_field = '30NOV2018:00:00:00.000'dt then NOV2018_BAL= amount;
else if date_field = '31DEC2018:00:00:00.000'dt then DEC2018_BAL= amount;
else if date_field = '31JAN2019:00:00:00.000'dt then JAN2019_BAL= amount;
else if date_field = '28FEB2019:00:00:00.000'dt then FEB2019_BAL= amount;
run; And this is the output I am getting, which is not ideal: Let me know if you need any more info from me. Thank you!
... View more