topic Where statement with a date interval difference in New SAS User

Where statement with a date interval difference

Jannie_D — Fri, 18 Dec 2020 12:36:06 GMT

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?

Re: Where statement with a date interval difference

Kurt_Bremser — Fri, 18 Dec 2020 12:42:16 GMT

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

Re: Where statement with a date interval difference

Astounding — Fri, 18 Dec 2020 15:05:52 GMT

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 ;