I am trying to create a table from a VERY large dataset. I have several variables that need to be included (city, lat, long, year, month) and some I want to calculate. I have daily data with an avg, min and max for each day ie: Name Date Lat Long Month Year Max Min Average Shaoguan 01/01/2000 24.667 113.6 Jan 2000 59 21 45 Shaoguan 01/02/2000 24.667 113.6 Jan 2000 63 20 49 I need to make a table that sorts by name (and keeps the corresponding lat & long), then by year, then by month, and that does away with the daily figures and just shows the average of max, min, and average for each month. I get this information via proc means, but the table format is not what I need. I want to add the average of each of the min, max and avg variables as new columns, rather than the way they display as rows in proc means. I need a final result like this: Name Lat Long Month Year AvgMax AvgMin AvgAverage Shaoguan 24.667 113.6 Jan 2000 59 21 45 Shaoguan 24.667 113.6 Feb 2000 54 18 37
... View more