I am trying to convert a date currently in character form to correct format, but my code is changing the date. Could anyone please point out what I am doing wrong?   mthyr_birth (existing data) Jun2001 Feb1954 Feb1984   My code: data want; set have; mthyr_birth2 = input(mthyr_birth, MONYY.); format mthyr_birth2 MONYY.; run;   mthyr_birth2 (output) JUN20 FEB19 FEB19   Many thanks ... View more

Hello!   I have a dataset with multiple entries per ID, and would like to condense to a single entry per ID, which shows is any of the entries were positive for a given variable.   Eg What I have: ID         A          B 1          0          0 1          1          0 1          0          0 2          1          1 2          0          0 2          0          0 3          0          0 3          0          0 3          0          0   What I want: ID         Any_A  Any_B 1          1          0 2          1          1 3          0          0     Many thanks ... View more