topic Re: Mean by Two Variables in SAS Programming

Mean by Two Variables

BCNAV — Fri, 28 Sep 2018 16:21:58 GMT

This is probably easy, but maybe not. I have data as:

origin destination distance_km

CYYC CYUL 100

EGGL EDDF 200

They airport combinations (origin and destination). Many occur and can repeat.

How could I get output of unique airport combinations with the average km?

For example, the output would show for every unique origin/destination pair

origin destination avg_distance_km

CYYC CYUL 101.554

EGGL EDDF 202.678

thanks

Re: Mean by Two Variables

PeterClemmensen — Fri, 28 Sep 2018 16:29:17 GMT

How is the value 101.554 calculated?

Re: Mean by Two Variables

Reeza — Fri, 28 Sep 2018 16:29:41 GMT

Did you try PROC MEANS?

Re: Mean by Two Variables

Tom — Fri, 28 Sep 2018 16:36:16 GMT

Use PROC MEANS (or SUMMARY they are the same proc). You can either sort the data and use BY statement. Or use a CLASS statement. If you use a class statement you might want to add NWAYS and MISSING option.

Re: Mean by Two Variables

BCNAV — Fri, 28 Sep 2018 16:48:27 GMT

thanks! I am using

PROC MEANS data=EGTASK.CCDA_BILLABLE NOPRINT NWAY MISSING;
	CLASS depart dest;
	VAR GOA_FLOWN_GC_DISTANCE;
	OUTPUT OUT=EGTASK.CCDA_PAIRS_AVG_KM_TMP MEAN=;
RUN;

and it seems good!