Eliminate Nulls

[fred_major]

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

[ballardw]

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?

[fred_major]

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

[Astounding · Accepted solution]

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.

[fred_major]

Thanks you very much.

Fred