filter date entered in where clause

[GN0001]

Hello team,

I have a date variable in a dataset and shows its data type as number and it is formatted as 2020-02-19.

I need to filter data in a where clause in proc sql and pull only the year. How can I do it?

Regards,

blueblue

[Kurt_Bremser]

Use the YEAR function to extract the year from a date.

[ballardw · Accepted solution]

---

@GN0001 wrote:

Hello team,

I have a date variable in a dataset and shows its data type as number and it is formatted as 2020-02-19.

I need to filter data in a where clause in proc sql and pull only the year. How can I do it?

Regards,

blueblue

---

Example dummy program:

Proc sql;
     create table dummy as
     select *
     from some dataset 
     where year(datevariablename) = 2020
     ;
quit;
/* or if looking for multiple values of year with IN operator
    where year(datevariablename) in (2018 2020)
*/

However if your data source is not a native SAS dataset such when connecting to an external database this may not work depending on a number of factors.