Hello, I am struggling on finding a list of dates that are in the certain date range. Two datasets are many to many. Any way to do this?  Thanks in advance.   The final result should be look like below. ID SVC_DT 123 05Jan2019 123 20Aug2019 456 02Jul2019 567 03Sep2019 567 04Dec2019   Here is my two datasets: 1. data Have; input ID $ DATE :mmddyy10.; format date date9.; cards; 123 12/04/2018 123 01/05/2019 123 08/20/2019 123 12/04/2019 456 07/01/2019 456 04/02/2019 567 09/03/2019 567 12/04/2019 567 03/02/2019 ; run; 2. data Range; input ID $ START :mmddyy10. END :mmddyy10.; format START END date9.; cards; 123 10/01/2018 03/03/2019 123 05/01/2019 09/30/3019 456 05/01/2019 09/30/3019 567 07/01/2019 10/31/2019 567 11/01/2019 12/31/2019 ; run;   ... View more

Hello,   I need to combine rows by certain groups, and keep everything into one row. I tried proc means, but it replaced previous records.   Also is there a way to combine the field names? Please see the highlights in the final result (ie: aa_MM1).   Thanks in advance.   Here is original data: data test; input locations $ year type $ MM1-MM4; datalines; NY 2017 aa 560 560 687 560 NY 2017 bb 785 432 450 222 NY 2017 cc 160 160 765 160 NY 2018 aa 360 360 360 360 NY 2018 bb 570 570 493 570 NY 2018 cc 160 245 542 160 NY 2019 bb 432 340 360 532 NY 2019 cc 555 457 675 988 PA 2017 aa 560 560 687 560 PA 2017 bb 785 432 450 222 PA 2018 aa 360 360 360 360 PA 2018 bb 570 570 493 570 PA 2018 cc 160 245 542 160 PA 2019 bb 432 340 360 532 ; locations year type MM1 MM2 MM3 MM4 NY 2017 aa 560 560 687 560 NY 2017 bb 785 432 450 222 NY 2017 cc 160 160 765 160 NY 2018 aa 360 360 360 360 NY 2018 bb 570 570 493 570 NY 2018 cc 160 245 542 160 NY 2019 bb 432 340 360 532 NY 2019 cc 555 457 675 988 PA 2017 aa 560 560 687 560 PA 2017 bb 785 432 450 222 PA 2018 aa 360 360 360 360 PA 2018 bb 570 570 493 570 PA 2018 cc 160 245 542 160 PA 2019 bb 432 340 360 532   Below is what I want to be:   locations year aa_MM1 aa_MM2 aa_MM3 aa_MM4 bb_MM1 bb_MM2 bb_MM3 bb_MM4 cc_MM1 cc_MM2 cc_MM3 cc_MM4 NY 2017 560 560 687 560 785 432 450 222 160 160 765 160 NY 2018 360 360 360 360 570 570 493 570 160 245 542 160 NY 2019         432 340 360 532 555 457 675 988 PA 2017 560 560 687 560 785 432 450 222         PA 2018 360 360 360 360 570 570 493 570 160 245 542 160 PA 2019         432 340 360 532         ... View more

Hello,   I have a dataset that most of the fields are characters. When I output this dataset to Excel using DDE, there is a space before each characters. How can I get ride of the space?   Thanks in advance!   Here is my program:   Options noxwait noxsync; X "'&TemplatePath.&TemplateName..xlsx'"; Options xwait xsync; FILENAME ddecmd DDE 'EXCEL|SYSTEM'; FILENAME DATA  DDE "EXCEL|sheet1!R2C1:R7C2" NOTAB; DATA _null_;    SET file;    FILE DATA LRECL=30000;      DLM='09'X;       PUT Region DLM Dept DLM; run; DATA _NULL_;   FILE ddeCMD;   PUT "[SAVE.AS(%BQUOTE("&SavePath.&SaveName._&Sysdate..xlsx "))]";   PUT  '[CLOSE()]' ; Replace; RUN;     ... View more