datepart function doesn't return the datepart

[GN0001]

Hello team,

I have a dateTime as numeric as 06oct22:10:03, when I put datepart function to get the datepart of the variable, the time function still exists in the reuslt.

Date1 = put(datepart(date2,date9.)

Can someone help me with this?

Thanks,

blue blue

[ballardw]

LOG. Read it.

If you actually submit that code you are missing a )

40   data example;
41     x='06oct22:10:03'dt;
42     y=put(datepart(x,date9.);
                        ------
                        386
                        76
ERROR 386-185: Expecting an arithmetic expression.

ERROR 76-322: Syntax error, statement will be ignored.

43   run;

Should be:

44   data example;
45     x='06oct22:10:03'dt;
46     y=put(datepart(x),date9.);
47   run;

The result is 06OCT2022.

Or use a different FORMAT:

data example;
  x='06oct22:10:03'dt;
  y=put(x,dtdate9.);
run;

The DTDATE format displays a datetime with just the DATE9 equivalent portion.

So if your code isn't working you either have an issue with the values, the syntax or possibly both.

Although I question a need for that creation of a character value for dates. They don't sort well, at least not in Date9 format, cause extra work if you need to compare to an actual date value elsewhere, cannot be used in any of the date functions like Intnx or Intck, use formats to modify group creation for analysis, reporting or graphing.

[GN0001]

Hello team, I have not tested it. Please give me some time to test it. Blue berry

[Kurt_Bremser]

Show us the complete log of the step where this seems to happen.