topic Re: Between Dates in New SAS User

Between Dates

Jesusismygrace — Fri, 15 Oct 2021 16:31:04 GMT

Hi,

I would like to bring back records where the Day_28 variable is between 1 and 28. I can't get this statement to work where Day_28= >1 and <=28;

** Limit the Days *;
Data output.ImagingStudy1;
Set output.ImagingStudy;
where Day_28= >1 and <=28;
run;

Kurt_Bremser — Fri, 15 Oct 2021 16:34:17 GMT

You can do a "compound comparison" like this:

where 1 le Day_28 le 28;

The mnemonic LE is for "less or equal".

Or you do

where day_28 between 1 and 28;

which is valid in SQL.

Jesusismygrace — Fri, 15 Oct 2021 16:37:40 GMT

Thank you!

mkeintz — Fri, 15 Oct 2021 23:03:58 GMT

If it's the solution to your request, mark it as a solution for other community users to recognize.

mkeintz — Fri, 15 Oct 2021 23:04:09 GMT

If it's the solution to your request, mark it as a solution for other community users to recognize.