I have two tables (Have, and Have2). I would like to create a new table (Want) joining those two tables. I created two new columns in the third table based on a condition. The new table has multiple rows of an ID. But I want one row for each ID. Please help. data have; input ID AgeGroup $ Gender $ Race $ VaccinStatus $ Date_First:mmddyy10. Date_Last:mmddyy10.; Format Date_First Date_Last mmddyy10.; datalines; 100 18-24 F Asian Full 01/02/2012 03/12/2018 101 25-29 M Hispanic Full 05/04/2012 10/12/2015 102 18-24 F White None . . 103 55+ M White Full 04/02/2015 03/12/2018 104 40-44 F Hispanic None . . 105 18-24 M Asian Full 05/02/2017 03/12/2018 106 50-54 M White Full 06/02/2020 03/12/2022 107 30-34 M Asian None . . 108 18-24 M Hispanic Full 04/02/2016 03/12/2017 109 40-44 M White Partial 11/02/2012 . 110 45-49 M Other Full 12/02/2021 03/12/2024 111 55+ F Asian Full 09/02/2012 03/12/2017 112 40-44 M Other Partial 06/02/2015 . 113 35-39 F Hawaiian Partial 02/02/2016 . 114 25-29 M Asian Full 09/02/2019 03/12/2020 115 40-44 M Hawaiian Full 05/02/2017 03/12/2018 116 30-34 F White Partial 06/02/2012 . 117 40-44 F White Full 03/02/2015 03/12/2019 118 45-49 F Asian Full 03/02/2014 03/12/2017 119 18-24 M Hispanic Full 01/02/2016 03/12/2018 120 25-29 F White None . . 121 55+ M White Full 02/02/2012 03/12/2018 122 45-49 F Hispanic None . . 123 50-54 M Asian Full 06/02/2013 03/12/2017 124 30-34 M White Full 01/02/2016 03/12/2019 125 40-44 M Asian None . . 126 18-24 M Hispanic Full 08/02/2021 03/12/2023 127 55+ M White Partial 08/02/2019 . 128 35-39 M Other Full 07/02/2015 03/12/2018 129 50-54 F Asian Full 05/02/2013 03/12/2014 130 18-24 M Other Partial 11/02/2015 . 131 35-39 F Hawaiian Partial 12/02/2016 . 132 45-49 M Asian Full 01/02/2013 03/12/2016 133 40-44 M Hawaiian Full 05/02/2014 03/12/2015 134 30-34 F White Partial 04/02/2016 03/12/2018 135 18-24 F White Full 01/02/2015 03/12/2019 run; data have2; input ID Date_Adm:mmddyy10. ; Format Date_Adm mmddyy10.; datalines; 100 01/02/2012 100 03/12/2015 100 03/12/2018 103 03/12/2013 103 04/02/2015 103 03/12/2016 103 03/12/2018 107 04/02/2015 108 03/12/2012 108 01/02/2017 110 03/12/2018 111 03/12/2011 111 01/02/2012 111 03/12/2017 111 03/12/2018 115 03/12/2018 115 01/02/2012 117 06/12/2019 118 08/12/2018 119 03/12/2015 120 01/02/2012 121 03/12/2018 122 06/12/2020 123 10/12/2012 124 12/12/2023 125 06/12/2020 126 09/12/2018 127 01/02/2012 128 06/12/2020 136 08/12/2018 136 03/02/2021 136 08/02/2012 137 05/12/2018 138 07/12/2014 139 09/12/2018 139 10/12/2017 run; Proc sql; Create table Want as Select H1.ID, AgeGroup, Gender, Race, VaccinStatus, Date_First, Date_Last ,Case when Date_First = Date_Adm then 1 else 0 end as FirstDtMatch ,Case when Date_Last = Date_Adm then 1 else 0 end as LastDtMatch from Have as H1 Left join Have2 as H2 On H1.ID = H2.ID; Run; For example, I am getting the 'want'  table like below, |   ID   |   NewCol1  |  NewCol2  | ------------------------------------ | 101  |        1             |       0            | | 101  |        0            |       0            | | 101  |        0            |       1            |   -----------------------------------   But I want that like below |   ID   |   NewCol1  |  NewCol2  | ------------------------------------ | 101  |        1             |       1            | -----------------------------------       ... View more

I have a table 'have' with the following columns. ID AgeGroup: 18-24, 25-29, 30-34, 35-39, 40-44, 45-49, 50-59, 60+ Gender: F, M Race: Black, White, Hispanic, Asian, Hawiian/AmIndian, Other Vaccination Status: Full, Partial, None   Sample table   data have; input ID AgeGroup $ Gender $ Race $ VaccinStatus $; datalines; 100 18-24 F Asian Full 101 25-29 M Hispanic Full 102 18-24 F White None 103 55+ M White Full 104 40-44 F Hispanic None 105 18-24 M Asian Full 106 50-54 M White Full 107 30-34 M Asian None 108 18-24 M Hispanic Full 109 40-44 M White Partial 110 45-49 M Other Full 111 55+ F Asian Full 112 40-44 M Other Partial 113 35-39 F Hawaiian Partial 114 25-29 M Asian Full 115 40-44 M Hawaiian Full 116 30-34 F White Partial 117 40-44 F White Full 118 45-49 F Asian Full 119 18-24 M Hispanic Full 120 25-29 F White None 121 55+ M White Full 122 45-49 F Hispanic None 123 50-54 M Asian Full 124 30-34 M White Full 125 40-44 M Asian None 126 18-24 M Hispanic Full 127 55+ M White Partial 128 35-39 M Other Full 129 50-54 F Asian Full 130 18-24 M Other Partial 131 35-39 F Hawaiian Partial 132 45-49 M Asian Full 133 40-44 M Hawaiian Full 134 30-34 F White Partial 135 18-24 F White Full run;       I would like to create a 100% stacked bar chart where AgeGroup with categories, Gender with categories, Race with categories will be on the X-axis and Vaccination Status will be on the Y-axis.     I tried the following code but failed.   Proc SGPLOT data=Have pctlevel=group; Vbar AgeGroup, Gender, Race / group = VaccinStatus Stat=percent; Title 'Vaccination Status by Age, gender and race'; Xaxis discreteorder=data; YAXIS grid values=(0 to 100 by 10); run; quit;   Error Log: NOTE: Writing HTML5(EGHTML) Body file: EGHTML 27 28 Proc SGPLOT data=Have pctlevel=group; 29 Vbar AgeGroup, Gender, Race / group = VaccinStatus Stat=percent; _ 22 200 ERROR 22-322: Syntax error, expecting one of the following: ;, /. ERROR 200-322: The symbol is not recognized and will be ignored. 30 Title 'Vaccination Status by Age, gender and race'; 31 Xaxis discreteorder=data; 32 YAXIS grid values=(0 to 100 by 10); 33 run; ... View more

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