Hi you can use proc sql, order by, month() and case when for convert numeric month to char for example:: *dataset input; %let data_in=SASHELP.CITIDAY; *campo date numerico DATE9.; proc sql; create table cityday0 as select a.date, year(a.date) as year_num, month(a.date) as month_num, (case when month(a.date) =01 then 'JAN' when month(a.date) =02 then 'FEB' when month(a.date) =03 then 'MAR' when month(a.date) =04 then 'APR' when month(a.date) =05 then 'MAY' when month(a.date) =06 then 'JUN' when month(a.date) =07 then 'JUL' when month(a.date) =08 then 'AUG' when month(a.date) =09 then 'SEP' when month(a.date) =10 then 'OCT' when month(a.date) =11 then 'NOV' when month(a.date) =12 then 'DEC' else 'None' end) as mese_char, day(a.date) as day_num from &data_in. as a order by year_num, month_num, mese_char, day_num; quit;
... View more