topic Re: how to find the freqencies for food delivery in SAS Programming

how to find the freqencies for food delivery

HitmonTran — Thu, 26 Nov 2020 04:12:18 GMT

Hi,

I have a dataset consisting: customers, food vendors, and order date .

Since customers can order from multiple food vendors within the same day, I need to figure out the frequencies and %'s of Vender A,B,C,etc. being ordered together within the same day.

dataset:

Name Vendor Order_date
Bob A 1-1-2020
Bob A 1-1-2020
Bob B 1-1-2020
Joe A 1-2-2020
Joe B 1-2-2020
Chris A 1-1-2020
Chris B 1-2-2020
David C 1-3-2020
David A 1-3-2020
David B 1-3-2020

want:
Vendor_comb count
A, B 3

bc Vendor A & B were ordered 3 times within the same day from Bob, Joe, David. Chris does not count bc he ordered on different days. Thanks

Re: how to find the freqencies for food delivery

ballardw — Thu, 26 Nov 2020 02:56:58 GMT

Try something like:

Proc freq data=have;

tables order_date*vendor / list ;

run;

Re: how to find the freqencies for food delivery

HitmonTran — Thu, 26 Nov 2020 03:14:00 GMT

it only give me the frequency for each vendors. I need the frequency of the combination (vendor A & B)

Re: how to find the freqencies for food delivery

ballardw — Thu, 26 Nov 2020 03:42:51 GMT

Incomplete description gives incomplete code.

Show ALL of the output you actually expect given your example data. As it should appear.

You show NO records with both A and B, so your date will need some serious rearranging, and you likely should show the intermediate step so that 'combinations of A and B' exist.

Re: how to find the freqencies for food delivery

HitmonTran — Thu, 26 Nov 2020 04:14:00 GMT

See edited post of "want" and let me know if this is clear. The goal is to find the count of any combination on the same date.