topic Re: Finding the average distance traveled per purchase. in SAS Programming

Finding the average distance traveled per purchase.

Garzaluis998 — Thu, 24 Sep 2020 06:03:47 GMT

Hello,

I am having problems with figuring out the code to find the avg distance traveled per purchase on a dataset. I seem to keep getting error.

I found the average on purchases and average on distance traveled with the following code:

proc summary data=have nway;
class location_id;
var purchases;
output out=want (drop=_:)
mean=avgdist;
run;

proc summary data=have nway;
class location_id;
var milestravelled;
output out=want (drop=_:)
mean=avgdist;
run;

Need help in finding the avg distance traveled per purchase.

Thank you.

Re: Finding the average distance traveled per purchase.

Kurt_Bremser — Thu, 24 Sep 2020 06:11:06 GMT

If variable purchases is a count, use it in a WEIGHT statement.

PS you will want to invert it first.

Re: Finding the average distance traveled per purchase.

PaigeMiller — Thu, 24 Sep 2020 10:41:10 GMT

@Garzaluis998 wrote:

I am having problems with figuring out the code to find the avg distance traveled per purchase on a dataset. I seem to keep getting error.

Don't make us guess what the error is. SHOW US the error. If it is an error that appears in the LOG, show us the ENTIRE log for the PROC SUMMARY step, including CODE as it appears in the log, and all NOTEs, WARNINGs and ERRORs in the log for PROC SUMMARY.