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: 
JohnWiz
‎09-01-2015
  • 2 Posts
  • 0 Likes Given
  • 0 Solutions
  • 1 Likes Received

How do I turn ddMMMyyyy into one day prior?

by Calcite | Level 5 in SAS Procedures
‎08-09-2011 04:50 PM
‎08-09-2011 04:50 PM
awesome.  hadn't even bother trying a proc yet.  Thanks a bunch. ... View more

How do I turn ddMMMyyyy into one day prior?

by Calcite | Level 5 in SAS Procedures
‎08-09-2011 04:43 PM
1 Like
‎08-09-2011 04:43 PM
1 Like
I have a table with a column containing Effective Dates in DDMMMYYYY format.  Expiration Date values don't exist on the table so I need to create my own values for 'Expiration Date'.  I need to Select (EFFECTIVE_DATE - 1 as EXPR_DATE) essentially so that if the Effective Date reads 02APR2011 the new field EXPR_DT will show 01APR2011. Can anyone help me please? ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎09-01-2015 07:11 AM
Likes from
View All
Quick links