Hi, I would like to create a final report for each doctor as follows: Doctor A Metric 2001 2002 2003 ---------------------------------------------------------------------- Hours worked 2,540 5,789 3,274 Avg pts seen per day 1.25 5.25 0.65 Compensation $2001 $2002 $2003 <<another completely separate report for Doctor B>> I currently have created individual datasets for each metric, normally using proc freq with a "by" statement or proc means with a "by" statement. I have been manually inputting the value of each proc freq or proc means for each doctor into an excel file to look like the above. However, my boss just informed me that my list of doctors has grown to over 100, so doing this manually is not going to work! I've been reading up on PROC REPORT, PROC TEMPLATE and even PROC PRINT. However, My problem is is that the data years (e.g., 2011) have different formats depending on the metric (e.g., some times I need to format with a dollar sign, other times it's a straight number and other times I need commas to express thousands), so merging by data year is not going to work in a data step. Does anyone have any suggestions?
... View more