topic Re: I need to count just one visit per client and per week. How can I do that in Enterprise Guide? in SAS Enterprise Guide

I need to count just one visit per client and per week. How can I do that in Enterprise Guide?

Aniteb — Tue, 14 Jul 2015 15:48:59 GMT

Hi everyone,

I can't resolve this problem. I have a list of clients visits in a three months period and I need to count those visits one per client and per week. I have only today and last week's Friday dates and the dates of the clients visits.

How can I list one visit per client and per week in SAS Enterprise Guide?

Thanks for your help!

Re: I need to count just one visit per client and per week. How can I do that in Enterprise Guide?

ballardw — Tue, 14 Jul 2015 16:43:10 GMT

Do you have any rule such as the earliest or latest visit or do you require a single random selection if there are more than one visit per week?

Re: I need to count just one visit per client and per week. How can I do that in Enterprise Guide?

Reeza — Tue, 14 Jul 2015 17:00:45 GMT

Look at the SORT Task in EG and the unique options there.

You may need to sort twice, the first time to get the data in the order you want and the second so you can take the first record.

Re: I need to count just one visit per client and per week. How can I do that in Enterprise Guide?

Aniteb — Wed, 15 Jul 2015 13:58:06 GMT

It can be the earliest visit. I don't have a specific rule for that, I just want to count one visit per week.

Re: I need to count just one visit per client and per week. How can I do that in Enterprise Guide?

ballardw — Wed, 15 Jul 2015 15:11:13 GMT

Here is one way. A format to create groups by week within client and count, then count the result.

proc format library=work;

picture yearweek (default=8)

other= '%Y/%0U' (datatype=date);

run;

proc freq data=have noprint;

tables client * date /list norow nocol nopercent out=temp;

format date yearweek. ;

run;

The set TEMP will have one record per client per week.

You haven't provide an example of what the final output(s) might look like but you can get a total of clients per week by summarizing the Temp dataset variable date. A count of client would give you the total unique clients in the data.

proc freq data=temp;

tables date;

run;