If you only need the ids, then use something like
proc sql;
create table id_list as
select distinct first_name, last_name, birth_date, sex
from table1;
quit;
... View more
It is good practice to assign some sort of date format to the result of a date value creation so us humans can see what date SAS resovled the value to.
Sometimes people think there text variable is in a layout such as mm/dd/yyyy but SAS reports errors becaus the values are actually dd/mm/yyyy. Or they are mixed. 05/04/2017: is this actualy May 4 or Apr 5. The ones that do not get an error may give you some hints when you look at them.
... View more
Given that input: 10 1/7 04/12/13 04/12/2013 10 10.1 10weeks 10w1d 101/7 weeks it would be nice if the original poster could indicate his interpretation of the value required
... View more
