About Ajitesh

Ajitesh · ‎10-24-2021

Hi Everyone, I am facing issue in data manipulation. Please help. I have input file as Input File ID Date Flag1 ABC 24-Oct-21 23 ABC 23-Oct-21 45 ABC 8-Oct-21 33 XYZ 24-Jul-21 44 XYZ 25-Jul-21 98 Output require- ID Date Flag1 Date2 Flag2 Date3 Flag3 ABC 24-Oct-21 23 23-Oct-21 45 8-Oct-21 33 XYZ 24-Jul-21 44 25-Jul-21 98

Ajitesh · ‎11-22-2019

Thanks for your reply but you did not understand my question. I want to create macro and want to pass all the accounts through macro. And i know proc sql query.

Ajitesh · ‎11-22-2019

Hi, I have 10000 account numbers and i just want to pass all the account numbers one by one through SAS Macro. I am using this query- proc sql; create table abc select * from xyz where account in (want to pass accounts through SAS Macro); quit;

Ajitesh · ‎02-05-2019

Thank you so much.

Ajitesh · ‎02-02-2019

Can someone tell how to prepare and build the logic on SAS to catch Common purchase point. CPP analysis identifies the likely merchant location from where card numbers were stolen so that banks can mitigate future fraud.

Ajitesh · ‎08-12-2018

Thank you so much for your response. Codes are working fine and it gives same result. Proc sql code is good. Thanks.

Ajitesh · ‎08-11-2018

Thanks for quick reply.. this code is really good and working .. but i need data date wise as well... now i m getting result like this- logon new_date user logoff 9:00 06/20/2018 user1 13:04 3:00 06/20/2018 user2 20:02 12:00 06/20/2018 user3 1:50 this is giving 20th june data only.. i need same result for a month like logon new_date user logoff 9:00 06/20/2018 user1 13:04 8:30 06/21/2018 user1 5:30 3:00 06/20/2018 user2 20:02 8:30 06/21/2018 user2 5:00 12:00 06/20/2018 user3 1:50 8:30 06/21/2018 user3 5:50

Ajitesh · ‎08-11-2018

I need login and logout time of every users for every day

Ajitesh · ‎08-11-2018

Thanks for reply.... but in my data date, time, and users are changing like this- data test; format date date9. Action_time time10.; input Date date9. Action_Time time10. User_Name$20.; cards; 1-Jul-18 8:00:00 am Ankit 1-Jul-18 9:00:00 am Ankit 1-Jul-18 9:30:00 am Ankit 2-Jul-18 9:30:00 am Ankit 2-Jul-18 9:45:00 am Ankit 1-Jul-18 9:00:00 am Rekha 1-Jul-18 9:30:00 am Rekha 1-Jul-18 9:30:00 am Rekha 2-Jul-18 6:30:00 pm Rekha 2-Jul-18 6:40:00 pm Rekha ; run;

Ajitesh · ‎08-11-2018

But my data have multiple user's alerts performance with date and time like this- data test; format date date9. Action_time time10.; input Date date9. Action_Time time10. User_Name$20.; cards; 1-Jul-18 8:00:00 am Ankit 1-Jul-18 9:00:00 am Ankit 1-Jul-18 9:30:00 am Ankit 2-Jul-18 9:30:00 am Ankit 2-Jul-18 9:45:00 am Ankit 1-Jul-18 9:00:00 am Rekha 1-Jul-18 9:30:00 am Rekha 1-Jul-18 9:30:00 am Rekha 2-Jul-18 6:30:00 pm Rekha 2-Jul-18 6:40:00 pm Rekha ; run;

Ajitesh · ‎08-11-2018

I have a data like- data test; input Date Action_Time User_Name cards; 1-Jul-18 8:00 Ankit 1-Jul-18 9:00 Ankit 1-Jul-18 9:30 Ankit ................. ................ 1-Jul18 5:30 Ankit ; run; i want result for every user- User_Name login_date login_time logout_time. Ankit 1-Jul-18 8:00 am 5:30 pm Rekha 1-Jul-18 8:30 am 5:00 pm Please help me with solution. Thanks in advance.

Online Status	Offline
Date Last Visited	‎10-29-2021 01:53 AM

Data step query

Re: How to pass account numbers through SAS Macro

How to pass account numbers through SAS Macro

Re: Common Purchase Point in fraud analytics for credit card industry

Common Purchase Point in fraud analytics for credit card industry

Re: I need user login and logout time for every day.

Re: I need user login and logout time for every day.

Re: I need user login and logout time for every day.

Re: I need user login and logout time for every day.

Re: I need user login and logout time for every day.

Re: Common Purchase Point in fraud analytics for credit card industry

Data step query

Re: How to pass account numbers through SAS Macro

How to pass account numbers through SAS Macro

Re: Common Purchase Point in fraud analytics for credit card industry

Common Purchase Point in fraud analytics for credit card industry

Re: I need user login and logout time for every day.

Re: I need user login and logout time for every day.

Re: I need user login and logout time for every day.

Re: I need user login and logout time for every day.

Re: I need user login and logout time for every day.

I need user login and logout time for every day.