This is my table I would like to create and output table that contains only the unique contact types and must contain the denom value of 1.  ID_KEY EVENT_KEY SERVICE_DATE TYPE_OF_CONTACT denom 100 50068022 03Jan2017 By phone 1 100 50068024 03Jan2017 By phone . 100 50068029 03Jan2017 By phone . 100 50068023 03Jan2017 In person - individual . 100 50068026 03Jan2017 In person - individual . 100 50068025 03Jan2017 In person - individual . 100 50068021 03Jan2017 In person - individual . 100 50068011 03Jan2017 In person - individual . 100 50068067 03Jan2017 By email .   The final table would look like this: ID_KEY EVENT_KEY SERVICE_DATE CONTACT_TYPE denom 100 50068022 03Jan2017 By phone 1 100 50068023 03Jan2017 In person - individual . 100 50068067 03Jan2017 By email . ... View more

%macro education(education, ORDER); data education; set history_education; where education="&education"; run; %mend %education(University Bachelor's,8)   Above is my macro but the apostrophe in Bachelor's isn't allow me to run this statement. Is there anyway around this? ... View more

Hello,   I have this table: Fruit Country Colour Frequency FY Apple Canada Red 34 201516 Apple Canada Red 39 201617 Apple Canada Red 43 201819 Apple Canada Red 36 201920   And it want it to display like this: Fruit Country Colour 201516 201617 201718 201819 201920 Apple Canada Red 34 29 . 43 36 ... View more