Breaking out a date from a date/time variable

[DanielQuay]

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.

[PaigeMiller · Accepted solution]

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.