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: 
SaraDob
‎08-29-2018
  • 3 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Date conversion from Today() to yymmddN8 format

by Calcite | Level 5 in SAS Programming
‎08-28-2018 02:58 PM
‎08-28-2018 02:58 PM
Hello! Still new to SAS world and certainly very new to date conversion. The query I'm trying to run, has dates, that has to be changed every day. the date plugged inside the query has to be in yymmddN8 format( eg: 20180827) can you please let me know how do you convert tSAS today() date to the above said format.   Also I have a condition to verify , if the today is friday, get today date and sunday date also. Please help! ... View more

Date Macros or Functions?

by Calcite | Level 5 in SAS Programming
‎08-09-2018 06:04 PM
‎08-09-2018 06:04 PM
I'm Tasked to automate SAS programs on a windows task scheduler.Please note I'm a very new SAS developer.I have been reading about changing dates in program automatically There are dates on these few SAS program, which we change manually everyday and run it. Here are the situation of dates in the program: 1. Date= Today's Date. But if it is a Friday,Include dates between today(friday) and Sunday. Where Date_received=20180809(today) Where Date_received between 20180810 and 20180812   2. Date=Previous Date. But if it is Monday, Change date to Friday Date. Where Date_received=20180807 If the program run on Monday, then ,  Where Date_received=20180810   3.Date=Last Sunday through Saturday If the program run on Monday(say August 13), then ,  Where Date_received >20180805 and Date_received <20180811    I have been reading about MACROS and SAS functions. Please help me figure out , if it is better with Macros or date functions. Also, if possible, point to articles to write ( or better help me write) the Macros for these date functions.   Hopefully it is the right forum im posting into..( Base SAS programming forum).  -Thanks SHree     ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎08-29-2018 11:03 AM
Quick links