I want to calculate maximum number of times a value appear by group. For example, in the table below, 11 appears thrice in a group value of 1 and 22 appears twice in a group value of 1. So i want 1 11 in a row as 11 appears maximum times. Same logic holds for a ID value of 2. In that case, 12 22 should come out in a row. In the final output table, i need 2 rows as explained above.   ID ID2 1 11 1 11 1 11 1 22 1 22 2 12 2 12 2 12 2 16 ... View more

I want to add serial number to the unique values of each group. See the snapshot below-     data xyz; input x $; cards; AA AA AA BB BB ; run; proc sql; select a.x, b.N from xyz a inner join (select x, monotonic() as N from ( select distinct x from xyz)) b on a.x=b.x; quit;     How we can do it with data step? ... View more

I have added constraints into a table but it removes it when someone overwrites the table. Is there any way to prevent it?     DATA TEMP; SET SASHELP.CLASS; RUN; PROC SQL; ALTER TABLE TEMP ADD CONSTRAINT NOT_NULL_WEIGHT NOT NULL(WEIGHT); QUIT; DATA TEMP; SET TEMP; IF AGE >=15 THEN WEIGHT = .; RUN;   ... View more