BookmarkSubscribeRSS Feed
Verlea
Calcite | Level 5

I have effective and expiration dates in a dataset where I have transposed them so all for the key I have created are in a single row in the dataset.  I want to be able to compare all of the dates to see if there is a break in the dates.  My end result should be if I can combine the dates in the row to make one effective date and one expiration date.  I can't use MIN(Eff_Dt) or MAX(Exp_Dt) because I might miss breaks in the dates.

I have attached a few examples in an excel spreadsheet.

 

1 REPLY 1
RW9
Diamond | Level 26 RW9
Diamond | Level 26

Hi,

 

Welcome to the community.  First, I advise to post anything you need to, test data and code directly into the post, I wouldnt download Office files from the net as security risk.

 

From what you post, I question the need to transpose the data to find missing periods:

data want;
  set have;
  if current_date ne lag(current_date)+1 then flag="Y";
run;

So in this example, the lag lookks back one record and if its not 1 day more than the lag value sets a flag.  No need to transpose to do this.

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!

SAS Enterprise Guide vs. SAS Studio

What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.

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
  • 1 reply
  • 580 views
  • 0 likes
  • 2 in conversation