topic want max of coulmn in Statistical Procedures

want max of coulmn

rkolupoti9001 — Fri, 21 Nov 2014 15:57:07 GMT

Hi i have a data format as below and all are characters

Want row only has max of year_month example:

art297 — Fri, 21 Nov 2014 16:27:39 GMT

The following should work:

proc sql;

create table want as

select *

from have

group by id_1

having year_month=max(year_month)

;

quit;

sas_null_ — Fri, 21 Nov 2014 16:51:20 GMT

You can also try this approach

PROC SQL;

CREATE TABLE WANT AS

SELECT t1.id_1,

t2.id_2,

t2.year_month

FROM (SELECT id_1,

/* max_year */

(MAX(INPUT(year_month,6.))) AS max_year_month

FROM HAVE

GROUP BY id_1) t1, (SELECT id_1,

id_2,

year_month,

/* year_month numeric */

(INPUT(year_month,6.)) AS year_month_num

FROM HAVE) t2

WHERE (t1.id_1 = t2.id_1 AND t1.max_year_month = t2.year_month_num);

QUIT;