Hello, I've read 'date' related posts but they couldn't help my problem. Here is what bothering me: The sas file came in with a date variable, rev_dt. For example, '20040525', a length of 8, format Best12., informat 12. The raw data also filled in '0' for the observations without a date. However, seems I cannot reformat/or delete the original format of the variable. I tried multiple ways to work with the problem: 1. I tried newname=put(rev_dt, yymmdd10.) at data step. The new variable only showed '*********' for all observations like '20040525', unreadable. The '0' were successfully converted to '1960-01-01'. 2. I tried to informat or format at datastep: data try; format rev_dt yymmdd10.; set try; run; Again, '0's were converted successful. But observations like '20040525' stayed exactly the same. I always got the error message saying "There was a problem with the format so Best. was used", or "Mathematical Operations could not be performed" when I substract yr=year(rev_dt). 3. If I do: data try; format rev_dt date.; set try; run; Then '20040525' and all other similar observations became '2.004E7'. '0's became '01Jan60'. I need the convertion so that I can append this data file with the second one (with dates format like 2004-05-25) and delete the duplicates. Right now after the append, duplicated dates would not go because they are listed differently. I have tried to conver the second dataset into '20040525' format, but the duplicated dates would not be deleted either even when they looked exactly the same. Anyone can give me some help? Greatly appreciate it! Thank you! Wendy
... View more