I've been fighting with this one and it's time to just ask for help.
I tried other solutions from the community forums but they didn't work
So let's call the variable RPT_DATE. The data I received is formatted like: 3/11/2020 9:01:54 AM
When I import this it appears as 11MAR20:09:01:54 Format as DATETIME. Informat ANYDTDTM40.
What I need to do is convert this so that it reads as 03/11/2020.
I'm sorry, I am sure this is simple but I have struck out at this point.
Use the DATEPART function. In a DATA step:
date_only=datepart(rpt_date);
format date_only mmddyy.;
What I need to do is convert this so that it reads as 03/11/2020.
Adding, this is often a poor choice to format dates, as the above date can be interpreted as March 11 or November 3. So I recommend you avoid using this format if at all possible.
Use the DATEPART function. In a DATA step:
date_only=datepart(rpt_date);
format date_only mmddyy.;
What I need to do is convert this so that it reads as 03/11/2020.
Adding, this is often a poor choice to format dates, as the above date can be interpreted as March 11 or November 3. So I recommend you avoid using this format if at all possible.
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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: