Here is an example i created to help you out .   Data testingT; /*To reference Dates in code use this format "date"d (followed by a d ) */ /*To reference Times in code use this format "Time"t (followed by a t)*/ /*To reference DateTime in code use this format "DateTime"dt (followed b a dt)*/ endt='08:15't; starttime="07:15"t; /*use the intck to compare date values year , month and even hour;*/ hdiff=intck("hour",starttime,endt,"C"); run; ... View more

No easy way to do this, or none that i know of with Proc SQL . 😞   Here is one way that i know of doing this, unfortunately, you didn't provide any sample data so hard to test but here is some code to start you off.   I would use the data step to accomplish this task as the data step has much more flexibility and control when processing data  /*Make sure all data is sorted in this example its*/ /*by SomeValue */ /*Do this for each file - if not all ready sorted*/ /*below is one example*/ /*proc sort data=Temp_original;*/ /*by somevalue;*/ /*run;*/ Data Temp_Join asselect; Merge Temp_Original(in=INOriginal) Temp1(in=INTemp1) Temp2(in=INTemp2) Temp3(in=INTemp3) Temp4(in=INTemp4) Temp5(in=INTemp5) Temp6(in=INTemp6); if INOriginal=1 then fromfile=0; if INTemp1=1 then fromfile=1; if INTemp2=1 then fromfile=2; if INTemp3=1 then fromfile=3; if INTemp4=1 then fromfile=4; if INTemp5=1 then fromfile=5; if INTemp6=1 then fromfile=6; if INOriginal=1; /*Keeping all by variables that match the Original file*/ run;   ... View more

No, there isn't a quick way to kill all jobs. You can kill all jobs by creating a SAS program that kills SAS processes (see link below for Unix server) or use O/S commands/scripts. Please be careful when doing this as you will be killing all jobs, including batch jobs that have been submitted to run overnight. If you decide to use a SAS program instead of O/S scripts, once you create and test your SAS program then you can deploy that job from within Management console and create a flow and schedule it to run every day.   The SAS Terminator: An Ultimate Killer of Unix Processes (lexjansen.com)      ... View more