topic Re: How to extarct more the two timestamps in SAS Programming

How to extarct more the two timestamps

sdps963 — Wed, 26 Jul 2017 16:06:33 GMT

Hello everyone,

I've trouble pulling the data and your help needed.

I have a live dataset about a bank mobile application. It records customer name, customer Id and timestamps each time a customer logs into his application. I want to pull the data of the customers who have logged in more than two times in the last week.

Thanks in advance.

Re: How to extarct more the two timestamps

Reeza — Wed, 26 Jul 2017 16:44:53 GMT

How are you creating your query now?

If SQL, you can use HAVING.

HAVING(count(customer_ID))>1

Re: How to extarct more the two timestamps

sdps963 — Wed, 26 Jul 2017 16:47:20 GMT

Awesome, Thank you

Re: How to extarct more the two timestamps

Reeza — Wed, 26 Jul 2017 16:50:01 GMT

Sorry, that won't factor in last week, you'll have to also include a date filter. I'll leave that up to you because we can't see how your query is working.