duration dates

[Smitha9]

Hi,

I need a dataset from 

07/29/2022 to 08/31/2022 in SAS.

thanks in advance.

[PaigeMiller]

Can you provide more details?

[Smitha9]

dataset
ID Date
1 01/22/2021
2 02/23/2022
3 07/29/2022
4 08/01/2022
5 08/15/2022

I want to dataset from 07/20/2022 to 08/31/2022
ID Date
1 07/29/2022
2 08/01/2022
3 08/15/2022

[PaigeMiller]

Assuming these are numeric date variables 

data want;
    set have;
    if '20JUL2022'd <= date <= '31AUG2022'd;
run;

Please provide data as working SAS data step code from now on. You can follow these instructions or type the working SAS data step code yourself. Doing this avoids us having to make assumptions or guesses about your data (which might be incorrect), which makes it much more likely that people can provide correct answers; this helps you and helps us.

[Kurt_Bremser]

---

@Smitha9 wrote:

Hi,

I need a dataset from 

07/29/2022 to 08/31/2022 in SAS.

---

The answer to this question is

data want;
do date = '29jul2022'd to '31aug2022'd;
  output;
end;
format date mmddyy10.;
run;

But we may have a Maxim 42 issue here.