BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
fred_major
Calcite | Level 5

Currently my dataset looks like this.

    dateCallInboundOutboundSchedule
Fri, Nov 1, 2013 Good
Fri, Nov 1, 2013Good
Fri, Nov 1, 2013 Low
Fri, Nov 1, 2013 High

I would like it to look like the below

    dateCallInboundOutboundSchedule
Fri, Nov 1, 2013 GoodGood High Low

Thanks

Fred

1 ACCEPTED SOLUTION

Accepted Solutions
Astounding
PROC Star

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.

View solution in original post

4 REPLIES 4
ballardw
Super User

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
Calcite | Level 5

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
PROC Star

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
Calcite | Level 5

Thanks you very much.

Fred

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

What is Bayesian Analysis?

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 4 replies
  • 772 views
  • 0 likes
  • 3 in conversation