The following code works based on the data provided. This assumes the data is sorted by client and uses by group processing and the lag function.   data have2; set have; by client; p_end = lag(end); p_start = lag(start); p_client = lag(client); p_account = lag(account); diff = abs(p_end-start); format p_start p_end date9.; if 0<= diff <=4 then do; client = p_client; account = p_account; start = p_start; end; if first.client =0 then delete; keep client account start end; run; ... View more

This solution uses PROC SORT and Group processing in the DATA STEP.   proc sort data=have out=have2; by id start_dt end_dt; run;   data have2; set have2; retain id2 start_dt2; by id start_dt end_dt; if first.id then do; id2=id; start_dt2=start_dt; end; if last.id then end_dt2=end_dt; if last.id; format start_dt2 end_dt2 mmddyy10.; keep id2 start_dt2 end_dt2; run;         ... View more

Have you explored the interactive "Send Email as a Step" feature in Enterprise Guide. You must use a Process Flow, right click on program -> Share -> Email as a step in the project.  Then uncheck option to "Send even when errors occur in the files".  Note the "Add" button on the right in step 1 to choose the type of file you want to send from inside or outside of your project. You may want to turn on the global Project Log when using this feature.  See relevant screen captures below            SAS Help Center: Using the Project Log     ... View more

You can use the ANYDTDTE informat to read your date, however to must use a special character to separate the year from the month not an "M". This can be done with the TRANWRD function.    data test; cdate = "2023M01"; cdate = tranwrd(cdate,"M","-"); ndate = input(cdate,anydtdte.); format ndate yymm.; run;   ... View more

Please contact SAS Technical Support for assistance with this issue. See link below SAS Technical Support | SAS Support ... View more

Plans created in SAS Data Studio are like templates of all the modifications you created. You must run the Plan in Data Studio and also save a table with the plan. The saved table can be opened in SAS Visual Analytics for analysis.   To learn more, check out these videos: https://video.sas.com/detail/video/5785551710001/using-sas-data-studio-to-prepare-and-transform-data-into-the-desired-format?autoStart=true&q=data%20studio#search/data%20studio/1   SAS Tutorial | Getting Started with SAS Visual Analytics on SAS Viya (youtube.com)   Also, consider attending this course:  Course: SAS® Visual Analytics 1 for SAS® Viya®: Basics     ... View more

Can you send a screen print of the results. ... View more

You can use Proc Print and ODS statements to export to Excel.  See sample code below using SASHELP.CARS    proc sort data = sashelp.cars out=cars; by make; run; ods excel file = "c:\temp\cars.xlsx" options(sheet_interval='none'); proc print data=cars; id make; by make; sum msrp invoice; run; ods excel close;   ... View more

Can you send a screen capture? ... View more

You can try copy and paste in the server menu on the left.  Then you can modify your code to write to the new library for future submissions       ... View more

Try re-posting under Analytics -> Statistical Procedures ... View more

Try adding the following before the libname statement: cas mySess sessopts=(caslib=BAL_EMISONES);   If this does not work, reach out to technical support. Technical Support | SAS   ... View more