Hello, I am very new to SAS and I have a question, and I apologize if I am not clear or descriptive enough. I imported data from excel into SAS and I need to change the dates. Not every cell has a date. The blank cells are filled with a double hyphen --. The column attributes are character and the format and informat is $18. My question is how do I change the below date to month and year. Below is an example of how it looks like. Thank you for all of your help. Date -- -- -- -- -- -- AUG 05, 2015@15:30 AUG 05, 2015@15:30 -- -- -- -- -- -- AUG 03, 2015@17:20 AUG 03, 2015@17:20 AUG 03, 2015@17:20 AUG 03, 2015@17:20 AUG 03, 2015@17:20 AUG 03, 2015@17:20 -- -- -- --
... View more