Basically I have these two data files which are Inputfile1 and Inputfile2. To get to the output we need to match location, country and school code and date. Underneath each date is the amount of students away on the weekend to match the certaindate variable in inputfile1 with the dates in Inputfile2, I need to firstly subtract the dates in InputFile2 by 6 and check if Certain date is less then that. The dates in Inputfile2 are layed out exactly like the way I have put them they dont have a variable assigned to them Matching the dates So to match the date we subtract the date in Inputfile2 by 6 and check if CertainDate is less then that, the dates are layed out they don't have any variables assigned to them Inputfile2 Country Location SchoolCode 26/07/2009 02/08/2009 09/08/2009 16/08/2009 23/08/2009 30/08/2009 06/09/2009 13/09/2009 America IL 123456 24 45 America GA 456777 44 6 America TXS 456565 25 45 Inputfile1 Country Location SchoolCode CertainDate America IL 123456 24/07/2009 America GA 456777 19/07/2009 Output Country Location SchoolCode DatesAbsent America IL 123456 45 America GA 456777 44 Pls Help cheers
... View more