Where statement with a date interval difference

[Jannie_D]

Yet another beginners question from me:

Im working on creating a subpopulation (pop2). The dataset is DTSDCCG, and then I need all with a value in the variable Koloskopi_dt and that has a Dato_diagnosis ( a date) that is 6 month or more after the LabSvar_foerste_pos_dato (also a date). I have no idea how to finish the code.

Data pop2;

Set DTSDCCG;

Where not missing(Koloskopi_dt) and Dato_diagnose>.................LabSvar_foerste_pos_dato ;

run;

What should I put where the dots are?

[Kurt_Bremser]

Use the INTNX function to calculate date or time intervals. You probably want to use "c" (continuous) as fourth parameter.

[Astounding]

It would be simpler (and perhaps even a bit more accurate) to change the definition of "6 months" to mean "more than 182 days".  You could use:

Where not missing(Koloskopi_dt) and Dato_diagnose > 182 + LabSvar_foerste_pos_dato ;