Between Dates

Jesusismygrace · Posted 10-15-2021 12:31 PM

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 · Posted 10-15-2021 12:34 PM

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 · Posted 10-15-2021 12:37 PM

Thank you!

mkeintz · Posted 10-15-2021 07:03 PM

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

--------------------------
The hash OUTPUT method will overwrite a SAS data set, but not append. That can be costly. Consider voting for Add a HASH object method which would append a hash object to an existing SAS data set

Would enabling PROC SORT to simultaneously output multiple datasets be useful? Then vote for
Allow PROC SORT to output multiple datasets

--------------------------

mkeintz · Posted 10-15-2021 07:04 PM

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

--------------------------
The hash OUTPUT method will overwrite a SAS data set, but not append. That can be costly. Consider voting for Add a HASH object method which would append a hash object to an existing SAS data set

Would enabling PROC SORT to simultaneously output multiple datasets be useful? Then vote for
Allow PROC SORT to output multiple datasets

--------------------------

Re: Between Dates