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: 
sas940
‎11-23-2020
  • 3 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Date formats

by Calcite | Level 5 in SAS Programming
‎11-23-2020 04:16 PM
‎11-23-2020 04:16 PM
So, now I have   month that reads as 202010 and I have left_date that reads as 22OCT2020   I would like to be able to "read" left_date as 202010 the sasme as MONTH reads.     Then in y final dataset I can match the records that have the same month end, 202010, and left_date.   ... View more

Re: Date formats

by Calcite | Level 5 in SAS Programming
‎11-23-2020 04:11 PM
‎11-23-2020 04:11 PM
THank you.  I cannot comment on the "why" between the 11.1 as that is simply what I see.  My apologies  ... View more

Date formats

by Calcite | Level 5 in SAS Programming
‎11-23-2020 03:46 PM
‎11-23-2020 03:46 PM
I know this should be easy but I have not done SAS in over 10 years and I am trying to get back into it.   I have two date fields   NAME             TYPE                  LEN                  FORMAT                INFORMAT MONTH            NUM                    8                       11.1                          11.1 left_date            NUM                    8                       DATE9.                    DATE9.   MONTH looks like:    202010 left_date looks like: 15DEC2020   All I want to do is create a dataset where I get those values for each variable with the same MONTH and YEAR..  I have tried reformatting left_date using format new_Co_Date YYMMN.; but to no avail.    I would want to do, last step, where month_end= left_date (or with applicable new variable name(s)).   Any help is greatly appreciated.   Thank you   ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎11-23-2020 07:39 PM
Quick links