The following statement is for current year %let Yr = %sysfunc(Year(%sysfunc(today()))); What would be the statement for previous year or next year? I tried the statement below, but did not work. %let PrevYr = %sysfunc(Year(%sysfunc(today())))-1; ... View more

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 ... View more

I have the following dataset. data have; informat Month mmddyy8.; input ID Group $ Month ; Format Month mmddyy8.; cards; 01 A 12/03/22 02 A 11/03/22 03 B 12/17/22 04 A 10/17/22 05 B 09/24/22 06 B 12/24/22 07 C 10/24/22 08 A 12/31/22 09 A 01/14/23 10 B 02/14/23 11 A 02/21/23 12 A 03/21/23 13 A 04/14/23 14 C 03/14/23 15 A 01/21/23 16 C 04/21/23 17 A 02/14/23 18 C 01/14/23 19 B 03/21/23 20 C 01/21/23 ; I would like to create a report with two columns only. Month and number. Months as Dec2022, Jan2023, Feb2023 etc. The report will have the months in correct order in the month column (not alphabetic order).   I tried the following but did not work. proc report data=have; column month n; define month / group format=monyyyy.; run;   ... View more

I have a data set that has three columns (one column mentions day of a month, 2nd column mentions month, and the 3rd column mentions year). I would like to combine the data in those three columns to create a date column.   data have; input ID $ StartMonth StartDay StartYear ; cards; 001 10 9 2022 002 4 3 2022 003 2 7 2022 004 7 17 2022 005 10 24 2022 006 11 14 2022 ; ... View more