Breaking out a date from a date/time variable

DanielQuay — Fri, 22 Oct 2021 14:32:20 GMT

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.

Re: Breaking out a date from a date/time variable

PaigeMiller — Fri, 22 Oct 2021 14:41:27 GMT

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.

topic Re: Breaking out a date from a date/time variable in SAS Programming

Breaking out a date from a date/time variable

Re: Breaking out a date from a date/time variable