About sunnyday

sunnyday · ‎02-11-2023

Hi @ballardw . Even if not the whole code, but if you can even explain the logic of how can I achieve the reapplication flag, date and channel, that would be great. Thanks.

sunnyday · ‎02-11-2023

Thanks @PaigeMiller for streamlining! Please let me know if you have any solution to my problem. Thanks!

sunnyday · ‎02-11-2023

Hi Experts, I'm doing a case study for which I need some help. Background - There are a bunch of people who have applied for Visa and have made multiple applications through different channels. I have to find out if a person has reapplied within 30 days of their previous application (Y/N), their reapplied channel and date. Every entry should be considered independent irrespective of multiple entries by a single person. Ex - PETE5O made first application on 5th Aug but second was not made within 30 days hence is it is not reapplied but the third was made within 30 days of second and hence it is reapplied and also the channel of reapplication would be channel of third application here (which is basically reapplication) so and so forth. There can be n number of applications made by a single person. Please advise what should I do. I have info in yellow but want to get the info in blue. Code - data have; format apply_date date9.; input Id $ Channel $ Apply_date date9. ; cards; SAM1D Online 1-Oct-22 SAM1D Kiosk 9-Oct-22 PETE5O Office 5-Aug-22 PETE5O Kiosk 6-Sep-22 PETE5O Online 8-Sep-22 PETE5O Kiosk 5-Oct-22 ; Thanks in advance.

sunnyday · ‎02-10-2023

Thanks for your quick response, @ballardw . I've now edited the code to make the date in SAS date format and yes, there can be chances of reapplication, which also I have included. I understand your logic of getting the difference of dates but how can I proceed further with that when it comes to flagging the reapplication channel, dates, etc. Please advice. If you can please provide a code, that would be great. Thanks.

sunnyday · ‎02-10-2023

Hi Experts, I'm doing a case study for which I need some help. Background - There are a bunch of people who have applied for Visa and have made multiple applications through different channels. I have to find out if a person has reapplied within 30 days of their previous application (Y/N), their reapplied channel and date. Every entry should be considered independent irrespective of multiple entries by a single person. Ex - PETE5O made first application on 5th Aug but second was not made within 30 days hence is it is not reapplied but the third was made within 30 days of second and hence it is reapplied and also the channel of reapplication would be channel of third application here (which is basically reapplication) so and so forth. There can be n number of applications made by a single person. Please advise what should I do. I have info in yellow but want to get the info in blue. Code - data have; format apply_date date9.; input Id $ Channel $ Apply_date date9. ; cards; SAM1D Online 1-Oct-22 SAM1D Kiosk 9-Oct-22 PETE5O Office 5-Aug-22 PETE5O Kiosk 6-Sep-22 PETE5O Online 8-Sep-22 PETE5O Kiosk 5-Oct-22 ; Thanks in advance.

sunnyday · ‎11-25-2022

Thanks for the quick reply! I'll take care of the Code from next time.

sunnyday · ‎11-25-2022

Hi Experts! I'm new to this platform as well as SAS. Please help me out. I was trying to do proc transpose of a dataset with multiple variables and I wish to get all of them in columns and also the year sorting be done in ascending order. Below is the example. data have; input Id FirstName LastName year sales $ debt $; cards; ab1 Sam Tim 2020 100 0 ab1 Sam Tim 2021 50 70 cd2 Long Phelp 2019 225 10 ef3 Pam Trace 2022 15 15 ; Ran this query - proc transpose data=have out=want; by Id FirstName LastName; id year; var sales debt; run; Got this - ID Firstname Lastname _name_ 2020 2021 2022 2019 ab1 Sam Tim sales 100 50 ab1 Sam Tim debt 70 cd2 Long Phelp sales 225 cd2 Long Phelp debt 10 ef3 Pam Trace sales 15 ef3 Pam Trace debt 15 Want this - sales debt ID Firstname Lastname 2019 2020 2021 2022 2019 2020 2021 2022 ab1 Sam Tim 100 50 70 cd2 Long Phelp 225 10 ef3 Pam Trace 15 15 Please let me know how can this be done. Thank you!

Online Status	Offline
Date Last Visited	‎06-09-2023 04:36 PM

Re: Logic for Reapplication

Re: Flag variables on basis of Reapplication

Flag variables on basis of Reapplication

Re: Logic for Reapplication

Logic for Reapplication

Re: Proc transpose with multiple var

Proc transpose with multiple var

Re: Logic for Reapplication

Re: Flag variables on basis of Reapplication

Flag variables on basis of Reapplication

Re: Logic for Reapplication

Logic for Reapplication

Re: Proc transpose with multiple var

Proc transpose with multiple var