Currently my dataset looks like this.
date | Call | Inbound | Outbound | Schedule |
Fri, Nov 1, 2013 | Good | |||
Fri, Nov 1, 2013 | Good | |||
Fri, Nov 1, 2013 | Low | |||
Fri, Nov 1, 2013 | High | |||
I would like it to look like the below
date | Call | Inbound | Outbound | Schedule |
Fri, Nov 1, 2013 | Good | Good | High | Low |
Thanks
Fred
Given that the data is already sorted, you should be able to get away with this:
data want;
update have (obs=0) have;
by date;
run;
Good luck.
Will you ever have more or less than 4 values for your date? Is the data sorted by date? Is your date an actual SAS date value or a string?
Yes it will be around 60 and it could grow, i only put the first 4 columns for this example.
Date is Type = Number length 8 format weekdate17.
Date is sorted.
Thanks
Fred
Given that the data is already sorted, you should be able to get away with this:
data want;
update have (obs=0) have;
by date;
run;
Good luck.
Thanks you very much.
Fred
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: