Everything ran fine, it's just that the notedate_n column brought back 5 digit numbers as explained in previous post. Also, the log had no errors:
23 data have3;
24 merge have1 (keep=fname dischdate in=in1)
25 have2(keep=fname notedate in=in2);
26 by fname;
27 if in1 and in2;
28 notedate_n=input(notedate,yymmdd10.);
29 if -3 <= intck('day', dischdate, notedate_n) <= 3;
30 run;
NOTE: MERGE statement has more than one data set with repeats of BY values.
NOTE: Missing values were generated as a result of performing an operation on missing values.
Each place is given by: (Number of times) at (Line):(Column).
115 at 29:10
I am trying to create a column for difdays that brings in anybody who has between -3 and 3 days difference between the dischdate and the notedate_n. this is all. I didnt think it would be this complicated. I will try something else, thank you
... View more
