Dear sas users! I have a question regarding calculating averages between dates in my dataset. My dataset is as followed: whereby datum= date, tijd=time, bedrijf=company, temp=temperature, luchtvochtigheid=humidity, CO2=carbon dioxide and NH3= ammonia I have data from 12 weeks whereby every 10 minutes data from senors is logged. I have this for in total 10 companies. Now I want to calculate a 2 week average value for the 4 variables (humidity, temperature, CO2 and NH3) per company. Time is not important in this case. so for each company I want an avarage value for every 2 weeks (thus 6 average values per company) (this is because clinical analysis to the research object were done were I want to connect climate data to). I am not sure how to do this. Does anyone maybe have an idea? Thankyou in advance! Kind regards, Danniek
... View more