topic Re: filter date entered in where clause in SAS Programming

filter date entered in where clause

GN0001 — Sun, 05 Dec 2021 21:31:01 GMT

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

Re: filter date entered in where clause

Kurt_Bremser — Sun, 05 Dec 2021 21:49:05 GMT

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

Re: filter date entered in where clause

ballardw — Sun, 05 Dec 2021 22:32:54 GMT

@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.