DATA Step, Macro, Functions and more

a sql question

Reply
Occasional Contributor
Posts: 15

a sql question

hi, I have a sql question as below:

 

Given timestamps of visits, how to figure out how many people visit all seven days of a week on the location?

 

Thanks.

Super User
Posts: 23,776

Re: a sql question

Posted in reply to flyingsohigh

Making a lot of assumptions:

 

1. Filter data for a week

2. Remove possible duplicate visits per week

3. Count unique dates, if < 7 then they did not visit every day in a week.

 

vague questions = vague answers


@flyingsohigh wrote:

hi, I have a sql question as below:

 

Given timestamps of visits, how to figure out how many people visit all seven days of a week on the location?

 

Thanks.


 

Ask a Question
Discussion stats
  • 1 reply
  • 78 views
  • 0 likes
  • 2 in conversation