topic Re: duration dates in New SAS User

duration dates

Smitha9 — Wed, 30 Nov 2022 15:03:42 GMT

Hi,

I need a dataset from

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

thanks in advance.

Re: duration dates

PaigeMiller — Wed, 30 Nov 2022 15:07:12 GMT

Can you provide more details?

Re: duration dates

Smitha9 — Wed, 30 Nov 2022 15:13:28 GMT

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

Re: duration dates

PaigeMiller — Wed, 30 Nov 2022 15:20:48 GMT

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.

Re: duration dates

Kurt_Bremser — Wed, 30 Nov 2022 15:57:42 GMT

@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.