Create table where year is the most recent year (2023) and the previous year (2022)

Barkat — Wed, 08 Nov 2023 18:37:17 GMT

I have a table as below

| Year | Month | Income |

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

| 2020 | 1 | 50 |

| 2020 | 4 | 70 |

| 2021 | 2 | 80 |

| 2021 | 11 | 70 |

| 2022 | 9 | 50 |

| 2022 | 11 | 54 |

| 2022 | 12 | 90 |

| 2023 | 2 | 70 |

| 2023 | 4 | 50 |

| 2023 | 6 | 40 |

| 2023 | 10 | 30 |

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

I would like to create a table from the have where year is the most recent year and the previous year. I do not want to use "where year in (2022, 2023)" because the year may change.

I tried in two different ways,

Data want; set have;
where year ge last.year-1;
run;

Data want; set have;
where year ge max.year-1;
run;

Thanks for your help

Re: Create table where year is the most recent year (2023) and the previous year (2022)

PaigeMiller — Wed, 08 Nov 2023 18:39:21 GMT

%let yr = %sysfunc(year(%sysfunc(today())));

data want;
    set have;
    if year>=%eval(&yr-1);
run;

Re: Create table where year is the most recent year (2023) and the previous year (2022)

Barkat — Wed, 08 Nov 2023 19:11:22 GMT

Just perfect!

topic Create table where year is the most recent year (2023) and the previous year (2022) in New SAS User

Create table where year is the most recent year (2023) and the previous year (2022)

Re: Create table where year is the most recent year (2023) and the previous year (2022)

Re: Create table where year is the most recent year (2023) and the previous year (2022)