Hey SAS Community, I am new to SAS and I have a Problem with extracting the year from a csv-file with multiple dateformats. The field 'date' in my csv file has formats like: dd-mm-yyyy like 20-03-2014 or 01-10-2015 dd/mm/yyyy like 10/10/2014 d/mm/yyyy like 1/10/2013 dd/m/yyyy like 13/4/2010 d/m/yyyy like 3/3/2012 I tried to solve it in different ways and searched in different forums, unfortunately I am not able to solve the problem. Any help would be very appreciated. Best Greetings, Peter Edit: Whats also is weird in my txt-editor i can see the different formats, but on sas's result view it shows only one format.
... View more