Greetings All I need to convert a SAS EG date format to EXCEL date format because the particular report will be distributed as an EXCEL file. The SAS code displays the date as 09MAY2023 (DATE9), whereas the EXCEL file has to display the same date as 9-MAY-23 (d-mmm-yy). The SAS EG Query Builder Modify Task dialog box allows changing format, but the needed EXCEL date format doesn't appear in the drop-down list of formats. There is an 'Expression:' field in the 'Properties' dialog box - Is there a conversion expression I can use to convert the date?
... View more