topic Year Function in Proc Sql in SAS Procedures

Year Function in Proc Sql

UrvishShah — Thu, 15 Mar 2012 19:00:45 GMT

Hi All,

I stuck at one place where i am getting remerging note like this -

NOTE: The query requires remerging summary statistics back with the original data.

You can view the data in attachment and syntax below

proc

sql

;

Here year function is not working in where clause.

create

table neworder

select

a.orderid,sum(b.UnitPrice * b.Quantity) as

Sales

from

data.orders as

data.Order_details

where

a.orderid=b.orderid

and

year(orderdate) = 1996

;

quit
;

Reeza — Thu, 15 Mar 2012 19:19:53 GMT

Orderdate is a DATETIME field, not a date. so you need to get the datepart first and then the year

ie. year(datepart(orderdate))=1996

UrvishShah — Thu, 15 Mar 2012 19:28:17 GMT

Thanks for getting me.