I have a date in my data named actual_dlvry_date. It looks like this:
05/21/2016
ad_dt_char=PUT(datepart(actual_dlvry_date), mmddyy10.); * Convert to a char value ;
I'm attempting to make a character version of the date using this code, but my date value comes out as:
01/01/1960
Any suggestions for what I may be doing wrong here?
Remove the DATEPART.
DATEPART assumes the variable is a datetime which is a count of seconds at heart. Date values are counts of days. So since there are many fewer days when treated as seconds the date portion is often going to correspond to 0 or the base SAS date of 1/1/1960.
Remove the DATEPART.
DATEPART assumes the variable is a datetime which is a count of seconds at heart. Date values are counts of days. So since there are many fewer days when treated as seconds the date portion is often going to correspond to 0 or the base SAS date of 1/1/1960.
The datepart function is used to extract the date from a datetime value. Your date is not a datetime value, datetime values look like 01feb94:8:45. To convert your number date to character, you simply need a put statement with no datepart. Like this:
ad_dt_char=PUT(actual_dlvry_date, mmddyy10.); * Convert to a char value ;
Does this answer your question?
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 16. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: