Thanks so much for the help, I really appreciate it. This worked perfectly and completely fixed my issue!!! ... View more

@pengaentu wrote: I am mapping a data set from one program to another. When exported from the first program, the dates are all formatted as mm/dd/yyyy. In order to import the data into the second program, the dates must be formatted as yyyy/mm/dd. I am currently able to set this format in SAS, but when I export the data to excel, the date formats change back to mm/dd/yyyy. Is there a way to keep them as yyyy/mm/dd when exported? If you want Excel to display dates in a particular style you need to tell Excel that fact.   How did you export the data to an Excel file?   What is the second program? Is it a SAS program?  Why use an Excel file?  Why not just write a CSV file instead? ... View more

Thanks so much for the help this worked perfectly! ... View more