cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
MagD
‎02-09-2023
  • 45 Posts
  • 6 Likes Given
  • 1 Solutions
  • 7 Likes Received

Re: Automating Dates

by Quartz | Level 8 in New SAS User
‎05-20-2022 05:23 AM
‎05-20-2022 05:23 AM
Thank you so much for your response and recommended approach. I truly appreciate it. ... View more

Re: Automating Dates

by Quartz | Level 8 in New SAS User
‎05-20-2022 05:22 AM
‎05-20-2022 05:22 AM
Thank you so much for this approach - I tested it out and it also works perfectly as well. Thank you for taking the time to assist me. ... View more

Re: Automating Dates

by Quartz | Level 8 in New SAS User
‎05-20-2022 05:20 AM
‎05-20-2022 05:20 AM
Thank you so much for this solution - it works perfectly. Thank you for your assistance. I appreciate it. ... View more

Re: Automating Dates

by Quartz | Level 8 in New SAS User
‎05-19-2022 09:41 AM
‎05-19-2022 09:41 AM
Hi Paige, Apologies for not providing a lot of information. The beginning of each month is the 1st, so next month's date will be 01Jun - 30Jun2022. Some time periods started at the 5th day of the month but that has been changed to the 1st day of the month hence the differences but the beginning of the time period is the 1st- I hope this helps. ... View more

Re: Automating Dates

by Quartz | Level 8 in New SAS User
‎05-19-2022 09:14 AM
‎05-19-2022 09:14 AM
Hey Tom, So I want to automate the code so that I do not need to keep manually adding more dates to the code, i.e. I won't have to manually add next month's date which will be June, i.e if sales_date le '30Jun2022'd then salesperiod = '27:' 01Jun - 30Jun2022'; ... View more

Automating Dates

by Quartz | Level 8 in New SAS User
‎05-19-2022 08:56 AM
‎05-19-2022 08:56 AM
Good afternoon everyone,   please help me with the automation of my code. I am relatively new to the automation of SAS codes. Please see the code that I am trying to automate below:   data sales; set Applied_Accounts;   if sales_date <> . then do; If sales_date le '05Apr2020'd then salesperiod  = '00: Sales pre Apr';else If sales_date le '05May2020'd then salesperiod = '01: 06Apr - 05May2020';else If sales_date le '05Oct2020'd then salesperiod  = '06: 06Sep - 05Oct2020';else If sales_date le '05Nov2020'd then salesperiod = '07: 06Oct - 05Nov2020';else If sales_date le '01Dec2020'd then salesperiod = '08: 06Nov - 01Dec2020';else If sales_date le '05Jan2021'd then salesperiod  = '09: 02Dec - 05Jan2021';else If sales_date le '05Feb2021'd then salesperiod  = '10: 06Jan - 05Feb2021';else If sales_date le '05Mar2021'd then salesperiod = '11: 06Feb - 05Mar2021';else If sales_date le '31Mar2021'd then salesperiod = '12: 06Mar - 31Mar2021';else If sales_date le '30Apr2021'd then salesperiod = '13: 01Apr - 30Apr2021';else If sales_date le '31May2021'd then salesperiod = '14: 01May - 31May2021';else If sales_date le '30Jun2021'd then salesperiod = '15: 01Jun - 30Jun2021';else If sales_date le '31Jul2021'd then salesperiod = '16: 01Jul - 31Jul2021';else If sales_date le '31Aug2021'd then salesperiod = '17: 01Aug - 31Aug2021';else If sales_date le '30Sep2021'd then salesperiod = '18: 01Sep - 30Sep2021';else If sales_date le '31Oct2021'd then salesperiod = '19: 01Oct - 31Oct2021';else If sales_date le '30Nov2021'd then salesperiod = '20: 01Nov - 30Nov2021';else If sales_date le '31Dec2021'd then salesperiod = '21: 01Dec - 31Dec2021';else If sales_date le '31Jan2022'd then salesperiod = '22: 01Jan - 31Jan2022';else If sales_date le '28Feb2022'd then salesperiod = '23: 01Feb - 28Feb2022';else If sales_date le '31Mar2022'd then salesperiod = '24: 01Mar - 31Mar2022';else If sales_date le '30Apr2022'd then salesperiod = '25: 01Apr - 30Apr2022';else If sales_date le '31May2022'd then salesperiod = '26: 01May - 31May2022';else salesperiod = '999:Update code'; end; run;   I want to automate this code so that I do not have to manually input the sales_data and the salesperiod.   Thank you in advance for your response. ... View more

Re: Converting Dates

by Quartz | Level 8 in New SAS User
‎04-13-2022 10:31 AM
‎04-13-2022 10:31 AM
Thanks Tom, it worked perfectly. ... View more

Re: Converting Dates

by Quartz | Level 8 in New SAS User
‎04-13-2022 10:23 AM
‎04-13-2022 10:23 AM
Hey Paige I used this data step: data test; set hello; AppDate1 = put(datepart(AppDate),date9.); run; AppDate1 comes out as desired (20DEC2019) but it gets converted into a character variable and I need it as a date. ... View more

Re: Converting Dates

by Quartz | Level 8 in New SAS User
‎04-13-2022 10:22 AM
‎04-13-2022 10:22 AM
Hey Tom, I used this data step: data test; set hello; AppDate1 = put(datepart(AppDate),date9.); run; AppDate1 comes out as desired (20DEC2019) but it gets converted into a character varaible and I need it as a date. ... View more

Converting Dates

by Quartz | Level 8 in New SAS User
‎04-13-2022 10:05 AM
‎04-13-2022 10:05 AM
Hi everyone,   Please help me with this query. I want to convert this date 20DEC2019:12:49:00.000 to 20DEC2019. ... View more

Re: How do I automate dates

by Quartz | Level 8 in New SAS User
‎04-06-2022 06:19 AM
‎04-06-2022 06:19 AM
Thank you so much @Kurt_Bremser, your solution worked! Thank you so much! ... View more

Re: Automation of Dates

by Quartz | Level 8 in New SAS User
‎04-06-2022 05:36 AM
‎04-06-2022 05:36 AM
Hi Patrick, Thank you for responding to my query. Yes, Because I don't have an ELSE statement the 2nd IF statement will come into effect - that's what is required. I think we can focus on this part of the code for now just to keep consistency: if '31Mar2021'd < csa_inv_dte < '01May2021'd then trademonth = '25:APR 2021'; else if '30Apr2021'd < csa_inv_dte < '01Jun2021'd then trademonth = '26:MAY 2021'; else if '31May2021'd < csa_inv_dte < '01Jul2021'd then trademonth = '27:JUN 2021'; else if '30Jun2021'd < csa_inv_dte < '01Aug2021'd then trademonth = '28:JUL 2021'; else if '31Jul2021'd < csa_inv_dte < '01Sep2021'd then trademonth = '29:AUG 2021'; else if '31Aug2021'd < csa_inv_dte < '01Oct2021'd then trademonth = '30:SEP 2021'; else if '30Sep2021'd < csa_inv_dte < '01Nov2021'd then trademonth = '31:OCT 2021'; else if '31Oct2021'd < csa_inv_dte < '01Dec2021'd then trademonth = '32:NOV 2021'; else if '30Nov2021'd < csa_inv_dte < '01Jan2022'd then trademonth = '33:DEC 2021'; else if '31Dec2021'd < csa_inv_dte < '01Feb2022'd then trademonth = '34:JAN 2022'; else if '31Jan2022'd < csa_inv_dte < '01Mar2022'd then trademonth = '35:FEB 2022'; else if '28Feb2022'd < csa_inv_dte < '01Apr2022'd then trademonth = '36:MAR 2022'; else if csa_inv_dte = . then trademonth = '99: No Inv'; So next month's code will include: if '31Mar2022'd < csa_inv_dte < '01May2022'd then trademonth = '37:APR 2022'; else but I want to automate these dates. Please let me know if I am being clear or not. ... View more

How do I automate dates

by Quartz | Level 8 in New SAS User
‎04-06-2022 05:15 AM
‎04-06-2022 05:15 AM
Good morning,   Please help me with automating dates in my code. I currently have the following code which I have to change every month: /*need to update at the beginning of the month*/ %let nin_TM = 01MAR2022; %let nin_LM = 01FEB2022; %let nin_LY = 01MAR2021;   Please help me with automating the dates in the above so that I don't need to manually change the dates every month.  ... View more

Automation of Dates

by Quartz | Level 8 in New SAS User
‎04-06-2022 04:43 AM
‎04-06-2022 04:43 AM
Good morning everyone,   I am very new to automating of codes/dates - Please help me with automating dates in my piece of code. I currently have the following coded up:   data test; set testing;   if '05Apr2019'd < csa_inv_dte < '06May2019'd  then trademonth = '01:APR 2019'; else if '05May2019'd < csa_inv_dte < '06Jun2019'd  then trademonth = '02:MAY 2019'; else if '05jun2019'd < csa_inv_dte < '06Jul2019'd     then trademonth = '03:JUN 2019'; else if '05jul2019'd < csa_inv_dte < '06Aug2019'd     then trademonth = '04:JUL 2019'; else if '05aug2019'd < csa_inv_dte < '06Sep2019'd  then trademonth = '05:AUG 2019'; else if '05sep2019'd < csa_inv_dte < '06Oct2019'd   then trademonth = '06:SEP 2019'; else if '05Oct2019'd < csa_inv_dte < '06Nov2019'd   then trademonth = '07:OCT 2019'; else if '05Nov2019'd < csa_inv_dte < '02Dec2019'd  then trademonth = '08:NOV 2019'; else if '01Dec2019'd < csa_inv_dte < '06Jan2020'd  then trademonth = '09:DEC 2019'; else if '05Jan2020'd < csa_inv_dte < '06Feb2020'd  then trademonth = '10:JAN 2020'; else if '05Feb2020'd < csa_inv_dte < '06Mar2020'd  then trademonth = '11:FEB 2020'; else if '05Mar2020'd < csa_inv_dte < '06Apr2020'd  then trademonth = '12:MAR 2020'; else if '05Apr2020'd < csa_inv_dte < '06May2020'd  then trademonth = '13:APR 2020'; else if '05May2020'd < csa_inv_dte < '06Jun2020'd  then trademonth = '14:MAY 2020'; else if '05jun2020'd < csa_inv_dte < '06Jul2020'd     then trademonth = '15:JUN 2020'; else if '05jul2020'd < csa_inv_dte < '06Aug2020'd    then trademonth = '16:JUL 2020'; else if '05aug2020'd < csa_inv_dte < '06Sep2020'd  then trademonth = '17:AUG 2020'; else if '05sep2020'd < csa_inv_dte < '06Oct2020'd   then trademonth = '18:SEP 2020'; else if '05oct2020'd < csa_inv_dte < '06Nov2020'd   then trademonth = '19:OCT 2020'; else if '05nov2020'd < csa_inv_dte < '02Dec2020'd  then trademonth = '10:NOV 2020'; else if '01Dec2020'd < csa_inv_dte < '06Jan2021'd  then trademonth = '21:DEC 2020'; else if '05Jan2021'd < csa_inv_dte < '06Feb2021'd  then trademonth = '22:JAN 2021'; else if '05Feb2021'd < csa_inv_dte < '06Mar2021'd  then trademonth = '23:FEB 2021'; else if '05Mar2021'd < csa_inv_dte < '01Apr2021'd  then trademonth = '24:MAR 2021'; else if '31Mar2021'd < csa_inv_dte < '01May2021'd then trademonth = '25:APR 2021'; else if '30Apr2021'd < csa_inv_dte < '01Jun2021'd   then trademonth = '26:MAY 2021'; else if '31May2021'd < csa_inv_dte < '01Jul2021'd   then trademonth = '27:JUN 2021'; else if '30Jun2021'd < csa_inv_dte < '01Aug2021'd  then trademonth = '28:JUL 2021'; else if '31Jul2021'd < csa_inv_dte < '01Sep2021'd   then trademonth = '29:AUG 2021'; else if '31Aug2021'd < csa_inv_dte < '01Oct2021'd  then trademonth = '30:SEP 2021'; else if '30Sep2021'd < csa_inv_dte < '01Nov2021'd  then trademonth = '31:OCT 2021'; else if '31Oct2021'd < csa_inv_dte < '01Dec2021'd  then trademonth = '32:NOV 2021'; else if '30Nov2021'd < csa_inv_dte < '01Jan2022'd  then trademonth = '33:DEC 2021'; else if '31Dec2021'd < csa_inv_dte < '01Feb2022'd  then trademonth = '34:JAN 2022'; else if '31Jan2022'd < csa_inv_dte < '01Mar2022'd  then trademonth = '35:FEB 2022'; else if '28Feb2022'd < csa_inv_dte < '01Apr2022'd  then trademonth = '36:MAR 2022'; else if csa_inv_dte = .                                                then trademonth = '99: No Inv'; format trademonth $30.; run;   I need to add more dates every month to create the trademonth variable but I want to automate this process to automatically add new month's dates. Please assist me with this process. ... View more

Re: Help Please

by Quartz | Level 8 in New SAS User
‎06-03-2021 02:50 PM
2 Likes
‎06-03-2021 02:50 PM
2 Likes
Hey Reeza, I used your suggestion of updating my join condition. It worked! Thank you for your input. I appreciate it. ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎02-09-2023 11:27 AM
Likes given to
Likes from
View All
Quick links