topic Re: Eliminate Nulls in SAS Procedures

Eliminate Nulls

fred_major — Wed, 04 Dec 2013 17:21:08 GMT

Currently my dataset looks like this.

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 — Wed, 04 Dec 2013 17:38:34 GMT

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 — Wed, 04 Dec 2013 17:44:40 GMT

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 — Wed, 04 Dec 2013 18:07:31 GMT

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 — Wed, 04 Dec 2013 18:14:05 GMT

Thanks you very much.

Fred