topic datepart function doesn't return the datepart in SAS Programming

datepart function doesn't return the datepart

GN0001 — Mon, 08 Aug 2022 19:25:22 GMT

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

Re: datepart function doesn't return the datepart

ballardw — Mon, 08 Aug 2022 19:50:24 GMT

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.

Re: datepart function doesn't return the datepart

Kurt_Bremser — Mon, 08 Aug 2022 21:54:04 GMT

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

Re: datepart function doesn't return the datepart

GN0001 — Fri, 12 Aug 2022 00:35:01 GMT

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