cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Garzaluis998
‎09-25-2020
  • 3 Posts
  • 1 Likes Given
  • 0 Solutions
  • 0 Likes Received

Finding the average distance traveled per purchase.

by Calcite | Level 5 in SAS Programming
‎09-24-2020 02:03 AM
‎09-24-2020 02:03 AM
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.  ... View more

Easiest way to calculate Percentages?

by Calcite | Level 5 in SAS Programming
‎09-23-2020 12:16 PM
‎09-23-2020 12:16 PM
I have a data set that I need to calculate percentages on.   Sample Table: Group   -------------- Quantity -------------- CumulativeQuantity A                                 2                                          10 A                                 3                                          10 A                                5                                           10 etc. 2000+ observations   Want something like this (add a percent variable): Group   -------------- Quantity -------------- CumulativeQuantity-------- Percent A                                 2                                          10                         20% A                                 3                                          10                         30% A                                5                                           10                          50% etc./and so on for 2000+ observations   Can't seem to get the code correct to output percent.   Thank you for your help!   ... View more

Compute Cumulative Distance between longitude/latitude points

by Calcite | Level 5 in SAS Programming
‎09-14-2020 06:20 PM
‎09-14-2020 06:20 PM
Dear Forum,   I have yet been able to devise a working piece of code that will create a cumulative total column that resets at each break in another variable. Have over 7k in observations.   For example, given the following sample data set.   1   NY   ZIPCODE#      long#   lat# 2   NY   ZIPCODE#      long#   lat# 3   NY    ZIPCODE #    long#  lat# 4   NY    ZIPCODE#     long#  lat# 5   NY   ZIPCODE#      long#   lat# 6   LA    ZIPCODE#      long#   lat# 7   LA    ZIPCODE#      long#   lat# 8   LA    ZIPCODE#      long#   lat# 9   LA    ZIPCODE#      long#   lat# 10  LA   ZIPCODE#      long#   lat#   I will like to compute the cumulative distance (measured in kilometers) between each of the ZIP codes in each state. With the total cumulative distance being shown in the last observation of the given state.    Thank you for any help! ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎09-25-2020 01:09 AM
Likes given to
View All
Quick links