就是Year, 比如 YEAR(Date) 返回相应年份

thanks,but still not working

data dateset;
        set dateset;
        format Date mmddyy10.;
        proc print data=dateset;
        run;

proc sql;
    create table table1 as
      select distinct year(Date) as year,count(year) as daysofTm90
        from dateset
                where TmaxF>=90
                group by year;
                quit;

Log  proc sql;
79       create table table1 as
80         select distinct year(Date) as year,count(year) as daysofTm90
81           from dateset
82           where TmaxF>=90
83           group by year;
ERROR: The following columns were not found in the contributing tables: year.

try this

proc sql;
     create table dateset1 as
     select distinct year(date) as year ,count(year(date)) as Tm90
from dateset
where TmaxF>=90
group by calculated year;
quit;

it works, thanks very much!!!!!!!!!!!!!!!!