topic Re: How to identify obs where date B is up tp 120 days greater than date A in SAS Programming

How to identify obs where date B is up tp 120 days greater than date A

EM_G — Tue, 08 Jun 2021 06:35:01 GMT

Hi All,

I have patient Id's with Date A and Date B. I am trying to assign 'Yes' to the patients where Date B is 11 to 20 days greater than Date A an 'No' to any Id where Date B is 21 or more days greater than Date A.

ID DateA DateB Y/N

1 10May17 25May17 Y

3 8Nov18 10Dec18 N

2 13June17 26June17 Y

Where do I start?

Thanks in advance

Re: How to identify obs where date B is up tp 120 days greater than date A

ballardw — Tue, 08 Jun 2021 07:15:39 GMT

You start with SAS date valued variables. If your variables are 1) numeric and 2) have format like DATE7. assigned your likely good. If the format is $ anything the first step will be to get the SAS dates using INPUT.

SAS dates are number of days since 1Jan1960. So when you are interested in days you can do simple subraction:

date want;
   set have;
   NewVar = (11 le (dateb -datea) le 20);
run;

Will create a numeric variable valued as 1 when the difference is in the range and 0 otherwise. SAS uses 1 as true and 0 as false and is much more flexible than assigning character Y N values. If you must "see" Y or N in a report it takes about 3 minutes or less to write a custom format to display the numeric 1 as 'Y', 'Yes', 'True' or "You bet your bippy" and any other text for the 0.

Your question title says 120 days, so which is it, 20 or 120?

When you specify something like this you really should explicitly state what to assign when other ranges result.

So perhaps another approach:

date want;
   set have;
   if (11 le (dateb -datea) le 20 ) then Newvar=1;
   else if  (dateb -datea) > 20 then NewVar=0;
run;

which leaves Newvar with missing values

Re: How to identify obs where date B is up tp 120 days greater than date A

japelin — Tue, 08 Jun 2021 07:21:31 GMT

how about this code?

data have;
  length id dateA dateB 8 YN $1;
  input id dateA:date9. dateB:date9.;
  format dateA dateB date9.;
datalines;
1 10May17 25May17
3 8Nov18 10Dec18
2 13Jun17 26Jun17
;
run;

data want;
  set have;
  if 11=<dateB-dateA=<20 then YN='Y';
  else if 21=<dateB-dateA then YN='N';
run;

Re: How to identify obs where date B is up tp 120 days greater than date A

Kurt_Bremser — Tue, 08 Jun 2021 07:30:09 GMT

What about B dates smaller than or within 10 days from A?

Anyway, SAS dates are counts of days, so you can do

if 11 le dateb - datea le 20
then y_n = "Yes";
else if dateb - datea gt 20 then y_n = "No";

Re: How to identify obs where date B is up tp 120 days greater than date A

EM_G — Tue, 15 Jun 2021 03:16:24 GMT

Ballardw,
Thankyou this achieved exactly what I was after. I used the second approach, so other ranges I was not aware of were made visible by the missing values. My dates were already sas dates, so this made it simple. Sorry about the 120 day typo in the title.

Thank you for your response, much appreciated.

Re: How to identify obs where date B is up tp 120 days greater than date A

EM_G — Tue, 15 Jun 2021 03:20:26 GMT

KurtBremser,

Thankyou for your response. This also achieves what I was after. There were no B dates smaller than or within 10 days from A, thankfully.

Re: How to identify obs where date B is up tp 120 days greater than date A

EM_G — Tue, 15 Jun 2021 03:21:39 GMT

Kawakami,

Thank you for you response. Much appreciated.